Help with Query

[GreyhoundFan]

What I want to do with my data is a little beyond my knowledge base so I'm hoping someone can help me.

I want to do an analysis on an existing database of data which will tell me the sequence of products ordered for the whole database. The database order section is set up with the following fields (there are other fields just listing the relevant ones):

OrderID (Auto Number) - Primary Key
OrderDate (Date/Time)
ProdID (Number) - Linked to another db called Product
CustID (Number) - Linked to another db called Cust

What's the quickest way to figure out the product sequencing across all of the 250k+ orders? Thoughts, suggestions?

Thanks for your help,
JB

<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">

 

[SydneyGeek]

How are the tables related to each other?

Denis

 

[GreyhoundFan]

The tables are related to each other like this...

Order Table
OrderID (Primary Key)
OrderDate (not linked)
ProdID (linked to Product Table; Order Table = many, Product Table = 1)
CustID (linked to Cust Table: Order Table = many, CustID Table = 1)

Thanks,
JB

<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">

 

[SydneyGeek]

Build a query and add the three tables (Order, Prod, Cust) to the layout. The joins should be there if you have defined them in the Relationships view.

Add OrderID, OrderDate, ProductDescription, CustomerName to the grid. (adjust to suit real names)

By default, Access will sort by OrderID. If you would rather sort by OrderDate, double-click the Sort row under OrderDate so you see Ascending.

Run the query and see if that does the job.

Denis

 

[GreyhoundFan]

Thanks Denis for your advice! I greatly appreciate it.

I'll try it soon. I've actually figured out a way to get the info I need by using Excel. I'm sure it's the long way yet it works for what I need right now.

Thanks again! Have a great day today,
JB
<input id="gwProxy" type="hidden"><!--Session data--><input *******="if(typeof(jsCall)=='function'){jsCall();}else{setTimeout('jsCall()',500);}" id="jsProxy" type="hidden">