Calculation query...

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
 
J

Jeff Boyce

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>
 

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

If/Then/Else Query 6
Query the same table three times 0
Value in Crosstab Query 1
Duration calculations 1
Enter data from same cell in different sheets into a new sheet 2
Help! Calculate Average using Queries 2
Multiple columns sort 4
Report with conditionnal formatting issue 0

Top