Need a querie that updates.

[imlost2]

I have look around and still no answer to what i am trying to do. I have a table looks like this:
id inventory putaway packed date slotnumber item number
1 3605 6/12/11 S03 1
2 3605 6/12/11 S03 1
3 3605 6/12/11 S03 1
4 3604 6/13/11 S04 1
5 3604 6/13/11 S04 1

I need a querie that will make a report that looks like this if possible.
inventory putaway packed date slotnumber itemnumber


3605 6/12/11 S03 4
3604 6/13/11 S04 2
the item number is default to 1.
so if they scan pallets with 3605 (12 times)on 6/12/11 to S03 it wont make 12 entry's on my report.(from my table)
Will look like(hopefully)
3605---> 6/12/11----> S03----> 12
Edit :
Thanks but maybe the example will help.
Report will look like

Inventory putaway----->packed date---->slot number--->item Number(total count of inventory putaway)

[rpeare]

You're talking about an aggregate query. In your query design add all your fields except the primary key field.

Click on the sigma button in your query design window (looks like an upper case E on your too bar) a line called TOTALS will be added to your query. In the ITEMNUMBER field put either COUNT or SUM (I don't know which you're trying to do based on your example)