Grabbing only certain records for total

N

Nigel

In a report I have certain records tagged as true or false, if a record is
true I want to include it in a calculation if it is false I want to ignore it
in the total, any ideas how to do this

Thanks
 
T

tina

here's an example you may be able to tweak to work for you. to sum the
Price field of all records where the Discount field is True, using an
unbound textbox in the report's Footer section, put the following expression
in the textbox's ControlSource property, as

=Sum(IIf(Discount = True, Price, 0))

hth
 
Top