Good morning, afternoon or evening,
I have query that is prompting me for a parameter value on an expression where I am summing and returning zero if null----- FieldName: Sum(Nz([AdjustmentAmt],0)). This AdjustmentAmt field is only in one of the two joined tables. No misspellings... and the query works if you leave blank and click ok. Not the end of the world just annoying. Any thoughts as to why this is happening and how to fix?
Thanks,
Eric