Total on report

[Pam Coleman]

I have a report based on a query that will show an officer and count how many
citations he has written to m/w, f/w, m/b, f/b m/h, f/h, m/o, f/o example:
Off.Smith Total: 5 (this is what I want - the complete total for an
officer)
m/w 2
f/2 3 (m/b, f/b etc)
Off. Jones Total: 4
m/w 1
f/w 3 (m/b, etc)
I would also like a field to sum the sex and race and give the complete
Total for each officer. I am confused on how get the complete total and have
it on my report.

 

[Steve Schapel]

Pam,

In the sorting and grouping dialog of the report, you will need to set
up a Header section for each officer. Then, in this section, put an
unbound textbox with its Control Source set to the equivalent of...
=Sum([Citations])

As for the m/w, f/w, etc, is this categorisation (whatever it means) in
one field, or is it in 2 separate fields ("m" and "w" for example)? If
it's in one field, you could get another total, for example, in another
textbox, with something like this...
=Sum(IIf(Left([Classification],1)="m",[Citations],0))