Hello,


We are trying to write a sumif statement in Access at the end of a report but it is not working. What we want to do is say the following:

In our lingo: For all matters (records) where the Contingency field equals "Y", sum the dollar amount.

I tried to write it in more general lingo:
IF FieldA = Y THEN total the amount field for that record OTHERWISE don't total the amounts

We've tried sumiif and DSUMs but it's not working. Any ideas on what we might be doing wrong? Thanks!