I posted this the other day. Someone did respond, but when I click on the
link it is blank and I searched all over and could not find my question or
the response. I thank who ever answered it and hopefully you can respond
again.
My IIf statement is as follows:
StatusOfAppointment: IIf([ArrivalTime]<[AppointmentTime],"Early",
IIf[ArrivalTime]=[AppointmentTime],"On Time","Late"))
I need to give a 15 minute window (ex. appointment time 15:00, driver
would
be consider On Time from 15:00 to 15:15). Not sure if I can do that, so
any
help would truly be appreciated. Thanks!
--
clueless
|
