Dlookup not working for text?

[mikelev]

Well I thought I had the statement correct, but it only works for numbers not text?

Works:
= Nz(DLookup("DESCRIPTION", "TABLES", " TABLENUM='" & 1 & "'"), "N/A")

Does not work:
= Nz(DLookup("DESCRIPTION", "TABLES", " TABLENUM='" & P1 & "'"), "N/A")


Any help would be appreciated.

 

[PHV]

Is P1 a variable or a literal ?
= Nz(DLookup("DESCRIPTION", "TABLES", " TABLENUM='P1'"), "N/A")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[mikelev]

In this case it is a literal.

Thanks PHV

 

[mikelev]

I have a very similar situation, where I need to look up users that have a "position" = "Dealer". I tried the following with no luck?

= Nz(DLookup("fullname", "tbluser", " POSITION='Dealer'"), "N/A")

Thanks as always for you help!