Help combining reports

[stuart_adair]

Hi folks

I run and Access database that contains performance information at work. Each day a report is run which has a depot name and a performance figure and this gets sent out to all 30 depots as an email attachment using the "Send Object" macro function.

I've been asked to regionalise the reports instead of just sending them out in depot alphabetical order. There are 3 regions.

I've got all 3 individual reports built but I dont want to send 3 emails where I used to send just 1. I'd ideally like to have a single report that combines each of the reports I've already built, or alternatively have 1 email that sends 3 reports. Each of the regional reports I've built is identical in layout, it just takes data from a separete query.

I've been playing round with the grouping function but cant see a way I can achieve this.

Any help would be appreciated - Please note that I'm far from an expert so if you're getting into VBA I'll need lots of hand-holding

Thanks in advance
Stu

 

[stuart_adair]

Ok, no replies so how about plan B. How can I get access to attach more than one report to an email. The send object function will only allow 1. Thanks

 

[JHB]

What is the difference between the 3 queries, since it is necessary with 3 different queries?
Is the data comming from the same table?
How do you determine what it is one or the other region?

Each of the regional reports I've built is Identical in layout, it just takes data from a separete query.

Is it the same number of fields?

 

[stuart_adair]

Hi and thanks for the reply.

Each region has several locations and each report query just identifies those. Ie:- the query criteria goes something like = "Liverpool" or "London" or "Leeds". I've got 3 queries and 3 reports running which produce 1 for each region. Apart from the different criteria the repors are identical.

Another thought I had was to add a field called, "Region", create a table with all locations in one column and respective region in another and then use that field to group on one report. That would work a treat but it presents another issue for me which is how I would automatically populate the region field based upon the location when a new record is raised and how I would do the same for data already in the database ?

Thanks

Stu

 

[JHB]

There is no reason to have 3 queries and 3 reports, it can all be done with 1 query and 1 report.
Create a table of regions and locations that belong to the regions registered.
Just the way as you describe.

Then, you link fields locations together in your query.

Builds a loop that runs as many times as you have registered regions and transfer then regions to your quiry as a "parameter".
And for each pass you sends your report.