Field list

A

ajk

My report need data from two tables, I can currently only see one tables
fields as it was set up to handle data from one table, but I want to add more
fields from a different table to my report, how can I see the fields from
both those tables in Design view?

Thanks again
 
D

Duane Hookom

Open the report in design view and display the properties dialog. Find the
Record Source property and click the [...] button. This places you in query
design where you can add your second table. When finished, close the query
design to go back to your report design.
 
A

ajk

Thanks for your advice.

ajk

Duane Hookom said:
Open the report in design view and display the properties dialog. Find the
Record Source property and click the [...] button. This places you in query
design where you can add your second table. When finished, close the query
design to go back to your report design.

--
Duane Hookom
MS Access MVP


ajk said:
My report need data from two tables, I can currently only see one tables
fields as it was set up to handle data from one table, but I want to add
more
fields from a different table to my report, how can I see the fields from
both those tables in Design view?

Thanks again
Click to expand...
Click to expand...
 
Top