NZ Function DLookup - NZ Function in Microsoft Access


	Back to NZ Function Comments List

Upload Images Link Email

NZ Function DLookup

Elisabeth Koivumaa

4 years ago

I have searched here on the website but not found a good answer.

I watched the movie about the NZ feature. But I do not understand how to get it with dlook up. Want to get rid of the #error text in my continuous form.

=DSlUpp("Description";"Qry_Bestllnings_frga";"ProducctID=" & [producctid])

	Richard Rost 4 years ago
I'm assuming you MEANT to misspell "Producct" Wrap your CRITERIA in the NZ function: `=DSlUpp("Description";"Qry_Bestllnings_frga";"ProducctID=" & NZ([producctid],0))` Also not sure what "DSlUpp" means. But I would do: `=DLOOKUP("Description","MyTableT","ID=" & NZ(ID,0))`

	Elisabeth Koivumaa OP 4 years ago
I code in Swedish and this forum does not take Swedish letters. But it should be dlookup in English. But then I have to write with a semicolon instead of commas. Otherwise it will be the wrong message.

	Richard Rost 4 years ago
Yeah, I figured that with the semicolons. I wish they would have just standardized on ONE thing. I didn't know that DLookup got changed to DSlUpp on your end though.

	Elisabeth Koivumaa OP 4 years ago
The missing letter is an A with a dot above. DSLAUPP

	Richard Rost 4 years ago
So the function name is actually spelled differently in the Swedish version of Access? That's got to make copying snippits of source code annoying.

	Elisabeth Koivumaa OP 4 years ago
access converts the code into Swedish. Even though I write dlookup access converts it into the Swedish word.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in NZ Function.