H
hughess7
Hi, I would like a report which prints out a weekly itinerary plan for our
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something similar. I
want a layout like below:
Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday
I am new to crosstab queries and tried to do one of these to diplay the info
but couldn't get it to work as the details I want displayed (audit, dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this format?
I will add a start and end date filter to a form to display which week I want
printed, I am just not sure how to get a report in this layout?
Thanks in advance for any help.
Sue
employees. I have looked at Duane Hookom's reports but they don't quite
achieve what I want and not too sure how to replicate something similar. I
want a layout like below:
Mon Tues Wed Thurs Frid
3 4 5 6 7
Fred Bloggs Audit Meeting Travel Audit Office
1234 4567
Jane Doe Audit Audit Audit Audit Audit
9876 9876 9876 9876 9876
Bilbo Baggins Holiday Holiday Holiday Holiday Holiday
I am new to crosstab queries and tried to do one of these to diplay the info
but couldn't get it to work as the details I want displayed (audit, dealer
no, etc) are the values of fields rather than a calculation. Can anyone
advise me how to produce a simple report displaying the data in this format?
I will add a start and end date filter to a form to display which week I want
printed, I am just not sure how to get a report in this layout?
Thanks in advance for any help.
Sue