Report

[Pass-the-Reality]

The Incurred Dates in my query run in rows. An example is below:

1/1/09 Date A 5.9
2/1/09 Data A 6.2
3/1/09 Data A 7.5

On my report I need to represent my dates as columns. Example below:
1/1/09 2/1/09 3/1/09
Data A 5.9 6.2 7.5

What is the easiest way to do this on a report without having to create a
new SQL statement. I am dealing with a lot of data. Any suggestions???????

 

[KARL DEWEY]

Crosstab query. Use the wizard to create it.

 

[Duane Hookom]

I would use the solution found at http://www.tek-tips.com/faqs.cfm?fid=5466.
You may need to change the month interval to days.
--
Duane Hookom
Microsoft Access MVP

NOTE: These public News Groups are ending June 1st. Consider asking
questions at http://social.answers.microsoft.com/Forums/en-US/addbuz/threads?