Shipper225
Windows XP Access 2007
- Local time
- Today, 10:58
- Joined
- Jun 23, 2011
- Messages
- 69
I am using Access 2007 and am attempting to create a report similar to one I currently use in Excel. The issue I seem to be having is finding a way to have the data for each 'job' on the same line going from left to right lining up with the days of the month. I've attached a PDF of what I have and what I am trying to recreate. Any ideas would be helpful. Page one is what I have, page two is what I am hoping to replicate. As the attachment shows I am able to get the info in the report but for each day there is a shipment it creates a new line, I am hoping to combine all the same job shipments on one line to keep the report as short as possible.
Attachments
Last edited: