Report Fields

  • Thread starter Thread starter Paul Allen
  • Start date Start date
P

Paul Allen

Hi

I used the wizard to create a report. I selected many
fields from 5 different tables and the created the report
easily enough.

I now need to make some modifications and add some new
fields from a new table. How can I get the report to
accept this extra table and fields? or do I have to
start the report from stratch.

Cheers
 
Paul,
A report can have only one table or one query as it's record source.
Since you have 5 tables used in the report, you have a query (or SQL) as the
report record source.
Click on the RecordSource property line, then on the button with the 3 dots
that will appear.
Add the new table to the upper panel using the Show Tables dialog.
Make sure the relationships are set properly.
Then drag the new fields from the table onto the existing query grid.
Save the changes.
Now the new fields will appear in the Report Field List.
 
Back
Top