Lookup value

A

awach

I have a report that has fields with product names. I want to have another
field next to it that looks up the price of those products, the information
is found on another table. How can I do this?
 
K

KARL DEWEY

In your query that is the recoord source for the report add the price table
and left join the product table to it.
 
Top