looking up a value in another table

[archiecone]

Ok....I have a query that I am doing calculations in. In one of my calculations I am trying to look up values in another table that is the same value as the one in another table.

For instance, I am looking up a power factor for a motor. I have the horsepower in my query and I want to match that horsepower up with the lookup table. can anyone help me out?

 

[Jack Cowley]

You can use DLookup in your caluculations to get the required data from another table. Search Help for more details on how to use this function.

 

[Jack Cowley]

Pat -

Thank you for your insight. I just learned a valuable lesson!

Jack