Calculate days using 2 arguments

[athikah]

Hi all. I am new here.

I have a database to monitor incoming emails from our contractor & my superior wants it to have control like the following situations:
1. If no respond yet, to calculate today's date minus received date
2. If responded, to calculate respond date minus received date

If i use the following expression, it does not relate to if the emails have no respond yet or have been responded.

IIf(IsNull([Reply Date]),DateDiff("d",[Due Date], Now()))

Can somebody help me.

 

[jdraw]

You do not have the correct syntax for IIF.
see http://www.techonthenet.com/access/functions/advanced/iif.php

If i use the following expression, it does not relate to if the emails have no respond yet or have been responded.

You will have to sort out which fields represent what in your table(s) and construct your query accordingly.

 

[liddlem]

If I rewrite your condition in the form of

IF something then
Do this
ELSE
Do this

Then your statement says
IIf(
IsNull([Reply Date]), THEN
DateDiff("d",[Due Date], Now())
ELSE

)

 

[athikah]

You do not have the correct syntax for IIF.



You will have to sort out which fields represent what in your table(s) and construct your query accordingly.

ok thanks. hopefully i can understand more on the Iif function.

 

[jdraw]

IIF (some condition, condition is true, condition is False)

3 parts
condition -- something that evaluates to True or False
condition is TRUE -- what to do when condition is True
condition is FALSE -- what to do when condition is False

You DO NOT HAVE the condition is FALSE construct in your IIF