Getting total for Rows in a Report

[mguffey5]

I have an attendance report that pulls data from a query that is linked to a
subform on a main forum. This query lists multiple individuals and if
they've attended the specific event as required. The query looks like the
below:

Cadet Name Flight PT 1 PT 2 PT 3 PT 4 PT 5 PT 6
Present Absent
Doe, John Alpha P P P P A
P 5 1
Doe, Jane Alpha A A A P P
A 2 4

I can get a sum total for all the "P" marks in in the Columns which gives me
an overall for all cadets. Again what I need is for each individual record
that shows on the report to have individual totals for each one.

As you can see above John Doe would have 5 Present and 1 Absent while Jane
Doe would have 2 present and 4 absent. What I need is to get a total of "P"
and "A" for each record source as shown above.

I'm having trouble figuring out what string of commands or expression to put
in the control source for the box to calculate this information.

Any help would be appreciated

 

[ntc]

don't fully understand; seems like this would be be posted in the Reports
area....

do you have a report footer per Cadet name so that you can add sum boxes
there??

some things are easier via report features rather than via query....