Daryl
There is no need to build separate tables. If the report is exactly teh same in design for all locations all you do is filter the report by location. If you want the report to print each location on a separate page you can do that, too.
Please give us a bit more information and we'll walk you though the process.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile=C4D9F5E7-BB03-4291-B816-64270730881E
My nothing-to-do-with-Access blog
http://wrmosca.wordpress.com
--- In MS_Access_Professionals@yahoogroups.com, Daryl Walke <darylwalke@...> wrote:
>
> I am trying to create a query that will provide multiple output tables based on the value of a field. For example: the original table has a field based on location for which I need to have individual reports for each of these locations. Is there a way to do this in Access so that there could be separate output for each location?
>
> Thanks!
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar