View Full Version : exclude certain entries in a total


vickiwells
01-05-2001, 05:06 AM
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
01-06-2001, 01:09 PM
I think that the aggregate functions of the query will do exactly what you need.