Selecting a date value from two fields

  • Thread starter Thread starter rmorrison
  • Start date Start date
R

rmorrison

I have a table with two date fields: one an unconfirmed date scheduled
upto 3 years in advance, and a confirmed date which is entered nearer
the appointment time. I need to be able to run a report showing
either: the unconfirmed date if no confirmed date is entered, or the
confirmed date if it is available. I need to keep the two dates as I
also need to show how many appointments were done early or late,
compared to the advance-scheduled date.
How do I do this. I have struggled through and can't make it work.
 
In the past I have used a control with an IIF statement to check if the
confirmed date isnull, if so use the uncofirmed, else use the confirmed.
Look up the IIF statement it should be what you are looking for.
 
Back
Top