Access 2016 Queries: Grouping Records & Totals

Access 2016 training video on how to group your records, and add a calculation to that group by using the Totals feature.
All 131 of my Access 2016 training videos contain everything you need to help pass the Microsoft Access 2016 (77-730) exam and become certified!
PATREON: Kirt Kershaw & Dream Force, LLC invite you to subscribe for the $2 monthly option which includes ALL Microsoft Office training tutorials 2016, 2013, 2010 and 2007. New videos will be constantly uploaded to Patreon so you will get new content: Visit and sign up at:
/ kirtkershaw
DVD & DOWNLOAD AVAILABLE:
www.DreamForce.us
SUBSCRIBE to learn more Microsoft Office tips, tricks and shortcuts!
www.youtube.com...
LET'S CONNECT!
-- / kirtkershaw
-- / kirt-kershaw-33874410

[@AK27inAZ]

All these years later your video is still saving people! You are a GREAT teacher. I'm so grateful for these tutorials. Thank you, thank you, thank you.

[@teengweeyu]

Thanks! You solved my problem in just 60 seconds!

[@taylorharrison4303]

Solved my issue within a minute! Bless you!!

[@KirtKershaw]

Glad to hear it worked for you 😊

[@charlize__]

Love your commentary and fun way of teaching!

[@KirtKershaw]

Thank you 😊

[@dusanpejnovic7218]

Thank u for this my man. It helped me so much

[@KirtKershaw]

Welcome 😊

[@RandyLahey22]

Very clear and useful information. Helps with defining min or max of records, or the most recent date in a group

[@bridgetjones6819]

Thank you so much for great video !!!

[@KirtKershaw]

Welcome 😊

[@matefacil7968]

Hello Kirt, great video. One question... is there any way to add a total row per department and keep the individual records at the same time? I am trying to build something similar to an Excel Outline but in Access

[@wejulimoses4907]

Thanks for the lesson

[@KirtKershaw]

Welcome 😊

[@stanTrX]

Awesome

[@utalgreg]

I don't use the Caption property to set the column names because it cause problems if you ever want to alias the column name elsewhere. The best way I believe is to just use an alias name in the column with a colon in the design mode. for example MyAlias:[Field Name]. But I like your video and presentation. Thanks

[@KirtKershaw]

Thank you 🙂

[@brad4201]

Legend

[@ibrahimchanbi4356]

What if you don't want to change group by to Avg ??? what if want to keep other columns as they are ? thanks

[@beatricewairimu8406]

nice one

[@KirtKershaw]

Thank you 😊

[@sarahl3721]

lovely

[@MohamedAhmed-rc2ml]

Hey Sir
I wanna to add field in query that calculate percentage of total column
like customer service weekly gross to total
and dynamically

[@legendplonski8758]

some of the names casually include homer simpson, danny devito, and donald duck. Neat

[@sleepychameleon6871]

💚