Thanks Bill. I was just wondering if there was a way to do it more systematically than manually filtering it and saving each filtered group.
I am aware that I can create a grouped report but when it is saved down to Excel, which is the format that we are distributing it in, the breaks disappear and there is still a need to manually separate the report.
________________________________
From: Bill Mosca <wrmosca@comcast.net>
To: MS_Access_Professionals@yahoogroups.com
Sent: Friday, July 27, 2012 1:43 PM
Subject: [MS_AccessPros] Re: Creating multiple output tables from a single query based on a field value
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 mailto:MS_Access_Professionals%40yahoogroups.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]
>
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar