How to create Report showing All Product Sales by period ?

[Mel]

We want to create a report that will show all product sales by
period... that looks like this...

idProd Product Period QtySold Total_Sales
00001 Prod-1 2007 100 $3,500
00001 Prod-1 2008 250 $9,200
00001 Prod-1 2009 95 $3,000
00002 Prod-2 2007 10 $875
00002 Prod-2 2008 25 $2,150
00002 Prod-2 2009 15 $1,200
00003 Prod-3 2007 etc

I can create 3 identical queries... but each with a different date
range criteria...

But how do I get them to show
.... the Prod-1 listings one after the other
.... then the Prod-2 listings one after the other
.... then Prod-3
etc

Thanks for any help

 

[Jeff Boyce]

It all starts with the data ... and you've only shown us what you want it to
look like "after", in your report.

Please give us an idea how you are storing your data... "how" depends on
"what".

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Mel_3]

The data is stored in several underlying tables.
tblProducts, tblOrders, tblItems, tblCustomers

and I retrieve the data with a query...
qry_Sales

there are more fields in the query but I only showed a few.
fields of interest are...
idProduct
Product_Name
Date_Sold
Qty_Sold
List_Price
Discount
etc

In the Report Qty_Sold and Total_Sales are fields calculated in the
Report

The Period field in the Report would be the results of an IIF
statement in the Report... that IIF statement would bracket the sales
date and print the period... in the example I used... the year.

I just don't know how to get the Prod_1 sales to print one after the
other... sorted by period...
then have the Prod_2 sales print in the same way...
then Prod_3, etc.

Thanks for the help.

 

[Jeff Boyce]

If your query is returning the correct data, in the correct order
(sorting...), you may still need to use the report definition's Sorting and
Grouping features to get the report to "honor" the sorting you are after.

Regards

Jeff Boyce
Microsoft Office/Access MVP