Dlookup

C

Chey

I am trying to do a "vlookup" on access where I need the following:

If the name of the company "Account Name" - (table called cac) - is similar
to the "unique name" - (table called log)- than bring the "NBC Country
agreement code" located on table CAC. Is it possible to do this?
 
J

John W. Vinson/MVP

I am trying to do a "vlookup" on access where I need the following:

If the name of the company "Account Name" - (table called cac) - is similar
to the "unique name" - (table called log)- than bring the "NBC Country
agreement code" located on table CAC. Is it possible to do this?
Click to expand...

What do you mean by "is similar to"? Please give an example.

Note that DLookUp in Access is used much less than VLookUp is in
Excel; for most of the cases where you'ld use VLookUp in Excel, you
can use a Query in Access rather than a VBA function. It depends on
the context of course.
 
Top