Is there a "where" function for running totals

[PQTIII]

I'm trying to show the totals for different products in the report footer in separate text boxes. Is there some type of function you can put in the running total box to only count the records for a certain product?

Thanks
Paul

 

[DeMann]

perhaps a dlookup? i dunno...

_______________
[cN]

 

[Remou]

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

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

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