M
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
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