Reports

  • Thread starter Thread starter Megan
  • Start date Start date
M

Megan

How do I create a report with headers along the top and
side. For example...I want to create a report that shows
employees down the left hand side, weeks at the top and
hours in the centers...
 
Megan:

What you want to do is to create a cross tab query, grouping on the name or
ss# or some other Identifier as the Row Heading. The column heading would
be the weeks (i.e. use the Format function on what ever date field you have
to return the week), and the the Value for the cross tab would be the hours
set to sum.

Then your report should be easy to lay out.
 
Thanks! I figured this out shortly after! LOL
-----Original Message-----
Megan:

What you want to do is to create a cross tab query, grouping on the name or
ss# or some other Identifier as the Row Heading. The column heading would
be the weeks (i.e. use the Format function on what ever date field you have
to return the week), and the the Value for the cross tab would be the hours
set to sum.

Then your report should be easy to lay out.
--
Steve Arbaugh
ACG Soft
http://ourworld.compuserve.com/homepages/attac-cg




.
Click to expand...
 
Back
Top