Create This Report?

[Djblois]

I have a table in Access with Employee Name, Position (selector, Loader, Reacher, etc) and Location (Cool, Dry, Freezer). I now need to create a report that mimics the picture I sent. I know how to do it with 12 subreports and 12 queries. Does anyone have any idea how I can reduce the number of subreports or queries?

[theDBguy]

Hi. Maybe you really only need to create one subreport but use it twelve times on the main report.

[Djblois]

can you use the same subreport 12 times on one report? you cannot do that with the same subform multiple times on a form. Also how would I have each subreport query based on different criteria?

[theDBguy]

Originally Posted by Djblois

can you use the same subreport 12 times? you cannot do that with subforms? Also how would I have each subreport query based on different criteria?

Yes, you can, and you can also do the same with subforms. As an example, take a look at some Calendar demos, especially the ones that display appointments or events for each day of the calendar. You might see the same subform is used for each date on the calendar form.

[Djblois]

I just tried it. In the past I always assumed the subform showing up all white in design view meant it would not work. Well I just ran the form ant it works. However, how do I make it so they each have their own query?

[theDBguy]

Originally Posted by Djblois

I just tried it. In the past I always assumed the subform showing up all white in design view meant it would not work. Well I just ran the form ant it works. However, how do I make it so they each have their own query?

You could try using code to do that. If you found an Calendar example, you might see the author simply used the Linked Master/Child Fields to show different data in each subform.