Calculation query...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I do the following calculation in a query?

Date1
Date2
Count of Days
Date4

Date1 or Date 2 If not Null - (any Count of Days) - Date4
 
If I understand, I still have a question. What is supposed to happen if
Date1 or Date2, or if both Date1 and Date2 ARE Null?

Take a look at the IIF() function to see if it could help.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top