vlookup in access

[eran3185]

hi !
i'm very "fresh" in access , and i want to learn how to build something like vlookup .
i have 2 tables : car , general

i want to get a query that give me :

id number plate color
1 111111 blue
2 222222 black
3 999999 not found

i want to see all the id's and all th number plate and the color's.
in id=3 there is no color in the table , and i want to see this line in my query with the words "not found" at the color column

[asingh]

Hi,

Attached is the DB..with your request.

Used a full inner join with Number Plate as the key.

Query Name:
qry_select_colors

regards,

asingh

[Carl A]

Cross Posted

http://www.theofficeexperts.com/forum/showthread.php?p=29953&posted=1#post29953

[eran3185]

thenk's

[eran3185]

i wonder if there is another way , maybe something like dlookup ???