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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Worksheet_BeforeDelete code not working as expected. 1
How to calulate time 3
Date search query 0
Automatic data entry based on other data 5
Excel Vba to change displayed year automatically. 14
Access 2007-Table not displaying the values from a combo box 2
Carry over date from previous record 1
Problem with date comparison 4

Back
Top