How to Add Total Row to a Datasheet in MS Access - Office 365

This video explains how you can add a Total row to a datasheet in Microsoft Access. You can have different total calculations for different columns. If records are filtered the totals are based on the filtered records. The totals displayed in totals row are calculated real time as you keep adding new data or editing existing data. You can remove the total row and restore it back with same settings by clicking on totals button in the ribbon.

[abayomiakingbala]

You just saved a soul sir
Thank you
🙏🏾

[francinepowell]

Thank you so much! Now I don't have to copy the query results to an Excel table to get the Totals :)

[joelgallegos]

Very good teacher! Thank you from America!

[dodojhon]

how to add the total row to the query grid?

[acceleratevalvesandinstrum]

well in my case it has stopped working i dont know why