Lookup Fields for Report

  • Thread starter Thread starter Kiedra Taylor via AccessMonster.com
  • Start date Start date
K

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?
 
Modify the report's query to join to the lookup tables. Use left joins if
the fks to the lookup tables are not required.
 

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

Report Update Fields 0
Access Access Report Works on One Machine but not Another 3
Report based on Query 1
Pulldown for Report Input Fields 5
Report field prints white on black 1
Merging two reports 4
color in field of a report??? 4
Report Subtotal 1

Back
Top