Sum, in Report

  • Thread starter Thread starter Fred's
  • Start date Start date
F

Fred's

Hi all,

I have these "Pairs Qty1", "Pairs Qty2", "Pairs Qty3" fields in my
table, I want to have the Sum of each of them in my report, My problem
is that the sum needs to be selected by depending a selected Supplier
name

How can I do that?

Thanks to all,
Fred's
 
Freds,

Do you mean that the report will show the records for all Suppliers, but
the totals will only be for a particular supplier? If so, how will be
know which supplier the total is for?
 
Hi Steve,

I want to be able to show on my report the totals only for a
particular supplier.

Thanking you in advance for your hep!
Fred's
 
Freds,

In the Footer of the report, put a textbox, and in the Control Source
property of the textbox, put the equivalent of this...
=Sum([Pairs Qty1]*-1*([Supplier]="a particular supplier"))
 
Back
Top