Access Querry

Hello friends
Yesterday i placed Queston But may be not clearly Unerstandable!!!! So
placing again

I have table like this
Date Item# SubItem# QtyToday
19/01/07 1 2 200
19/01/07 1 4 300
!9/01/07 2 3 100
20/01/07 1 2 300
20/01/07 2 3 700 AND SO ON. There are 60 diff
Items and each items have variable subitems say 1 t0 40 subitems
I need UptoDateQty for Each SubItems and Items on my report on each day.So
reports look like this:
Date Item# SubItem# QtyToDay UpToDateQty
19/01/07 1 2 200 200
1 4 300 300
Total Item# 1 500 500
2 3 100 100
Total Item# 2 100 100 Ok this is for
19/01/07. Now for 20/01/07 Report should look like this:

Date Item# SubItem# QtyToday UpToDaeQty

20/01/07 1 2 300 500 Here previous
day's Qty added
Iotal Item#1 300 800
2 3 700 800
Total Item#2 700 800
I need to see report for Date() with Item wise and SunItem wise UpToDateQty

I would apprecite all friends

you need to create 2 queries:

1st query:
group by [Date]
group by [Item#]
group by [SubItem# ]
Sum ([QtyToday])


2nd query:
group by [Date]
group by [Item#]
group by [SubItem# ]
Sum ([UpToDaeQty])

then create a 3rd query pulling:
Date, Item , Sum ([QtyToday]) , Sum ([UpToDaeQty])