Sum, in Report

[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

 

[Steve Schapel]

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?

 

[Fred's]

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

 

[Fred's]

Steve,
I forgot to tell you that my report is sorted by supplier

thanks - Fred's

 

[Steve Schapel]

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"))