Using more than one Field List

  • Thread starter Thread starter Mel
  • Start date Start date
Can you use more than one field list in creating a report?

Thank you for your help!

Mel
Click to expand...

No.
Make a query that includes the other tables (if you can).
Make sure the Relationships are established.
Make the query the record source for the report.
The additional fields are now in the Field List.

However, you can use DLookUp(), DSum(), etc., to get data from a field
even if it is not in the report field list.

Look up the DLookUp function in VBA help.
 
Only if the other field list is linked in the query that
you are running the report from
 
Back
Top