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
 

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

Similar Threads

How to create a bubble chart with more than 2 variables 0
Formatting detail section w/two lines 1
Report using more than one queries? 10
I need to list multiple related records within a single report she 16
Show data if more than one record in group 3
Query that feeds the report 3
Report containing multiple critera/filters 6
Change text box background color depending on value in Label Reports 1

Back
Top