Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Layout Problem

Status
Not open for further replies.

Rjc8513

Technical User
Feb 12, 2001
140
US
I have a report that displays weekly data for the entire year, as follows:

Clerk Hours Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total

Manager Hrs Week 1 Week 2 Week 3... Week 13
Week 14 Week 15... Week 26
Week 27... Week 39
Week 40... Week52 Total

What I'd like to see is:

Clerk Hours Week 1 Week 2 Week 3... Week 13
Manager Hrs Week 1 Week 2 Week 3... Week 13

Clerk Hours Week 14... Week 26
Manager Hrs Week 14... Week 26

Clerk Hours Week 27... Week 39
Manager Hrs Week 27... Week 39

..., etc.

Is this a grouping issue? Can this be accomplished? Thanks.


 
I am thinking you can accomplish this by having or adding a field that somehow shows the week to the query and then sort on it in the report followed by position hours.

If that doesn't help, can you post the SQL for your rowsource?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top