displaying filtered totals??? 1

[PQTIII]

I have a report that I want to show a total for the number of pounds used for particular products. I would like to show that on the report footer and not as group totals. Say if I wanted to show only the total pounds used for Product A, how would I filter for that product that with a text box in the report footer?

Thanks
Paul

 

[xicana]

I would base your report on a query that asks for a parameter.
Then you create the report using the report wizard where you can actually select to summarize (i.e ADD) the values in particular fields.

Sandy

 

[Remou]

Hi
Here are a few more ideas, maybe one is what you want.
In the Detail Section:
=IIf([Product]<>"Hats",[InvoiceAmt],0)

In the Report Footer:
=Sum(IIf([Product]="PCs",[InvoiceAmt],0))

A count:
=Sum(Abs([Product] Like "Ref*"))

 

[PQTIII]

In the Report Footer:
=Sum(IIf([Product]="PCs",[InvoiceAmt],0))

Just what I needed, Thanks!!!