Newb needs help with statistics in reports (1 Viewer)

[alleny87]

Is there a way of formulating statistics at the bottom of a report?

Heres what i have.

The report pulls Rank, Last Name, First Name, Assigned weapon, Weapon qualification date. After 6 months i use conditional formatting to highlight the soldiers qualification date red. Im in the military that's why im tracking all this, but I need figures to report to higher, and at the bottom i would like it to show, "#Qualified", "#UnQualified","% Qualified", "% Unqualified", "#Expired","%Expired"

Any help would be appreciated. could use some help with sorting, an formatting but right now this is more important.

 

[AlexHedley]

You could add textboxes to the footer and then add calculations like SUM etc using the Fields from the Report.

Simple Form Footer Example
http://www.599cd.com/tips/access/form-footer-total-sum/?key=AlexForum

This could be used in Reports and is just a starting point.