If possible I need to create a query with data from all 4 or 5 weeks in a
period, layed out in columns like a spreadsheet. Example:
W/E 2/5/05 W/E 2/12/05 W/E 2/19/05 W/E
2/26/05
Number Dollar Number Dollar Number Dollar
Number Dollar
1 $15 1 $5.97 4 $15.99
1 $40.00

The user runs this report by week, so what can I do to "capture" the week
ending dates, along with the number and dollar amounts so I can add each week
as I go along? The week ending dates are in a table joined to the table
containing the number and dollar fields. Thanks for any help I can get on
this!