dlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

eran185 - 29 Sep 2007 21:35 GMT

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

Reply to this Message

Douglas J. Steele - 29 Sep 2007 23:29 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> hi !
> i'm very "fresh" in access , and i want to learn how to build
[quoted text clipped - 13 lines]
>
> i know how to do it with query , but i want to do it with dlookup

Reply to this Message