ACCESS

[JULIORUIZ2600]

hi,

i have in report productname footer this formula:=Sum(nz=IIf([CategoryName]="IN-ROOM BEVERAGE",Sum(nz([UnitsReceived])-nz([UnitsSold])-nz([UnitsShrinkage]))*([UnitPrice]),Sum(nz([UnitsReceived])-nz([UnitsSold])-nz([UnitsShrinkage]))*([UnitPrice])*1.07)that total prodcut value on stock.

how can i have in the report footer, a grand total of all the products on stock?

thank you

 

[Remou]

As far as I recall, the same expression place in the report footer will give a total over all. Is that what you mean?