Dale, thanks for getting back to me. I'm somewhat confused. Since the week
ending dates are in 1 field, when I prompt the user for W/E 02/05/05 to get
that data, the next time she runs the query for the next W/E date all the
numbers will change to reflect that date. Don't I need a way to store the
W/E 02/05 values?

"Dale Fye" wrote:

You're not going to be able to get a query to return results that look like
that, but you could get a report to do so. Create a query that returns
results that look like:

WeekEnding Number Dollar
2/5/05 1 15.00
2/5/05 2 xx.yy
2/12/05 1 5.97
2/19/05 1 40.00

Now create a report based on this query. Group it by WeekEnding, and put
the [WeekEnding] field in the Group Header. Then put the Number and Dollar
titles in the the Group Header as well. Finally, put the [Number] and
[Dollar] text columns in the detail section.

Then, select File-Page Setup, then select the columns tab and indicate the
number of columns you want, the spacing between the columns, the width of
the columns, etc.

You may find that you want a header on the Report, in which case, I would
recommend making the report we created above a subreport that you mount
inside a report that has the Title, Page number, Date printed, etc.

HTH
Dale
"cottage6" wrote in message
news
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!