What happened to the Messenger Plus! forums on msghelp.net?
Shoutbox » MsgHelp Archive » Skype & Technology » Tech Talk » Help with Microsoft Access

Help with Microsoft Access
Author: Message:
J.J
Senior Member
****

Avatar
R.I.P Myles. Missing you.

Posts: 912
Reputation: 54
33 / Male / Flag
Joined: Nov 2004
Status: Away
O.P. Sad  Help with Microsoft Access
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.

This post was edited on 03-21-2007 at 06:01 AM by J.J.
[Image: bluesig5rz.png]
Previously known as \'lappin\' and \'Third Dimension\'

Damo says (12:00 AM):
-pictures harry potter naked-
03-21-2007 02:28 AM
Profile PM Find Quote Report
« Next Oldest Return to Top Next Newest »

Messages In This Thread
Help with Microsoft Access - by J.J on 03-21-2007 at 02:28 AM
RE: Help with Microsoft Access - by Adeptus on 03-21-2007 at 12:14 PM
RE: Help with Microsoft Access - by Knucks on 03-21-2007 at 03:41 PM
RE: Help with Microsoft Access - by J.J on 03-22-2007 at 04:59 AM


Threaded Mode | Linear Mode
View a Printable Version
Send this Thread to a Friend
Subscribe | Add to Favorites
Rate This Thread:

Forum Jump:

Forum Rules:
You cannot post new threads
You cannot post replies
You cannot post attachments
You can edit your posts
HTML is Off
myCode is On
Smilies are On
[img] Code is On