Creating Reports with Different Tables

  • Thread starter Thread starter Bethannye
  • Start date Start date
B

Bethannye

I have 3 different tables I would like to put into one report. The common
theme being the Route #. The tables are information on do not delivers,
required deliveries and notes.

Each route needs to have it's own page then it needs to pull from the tables
the the do not delivers, the required deliveries and notes. Having it's own
heading for each.

Can someone help me create this? Is it possible?
 
Put the three tables in a query and join then on Route#. This should return
all records from the tables where the Route# is the same. Then set your
report's recordsource to the query.

Alternatively, you can create a main report based on your Route table and
three subreports based on your three tables here.

Steve
(e-mail address removed)
 
Make a union query to gather all route numbers --
qryRoutes --
SELECT [Route #]
FROM [do not delivers]
GROUP BY [Route #]
UNION SELECT [Route #]
FROM [required deliveries]
GROUP BY [Route #]
UNION SELECT [Route #]
FROM [notes]
GROUP BY [Route #];

Then use it in your query and left join to the other 3 tables.
 
Then use it in your query and left join to the other 3 tables.

Can you explain how to do this?

KARL DEWEY said:
Make a union query to gather all route numbers --
qryRoutes --
SELECT [Route #]
FROM [do not delivers]
GROUP BY [Route #]
UNION SELECT [Route #]
FROM [required deliveries]
GROUP BY [Route #]
UNION SELECT [Route #]
FROM [notes]
GROUP BY [Route #];

Then use it in your query and left join to the other 3 tables.

--
Build a little, test a little.


Bethannye said:
I have 3 different tables I would like to put into one report. The common
theme being the Route #. The tables are information on do not delivers,
required deliveries and notes.

Each route needs to have it's own page then it needs to pull from the tables
the the do not delivers, the required deliveries and notes. Having it's own
heading for each.

Can someone help me create this? Is it possible?
Click to expand...
Click to expand...
 
Back
Top