hlookup in access?!

lobhaan

New member
Local time
Today, 12:13
Joined
Jul 12, 2005
Messages
6
See attached 2 tables as example. I want to connect on VolumeCategory. So: an ID with a certain VolumeCategory needs to get the connecting tariff (talbe 2 = tariff table). In Excel I would use hlookup. In access so far I have manually changed table no 2 to something like table no 3 and then connected it on VolumeCategory. But there must be a smarter way to directly query table 1 with table 2. My "tariff table (table no2) has grown now to 52 categories and each time manually "rewriting" is getting me somewhat feeling stupid.

Can someone tell me what the solution is?

Thx for all the help!

Lobhaan
 

Attachments

Users who are viewing this thread

Back
Top Bottom