Simulate VLookup from Excel in Access

B

Brian

I was wondering if there was a way to simulate the VLookUp
() function in Excel in a Select Query. I know I could
write a nested if statement but there are 20+ logical
answers. Any ideas?

Thanks.
 
N

Nikos Yannacopoulos

Brian,

Excel's VLookup is actually trying to simulate Access's functionality!
Access (or any relational dbms for that matter...) is light years ahead in
this. Make a separate table to hold what your lookup area would be in Excel,
and then make a query to join your original table and the new one on the
lookup value field. Take all fields required from both tables down to the
grid for output, and you're done.

HTH,
Nikos
 
Top