Multiple Queries in One Report

[Gregc.]

Hi

I am trying to desing a report, that shows program by region. I need
to create multiple queries. Is the a way that I can use multiple
queries in one report, or is there a way that I could filter out the
required data in the report itself?

Greg

 

[tina]

why do you need multiple queries to pull program data for multiple regions?
in properly normalized tables, generally speaking, program data from all
regions would be in a single table, which would include a field to designate
the region each record belongs to. did you set up a separate table for each
region?

if that's the case, read up on Union queries, in Access Help - using a Union
query may solve your dilemma. also recommend you read up on normalization
principles, and seriously consider stopping where you are, re-examining your
tables/relationships, and modifying them to meet normalization standards if
necessary.

hth

 

[Gregc.]

why do you need multiple queries to pull program data for multiple regions?
in properly normalized tables, generally speaking, program data from all
regions would be in a single table, which would include a field to designate
the region each record belongs to. did you set up a separate table for each
region?

Because I want to have Region along the top row and output along the in
the first columns. In Order to do this, I have to write mutliple
queries, because each region can have more than one output, and I have
to report it separately. ie
Region 2 Region 2
output 1
output 2
etc
all the data will be on one table.