Access 2007 Report - TechRepublic
Question
November 10, 2008 at 10:44 AM
aita montxo

Access 2007 Report

by aita montxo . Updated 17 years, 8 months ago

I have trouble creating of SUM of a field with a condition. The expresion I’m using is:

=Sum(Iif([Accept),[Price],0))

I want to get a total of the prices, only if Accept = Yes. Accept is a Yes/No field. Price is Int.

I always get the following error message:

‘You omitted an operand or operator, you entered an invalid character or comma, or you entered text without sorrounding it in quotation marks’

Any help?

This discussion is locked

All Comments