Report Formatting

[Paul S.]

I am trying to print out a report that has the following
format:

Name1 Name2 Name3
Date1 h1,h2,h3 h1,h2,h3 h1,h2,h3
Date2 h1,h2,h3 h1,h2,h3 h1,h2,h3
Date3 h1,h2,h3 h1,h2,h3 h1,h2,h3

In other words, the names of the people, and the different
types of hours they work are displayed under their name
for that specific date.

I can get all the relevant info into a query (crosstab
wont work b/c there are 3 field for every person and date
that must be displayed), but i am not sure how to display
this information into a report.

Any help is greatly appreciated.

Thanks alot,

Paul S.

 

[Jen]

Hi Paul,

This sounds like a job for excel pivot tables. Access
crosstabs won't allow you more than 1 "value" field, but
excel will.

From excel>>Data>PivotTable and PivotChart Report...then
you'd point excel to your access db, select the query,
etc. Excel takes you through a wizard that's really
straight forward.

Regards,
Jen

 

[Guest]

Hi Jen,

Thank you!

-----Original Message-----
Hi Paul,

This sounds like a job for excel pivot tables. Access
crosstabs won't allow you more than 1 "value" field, but
excel will.

From excel>>Data>PivotTable and PivotChart Report...then
you'd point excel to your access db, select the query,
etc. Excel takes you through a wizard that's really
straight forward.

Regards,
Jen

.