Field list

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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...
 
Back
Top