help

  • Thread starter Thread starter simorris
  • Start date Start date
is there any Function similar to the VLOOKUP function in excel for access

Short answer:

Yes, DLookUp.

Better answer:

Yes, but if you're using it you may not be making the best use of Access.
Access is NOT "Excel on steroids", and a table datasheet is NOT a spreadsheet.
Tasks that would use VLookUp in Excel are probably better handled by creating
Queries joining tables in Access.

Use Access as it is designed, rather than trying to treat it as "a flawed
implementation of Excel", and you'll find that it's very much easier.
 
Back
Top