I have access query which contains the fields depo, date, quantity.
I want to generate a report as follows:

DEpot:1
date Qty
01/02/01 23
02/02/01 32
Total of depot1:55
DEpot:2
01/02/01 10
02/02/01 5
Total of depot2:15

Grand Total ( total of depots date wise):
01/02/01 33
02/02/01 60


My problem is at the grand total level. as how will i bring date wise totals . I tries to use report footer,but it brings only one date .

Kindly help


Minu

Try =Sum([YourField])