How to add more that one tables or queries to report record source

[TP88]

How to add more that one tables or queries to report record source? In Access
2003.

 

[TP88]

Hi All,

Add more than one tables or queries to report record source. Thanks.

 

[Jeff Boyce]

Create a new query in design view.

Add as many tables and/or queries as is appropriate.

Join them on their common fields.

Select fields from them to display in the output.

Save the query.

Run it to make sure it retrieves the data you want.

Create a report and point it to the new query as the data source.

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Duane Hookom]

Or use subreports, charts, or code.

 

[Allen Browne]

You may be able to create a query that combines the data from multiple
tables, and use that as the RecordSource of your report.

If that isn't enough, use subreports. Each subreport has its own
RecordSource.

 

[TP88]

Thank you all. I still have one more question. If I don't use subreports, I
can't not add more than one tables or queries directly as report record
source. Is it true?

 

[John Spencer]

Yes. You can only have one query or one table as the source for any one report.

You can get fairly complex with a query and have many tables used in the query.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County