Vlookup In Access

[Lokesh]

Hi,
i Have Created a Database in Access, but earlier to this i used to work in
Excel and was using Vlookup to Update ot Compare Information from one Excel
sheet to another excel sheet. But i am finding it difficulties in Access.

 

[Duane Hookom]

Access isn't Excel. You generally don't have to use VLookup() since you can
join tables in queries, use combo boxes, etc. You can use DLookup() if you
absolutely have to.

If you provided some context to what you want to accomplish, someone might
be able to suggest a best practice answer.

 

[Rejane]

Hi,
i Have Created a Database in Access, but earlier to this i used to work in
Excel and was using Vlookup to Update ot Compare Information from one
Excel
sheet to another excel sheet. But i am finding it difficulties in Access.

 

[John W. Vinson]

Hi,
i Have Created a Database in Access, but earlier to this i used to work in
Excel and was using Vlookup to Update ot Compare Information from one Excel
sheet to another excel sheet. But i am finding it difficulties in Access.

Access is not "Excel on steroids" and it is not a flawed implementation of
Excel. It's a *different* program with *different* conventions and procedures.
Excel is a spreadsheet; Access is a development environment for relational
databases.

The tools in Access to "compare information" are called Queries, and they are
as essential to Access as calculations in cells are to Excel. You'll need to
spend some effort to "unlearn" the way things are always done in Excel and to
learn a new way to interact with your data to make productive use of Access.
Here's some resources to get you started:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials