Counting entries on report

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

My report, which is fed from a main query, has a field in which I have a code
for their security clearance, ie S=secret, TS=Top Secret, D=Denied, R=Revoked.

The report, depending upon which department I select to show, will show a
list of records ranging from 20 to 700 with a mixture of the above codes.

WHAT I WANT: At the bottom of the report I want the following COUNT style
box:
Secret (total number of secret for that report)
Top Secret (total number of TS for that report)
Denied (total number...)
Revoked (total number...)

Thank you ahead of time for whomever offers a solution.

Tony
 
My report, which is fed from a main query, has a field in which I have a code
for their security clearance, ie S=secret, TS=Top Secret, D=Denied, R=Revoked.

The report, depending upon which department I select to show, will show a
list of records ranging from 20 to 700 with a mixture of the above codes.

WHAT I WANT: At the bottom of the report I want the following COUNT style
box:
Secret (total number of secret for that report)
Top Secret (total number of TS for that report)
Denied (total number...)
Revoked (total number...)

Thank you ahead of time for whomever offers a solution.

Tony
Click to expand...

In the Report Footer section add an unbound control.
Set it's control source to:
=Sum(IIf([ClearanceField] = "S",1,0))

Do similar for each of the other classifications.
 
fredg,

Thank you very much for the quick, and accurate, reply. It worked like a
charm and I my dbase is looking golden because of your help. Thank you.

Tony

fredg said:
My report, which is fed from a main query, has a field in which I have a code
for their security clearance, ie S=secret, TS=Top Secret, D=Denied, R=Revoked.

The report, depending upon which department I select to show, will show a
list of records ranging from 20 to 700 with a mixture of the above codes.

WHAT I WANT: At the bottom of the report I want the following COUNT style
box:
Secret (total number of secret for that report)
Top Secret (total number of TS for that report)
Denied (total number...)
Revoked (total number...)

Thank you ahead of time for whomever offers a solution.

Tony
Click to expand...

In the Report Footer section add an unbound control.
Set it's control source to:
=Sum(IIf([ClearanceField] = "S",1,0))

Do similar for each of the other classifications.
Click to expand...
 
Back
Top