exclude certain entries in a total

[vickiwells]

Is there any way to exclude certain entries in a total? I need to be able to show the dollar amount that was voided in some records, but not include them in the total. I thought I could make a field which would indicate a Void, but don't know how I'd use it in a Total calculation.

 

[ElsVanMiert]

I think that the aggregate functions of the query will do exactly what you need.