Vlookup In Access

[DiamondDug]

I am a new user of MS Access and have in the past done all of my databasing
in MS Excell. I was wondering if there is a lookup function in access that is
equivalent to the Vlookup function in Excell. I've tried Dlookup but it seem
to only be able to return records from a single table where Vlookup
references one table for the critera and finds and return the corresponding
value from another table. Is there anyway to do this?

 

[Michel Walsh]

Hi,


DLookup returns one value, the expression, or field, you send, as a
string, for its first argument; not a record. If you have two tables, a JOIN
is preferable (faster) than multiple DLookup.


Hoping it may help,
Vanderghast, Access MVP

 

[DebbieG]

You can do a DLookup on a query which can be based on one or more tables.

|I am a new user of MS Access and have in the past done all of my databasing
| in MS Excell. I was wondering if there is a lookup function in access that is
| equivalent to the Vlookup function in Excell. I've tried Dlookup but it seem
| to only be able to return records from a single table where Vlookup
| references one table for the critera and finds and return the corresponding
| value from another table. Is there anyway to do this?

 

[MGFoster]

I am a new user of MS Access and have in the past done all of my databasing
in MS Excell. I was wondering if there is a lookup function in access that is
equivalent to the Vlookup function in Excell. I've tried Dlookup but it seem
to only be able to return records from a single table where Vlookup
references one table for the critera and finds and return the corresponding
value from another table. Is there anyway to do this?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You have to stop thinking in spreadsheet mode & start thinking in
database mode. VLookup is made to search a spreadsheet grid. That can't
be done in a relational database because the data is not arranged in
grids.

Read a book on database design for more info on how data is organized in
a relational database like Access (JET db engine).

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQhKhn4echKqOuFEgEQIYcwCfQYo+hup4fLwSKmbVl1tbkCy11OMAnRI8
D51fLy5NTFCNmwrqp+aVRUHF
=qE2G
-----END PGP SIGNATURE-----