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/...ddbuz/threads?
"KARL DEWEY" wrote:
Crosstab query. Use the wizard to create it.
--
Build a little, test a little.
"Pass-the-Reality" wrote:
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???????