Help with avoiding Dlookup

[Stingone]

Hi Everyone,

I'm currently working on a new DB.

It contains multiple data. One of the table's i have a called unit_rates. This tables contains 3 fields.

- Customer
- Function
- Price

Now i have another Table that describes 5000+ records of equipment containing multiple customers with multiple functions.

What is the easiest was to retrieve the price in a query based upon customer AND function. I want to avoid using Dlookup with multiple criteria.

 

[isladogs]

Make sure there is one (or more) common fields in each table.
Create your query using both tables linked using the common field(s)