Lookup Fields for Report

[Kiedra Taylor via AccessMonster.com]

I am attempting to add lookup fields to my report. The report is based on
a query and the fields that I would like to include in my report are in a
seperate but similar query. The two combined will not return the desired
results. What expression should I use to retrieve the information from the
other query?

 

[Rick B]

I don't understand your question. Please give us specific details.

Rick B

 

[Pat Hartman]

Modify the report's query to join to the lookup tables. Use left joins if
the fks to the lookup tables are not required.