Little Assessment Question

[SammyConfirmed]

I require help on this.
Could you perhaps give me a simple step-by-step guide and if you require any info in regards to the database, let me know!

[pbaldy]

Your instructor should have done that. I'll point you towards totals queries. Start a query on your table and click on the Totals icon on the ribbon. You'd use Group By on some data and Sum on other data.

[SammyConfirmed]

Good so far? need some further guidance @pbaldy

[pbaldy]

You would group on the gender field as well.

[SammyConfirmed]

You would group on the gender field as well.

What about the date field?

[pbaldy]

Since you want it by month, group on a calculated field like

Format(DateField, "yyyymm")

[SammyConfirmed]

Does not work for me for some reason. Any chance anyone could contact me on discord for real time feedback and solutions? Thanks.

[pbaldy]

I don't know what "Does not work" means exactly, or how you're using it.

I don't have that app and wouldn't use it for this anyway. We all do this for free, so we fit helping out in around other things in our lives.