DLookup and Nz

May 27, 2016
Reaction score
I have two tables- One Tbl_Course and the other Tbl_Grading.
I created a query from Tbl_Course and I add an expression and I named it Gradings to look from Tbl_Grading for grades.

I wrote this Statement

Gradings: DLookUp("Grading","Tbl_Grading","Mark=" &[Mark])
it works perfectly, but the empty fields comes with a #Error.

I would like to add Nz, so when the field is empty it shows "Waiting For Result"

Any Help please!

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Nz in a DLookup control ? 12
DLookUp #Error 7
Access #Error & Excel Pivot 0
If Nz(DLookup(... Not Working 4
dlookup 2
Check value by DLookup 1
Dlookup is broken... 1
DLookup returns NULL incorrectly. 3