totals append query help please

[Peter Pan123]

Hello all.. new here.. I have a pretty easy question for you access gods out there.. I have a field in a table called BOX and a field called CURRENT QUANTITY (along with several other fields for 300+ records). I would like to run a query that results in 2 columns.. one showing a box number (1-65) and one showing how many items are in each BOX. I would like to create a new table with just 65 records showing results.

I'm watching too many tutorials.. I think its easier than I am making it out to be.. I'm just dizzy at this point..

thanks in advance.
pete

[ranman256]

SELECT BOX , CURRENT Quantity INTO NEWTABLE FROM tBOX


(this assumes there a field called Box in table tBox)