MS Access - Reports Part 2: Calculations in reports

[@MrBWicked]

Great resource, I will use this with my students, saved my weekend in not having to build resource on this topic :) Cheers Sean

[@MrLongITandCAT]

Glad they can help.

[@joeg9561]

Good break down. Simple to understand!!!

[@kuthula]

God bless 🙏

[@NicouS]

WHat about if you wanted to know how many married checkbox are ? How do you do it ?

[@tameronadams1569]

this is just amazing thank you ❤❤❤👐🏻

[@El-Ge]

I would like to put this total sum in Report into Main Form so that before go to report I knew already the total sum of money. Is it possible? If so, how? Thanks for the help.

[@jamzehoffman704]

Thank you Mr

[@SonriseHigh]

Very good.

[@erikaberoard2011]

Hi, how would you do the average paid per day?

[@MrLongITandCAT]

I would create a grouping on the day field, and then place the formula in the grouping's footer. Or you could make use of groupings in a query, and then based the report off that query. Have a look at this video: kzbin.info/www/bejne/qIi5h5qqjNyNY6c

[@erikaberoard2011]

When I group on the day, I still don’t get the correct result. It seems that in the calculation, access is considering each row as a different day (even though I grouped them by day)

[@444senna]

What is the difference between a label and text box?

[@MrLongITandCAT]

You use a label when you want to display the text as it is (for example: "The oldest person is "). You use a text box when you want to display the result of a formula (for example =MAX( [Age] ) ).

[@444senna]

@@MrLongITandCAT thank you.

[@delrosecoburn7354]

😁😁😁

[@zarmeenayasmee4522]

to go hahahaha