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