Shoutbox

Okay, well i have this project I'm doing and i need some guidance.

Basically, i have to create 2 queries, and I'm not quite sure how to do it.

I have tables that contain information about

a) the sales people (address, suburbs they work in, name, surname etc)
b) the customers (name, surname, address, product purchased, sales person)
c) the products (product name, price and details about the product)

Basically, i have to link these tables in the query to

a) find how many sales each sales person has made and sort them by the suburb in which they're sold in and;
b) Find out which products are being sold more than others

Basically, i don't know how to link the queries together to create this information. I'm not looking for a direct answer, but guidance and tips on how to figure it out - or maybe even an example of something similar to this, as i wish to be able to do more of these in future.

Thanks in advance.

You probably can do this through Access GUI query designer, but I don't know how (I don't use Access much).  If you right click in the query designer, the menu lets you choose SQL view, where you can directly edit the SQL query.

Should you wish to do it that way (I would), the SQL keywords and functions you should look up up are JOIN, COUNT(), GROUP BY, ORDER BY and possibly HAVING.  You should keep in mind that you can join the same table in a query more than once, if needed. All of these are features of SELECT query and documented here.

I happen to be doing a project using Microsoft Access myself.
I used Relationships to link tables together with. I could then create a query really easy.

Relationships
Hope this helps.

quote:

---

Originally posted by Knuckles
I happen to be doing a project using Microsoft Access myself.
I used Relationships to link tables together with. I could then create a query really easy.

Relationships
Hope this helps.

---

Thanks for your reply

The thing is, i don't have a customer ID or anything along those lines in my tables...just names. So figuring out what to link together is what my real dilemma is.