Recent content by circuz_phreak

Thanks I was so bent up on writing the code for it I didn't realise it was so easy. I clicked on the row and summed quantity and grouped by product names. The new column I get is SumOfQuantity. Is there any way to change the name of this column? It doesn't appear in the design view and I...

I'm trying to create a Query. I have a field "Name" from the table "Products" and the field "Quantity" from the table "Deliveries". Currently, The same product name will appear several times with their quantities. I want to SUM all of those quantities together and only have the Product name...