Report Fields

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
 
F

Fredg

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top