Bob H wrote in
:



Update,
ok, I think I have what I want now, as I have been playing around
with different things etc, and have this:
OutOfDate:
IIf([NextTestDateDate(),"OverDue",IIf(([NextTestDate]-Date()7),"D
ue Soon",Nz([NextTestDate],"No Test Date")))

So where there is a blank field for the NTD the Nz function says
No Test Date.
Where the Test date is passed, then Overdue
But when Test Date is current or in the future, then that Test
Date is entered into the adjacent field.

Does it matter what order the SQL is in, ie should Nz be first, or
is it ok where it is.

Thanks again for you assistance.


Order is important only when cases overlap such as your first and
second cases, with the nz(), if the results meet your needs, it's where
it shoould be.