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.
 

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

Autonumber field in Excel that behaves the same as Access 0
Drop down list control value in vba 2
How to have two tables on same line? 1
Trying to create a report that will list unmatched records by Ticket Primary Key 0
sqlite-odbc write conflict 2
Mail Merge Directory Conditional Page Break 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Newbie Help - IF Yes No Function 0

Top