Vlookup Acess

[Hugo C.]

I´m currently trying to change my database in Excel to Acess, but one of the
main utilities that i use in Excel is the function Vlookup, to get values
from diferent tables.
I tried to use Dlookup, but i coudn´t understand how it works, so i would
like to know if there is a simpler way to get values in one table to another
using Acess.

Exemple
Table 1
Name Age Sex
Hugo 25 M
Ana 31 F
Jonh 45 M

Get the value from table 1 in a second table
Name Status Sex
Hugo M x-how can i get the value from table 1
Ana S
Jonh M

 

[Douglas J. Steele]

Create a query that joins the two tables.

You do this by creating a new query, and selecting both tables from the list
that's presented to you. Select the Name field from Table1 and drag it on
top of the Name field on Table2. A line should appear between the two
tables, with the Name field at either end.

Drag which every fields you want to see into the grid underneath the tables,
and run the query.

 

[John W. Vinson]

I´m currently trying to change my database in Excel to Acess, but one of the
main utilities that i use in Excel is the function Vlookup, to get values
from diferent tables.

Just be aware that Access is not "Excel on Steroids", nor is it a spreadsheet,
nor will your Excel preconceptions and habits serve you well in an Access
environment.

VLookUp is very useful in Excel for linking data in different sheets.

Access doesn't HAVE sheets, and VLookUp is not necessary in most cases.
Instead, you will want to use relational Queries, which are as essential to
Access as cell-referencing expressions are to Excel. It's actually much
*easier* to pull data from multiple tables together in Access; that's what
relational databases are designed to DO. However, the entire conceptual
foundation is different, and can take quite a bit of mental shifting!

Check out some of the tutorials and references at:

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

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

John W. Vinson [MVP]