Doing Calculation and Inserting that Value into New Row into Query Table

[Vincen85]

Hi, I am wondering If I can Sum the value of rows in one field of my Query Table and Inserting that Calculated value into the bottom of the summed Row in the VBA or through Query Design View.

Please let me know, Thank YOU!

Below I have attached the picture of the data that Im trying to sum and insert into a new row that Hopefully can be created through MS access Query.

 

[neileg]

I would do this in a form. A form will easilly calculate totals based on the data in the detail of the form.

If you really need it all as a query (perhaps so you can export the data) then use a totals query and then use a union query to link that back to the data.