April15Hater
Accountant
- Local time
- Today, 03:35
- Joined
- Sep 12, 2008
- Messages
- 349
Hi-
I have a query (qtrContractorProduction) that has 4 fields: TrackingNumber, Contractor, CompleteDate, and Units. What I would like to do is create a report (but I'm having trouble with the query) that shows the total units for each contractor by week. I need the columns to represent the separate weeks, and the rows to show each contractor. I think a crosstab query might be the best solution, but I can't figure out how to make the columns group by week. Any suggestions?
thanks,
Joe
I have a query (qtrContractorProduction) that has 4 fields: TrackingNumber, Contractor, CompleteDate, and Units. What I would like to do is create a report (but I'm having trouble with the query) that shows the total units for each contractor by week. I need the columns to represent the separate weeks, and the rows to show each contractor. I think a crosstab query might be the best solution, but I can't figure out how to make the columns group by week. Any suggestions?
thanks,
Joe