If Statement

[k0goodwi via AccessMonster.com]

I am creating a query where I want to show a value of $0.00 when there is no
available data for a job and I am also using the group by feature. I believe
I could do this using an If statement like IIF([Invoice Amount]=" ","0",
[Invoice Amount]), though I'm getting an error saying, "You tried to execute
a query that does not include the specified expression ... as part of an
aggregate function." How can fix this issue? Can I go about this another
way?

Thanks

 

[Jeff Boyce]

Nz([Invoice Amount],0) will cause Access to display a 0 when the field is
null.

Regards

Jeff Boyce
Microsoft Office/Access MVP