dlookup

[eran185]

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

i know how to do it with query , but i want to do it with dlookup

 

[Douglas J. Steele]

Not really sure what you hope to achieve using DLookup rather than a query,
but you can use the Nz() function to convert Null values to whatever you
want.