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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
52 queries - 1 report
I have more information. I have a table and it is set up in this way....Item,Description,Frequency,MHRS,Shift, Area, PM_W1,PM_W2,PM_W3 ALL THE WAY TO PM_W52. I need a weekly report so if I choose PM_W1 (criteria=yes) and the Area (criteria=1) then I get the report that looks like this: ITEM...- mliggett
- Post #6
- Forum: Microsoft: Access Reports
-
52 queries - 1 report
The queries are from the same table. Each query includes a specific field (for example 52 weeks, week 1 = yes) they also include a parameter for [Enter Area].- mliggett
- Post #3
- Forum: Microsoft: Access Reports
-
52 queries - 1 report
I inherited a database and don't want to scrap it. There are 52 queries which work great to run weekly data. They want these 52 queries in a report format that can be formatted with individual names added to the top. Is there an easy way to create 1 report and let the user choose the query...- mliggett
- Thread
- Replies: 6
- Forum: Microsoft: Access Reports
