Quote Originally Posted by John_G View Post
Iif(not IsNull(Appointment_Date), Appointment_Date, Appointment_RevDate)
If this was the requirement, wouldn't the Nz() function be simpler?



Nz(Appointment_Date, Appointment_RevDate)