Pivot/Transpose on a Access Report??? (PLEASE HELP)

[Michael Kintner]

I have a Access Report that shows like this.

Date Amount Cost
1/2/2008 23 $1.25
1/4/2008 18 $1.10
1/6/2008 15 $0.90

I would like to report to pivot on Date (show in columns) and have the
amounts follow within those columns under the date as shown below.

1/2/2008 1/4/2008 1/6/2008
23 - $1.25 18 - $1.10 15 - $0.90

The problem is the dates can change so how can I get the report to display
like this?

It looks simple and can be done in Excel but I need it to display in a
Access Report. Any ideas???

Thank you in advance for your help!!

Mike

 

[Duane Hookom]

Are the dates always 2 days apart? Are you always looking for a specific
number of dates?
There is a solution if the interval and number of columns are always the
same at http://www.tek-tips.com/faqs.cfm?fid=5466.