Access equivalent of Vlookup

[Guest]

I am an "Excel guy" making the transition to Access. I used Vlookup quite
frequently in Excel. Is there an Access equivalent? I have been playing with
the Dlookup and find it terribly confusing despite a lot of the help on the
web and here in these discussion groups.

Any information would be greatly appreciated.

 

[Guest]

An answer given by Allen Browne in a previous (similar) post:

DLookup() is the starting point, but it lacks the ability to specify how to
order the records, so it may not work for you. Basics of DLookup():
http://allenbrowne.com/casu-07.html

There is an extented DLookup() replacement in this link:
http://allenbrowne.com/ser-42.html
The extra argument lets you specify how to order the records, and therefore
which one to retrieve.

If you want something more powerful still, see Tom Ellison's article:
Lookup in a range of values in a query
at:
http://allenbrowne.com/ser-58.html

 

[John W. Vinson]

I am an "Excel guy" making the transition to Access. I used Vlookup quite
frequently in Excel. Is there an Access equivalent? I have been playing with
the Dlookup and find it terribly confusing despite a lot of the help on the
web and here in these discussion groups.

Any information would be greatly appreciated.

Ofer's suggestions are right on the money... but to take a step further back:

VLookup is useful in Excel for connecting cells across datasheets.

This often is NOT NEEDED in Access, because it's not a spreadsheet; it's a
relational database.

Many of the things you would do using VLookUp in Excel can be done -
differently! - using Queries joining tables in Access.

It can be harder to "unlearn" "the way things are always done" than it is to
learn new ways, but you'll need to do so to fully move into Access!

John W. Vinson [MVP]

 

[PFC Sadr]

you can use joins; subqueries; etc

oh wait a second; Access doesn't support subqueries

YOU SHOULD LEARN SQL SERVER YOU ****ING RETARD