How to Calculate Line Item Totals and Form Footer Totals in Microsoft Access (Sum Function)

[@artistryartistry7239]

Folks if you like these videos, don't forget to like! If anyone deserves it, it's Richard.

[@599CD]

Absolutely! And click that blue JOIN button. :)

[@FlacoSalsero]

Thanks Richard! Your videos are great and this one especially helped me solve an issue I was having with subtotals on a form.

[@599CD]

Great to hear!

[@johnkiarie7349]

Thanks!

[@599CD]

Thank you very much

[@sumonshawon8901]

Nice Video Sir...........Thanks Sir

[@599CD]

My pleasure

[@artistryartistry7239]

Great video! Is it possible to change the color under the record selector?

[@599CD]

Not that I'm aware of. That's a Windows thing.

[@ahmadzafar5051]

Nice video 👍👍 But my question is can i total sum in page footer?? Because my records is on many pages.I want separate totals for each pages. How i solve??

[@599CD]

I cover that in the extended cut.

[@ahmadzafar5051]

@@599CD where is the extended cut?

[@599CD]

@@ahmadzafar5051 you'll find a link to it in the description text under the video. It's the MEMBERS VIDEO, so you'll need to join first before you can watch it. Click the blue JOIN button.

[@ramadash2472]

It works fine with forms. But when I used same technique on reports, I get #ERROR in footer total text box!

[@599CD]

Make sure you're using a REPORT footer, not a PAGE footer.

[@sdecken2700]

@@599CD This answered my question as I had the same problem. You have helped me out quite a bit and you're entertaining and easy to follow. Thank you so much!

[@dagsgaz]

Form footer, I get an error when attempting this, anyone any ideas?

[@saafimohammed4365]

I want my currency to be counted as KSH1,345 instead of $

[@599CD]

Uhm... OK

[@kensimba7868]

My fellow Kenyan...@saafi I think that's a setting on your computer not on access.