function ACCESS the VLOOKUP

  • Thread starter Thread starter Guest
  • Start date Start date
On Thu, 15 Jun 2006 06:23:02 -0700, humberto martinez <humberto
is there an equivalent function in ACCESS to the VLOOKUP function?

Short answer:

Yes, DLookUp

Deeper answer:

Access and Excel are VERY DIFFERENT PROGRAMS. The tools that you use
in Access may very well be different, and be used differently, than
what you're used to in Excel. It's very likely that the (rather
inefficient) DLookUp function will *not* be needed, because what
you're trying to accomplish may be better done by using a Query
joining two tables.

John W. Vinson[MVP]
 
Back
Top