Grabbing only certain records for total

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top