Syntax on calculated query field
Posted on 2012-03-20
Hi. I created a calculated field in a query and keep getting this message when I run the query:
"You may have entered a comma without a preceding value or identifier."
I cannot figure out where my syntax is wrong... Here is the code.
Days: IIf(is null([Section IV Date Completed]), DateDiff("d",[Date_Initiated],[Current Date]), DateDiff("d",[Date_Initiated],[Section IV Date Completed]))
I'm trying to run a day count based on whether the date complete field is filled or not.