I have a field that sometimes null and I want to use that field if it is not null but when it is null I want to use another field to get my "On Time" or "Late" statment, I keep getting an error "A Date Time is Required Here" and it places the cursor at the end of my first "esle". Can anyone help me with this stament please.
if isnull ({TBL_LTDELIVERYDETAIL.ACTUAL_DATE}) then ({TBL_LTDELIVERY.DUEDATE}) else
if{TBL_LTDELIVERYDETAIL.ACTUAL_DATE} = {TBL_LTDELIVERYDETAIL.APPOINTMENT_DATE} then "On Time" else
if {TBL_LTDELIVERYDETAIL.ACTUAL_DATE} <> {TBL_LTDELIVERYDETAIL.APPOINTMENT_DATE} then "Late
if isnull ({TBL_LTDELIVERYDETAIL.ACTUAL_DATE}) then ({TBL_LTDELIVERY.DUEDATE}) else
if{TBL_LTDELIVERYDETAIL.ACTUAL_DATE} = {TBL_LTDELIVERYDETAIL.APPOINTMENT_DATE} then "On Time" else
if {TBL_LTDELIVERYDETAIL.ACTUAL_DATE} <> {TBL_LTDELIVERYDETAIL.APPOINTMENT_DATE} then "Late