Question
Thread display: Collapse - |
All Answers
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Access 2007 Report
=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?