HOW TO CREATE SUMMARY INFO

[KEN11]

i HAVE orders that require a certain amoun of a product. Each day several orders require varying amounts of several products. I want to summarize the amount required by day, week, month, 3day period, past due , future etc. How can I querry my orders by date and total the amount required by day, month etc.?

 

[Jonathan]

You should be able to do this using the report wizard. If you create a new report based on your table, using the wizard, it allows you to select fields to group by, and gives you options. So if you select your date field to group by, then click the "Grouping Options" button, you can choose whether to group on each value, or by month, year etc. It will also give you the option to total fields up for each group. This sounds like it is what you will need.<br>
<br>
Jonathan

 

[calahans]

Use the group by function in SQL:<br>
<br>
SELECT DATE , SUM(ORDERS) 'TOTAL'<br>
FROM TABLE<br>
WHERE DATE BETWEEN [DATE1] AND [DATE2]<br>
GROUP BY DATE<br>
<br>
This can be taliored for any query<br>
<br>
C