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