can conditonal expression have 2 conditions with and operator defined between th

  • Thread starter Thread starter prathi selva via AccessMonster.com
  • Start date Start date
P

prathi selva via AccessMonster.com

Hi,
In my report i want to calculate if date received - date acknowledged is
less than 5 and final reply is less than response date, i should display 1
else 0.
i tried the following Expression..but i get this error :

IIf((DateDiff("d",[Date_Received],[Date_Acknowledged])<5) And ([Final_reply]
<=[Response_date]),1,0)

"This expression is typed incorrectly, or it is too complex to be
evaluated. For example, a numeric expression may contain too many
complicated elements. Try simplifying the expression by assigning parts of
the expression to variables. (Error 3071)"
 
Pardon me if this is a duplicate, but I got an error posting.
I think this may be a data type problem. Is [Final_reply] a date data
type? What about the others?
 
Is [Final_reply] a date data type? I assume the others are. It looks like
it may be a data type problem.
 
Back
Top