help

  • Thread starter Thread starter simorris
  • Start date Start date
S

simorris

is there any Function similar to the VLOOKUP function in excel for access
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top