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

Hi All,

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

"TP88" wrote:

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

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.

"TP88" <(E-Mail Removed)> wrote in message
news:E3977475-8C9F-4B15-B913-(E-Mail Removed)...
> How to add more that one tables or queries to report record source? In
> Access
> 2003.

Or use subreports, charts, or code.

--
Duane Hookom
Microsoft Access MVP


"Jeff Boyce" wrote:

> 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.
>
> "TP88" <(E-Mail Removed)> wrote in message
> news:E3977475-8C9F-4B15-B913-(E-Mail Removed)...
> > How to add more that one tables or queries to report record source? In
> > Access
> > 2003.
>
>
> .
>

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"TP88" <(E-Mail Removed)> wrote in message
news:E3977475-8C9F-4B15-B913-(E-Mail Removed)...
> How to add more that one tables or queries to report record source? In
> Access
> 2003.

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?

"Allen Browne" wrote:

> 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.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
>
> "TP88" <(E-Mail Removed)> wrote in message
> news:E3977475-8C9F-4B15-B913-(E-Mail Removed)...
> > How to add more that one tables or queries to report record source? In
> > Access
> > 2003.
>
> .
>

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

TP88 wrote:
> 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?
>
> "Allen Browne" wrote:
>
>> 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.
>>
>> --
>> Allen Browne - Microsoft MVP. Perth, Western Australia
>> Tips for Access users - http://allenbrowne.com/tips.html
>> Reply to group, rather than allenbrowne at mvps dot org.
>>
>>
>> "TP88" <(E-Mail Removed)> wrote in message
>> news:E3977475-8C9F-4B15-B913-(E-Mail Removed)...
>>> How to add more that one tables or queries to report record source? In
>>> Access
>>> 2003.
>> .
>>