Sub Total & Grand Total in a Report

[1hok3]

Hi!

I have a report Like this:

Description, unit_price, QTY, [Total] ( [Total] is an Additional field I added to calculate amount, not from a Query or Table)

A, 2, 10, =sum([unit_price]*[QTY])
B, 2, 10, =sum([unit_price]*[QTY])
C, 2, 10, =sum([unit_price]*[QTY])
______________________________________
Subtotal1 =sum([Total])?

E, 1, 20, =sum([unit_price]*[QTY])
F, 4, 40, =sum([unit_price]*[QTY])
G, 5, 30, =sum([unit_price]*[QTY])
_______________________________________
Subtotal2 =sum([Total]) ?
_______________________________________
Grand Total = [Subtotal1]+[Subtotal2] ?

I find it difficult to make [Subtotal1], [Subtotal2] and [Grand Total] as [Total] is an additional text box I added to the report to make total. I have tried to use function Grouping&Totals from Access, but only Count Record is available.
Please anyone if can help? Tks!

 

[vbaInet]

What is the point of using Sum() in this =sum([unit_price]*[QTY]) ? Is that not in the Detail section? All you need is [unit_price] * [qty]. Then you can =sum([unit_price]*[QTY]) in Subtotal.