DLookup and Nz

Joined
May 27, 2016
Messages
1
Reaction score
0
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

Back
Top