Counting duplicate records only once?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

Access 2000. I hope I can explain this. I have a subform which allows
duplicate certificate numbers to be entered. One certificate number has
several fee components. Fee, Mileage, and Overtime. In this example one
certificate number is shown in three records listing each component.
Certificate: 12345 Fee: $100.00
Certificate: 12345 Mileage: $7.00
Certificate: 12345 Overtime: $15.00
I need to count the individual certificate numbers, not the toal records of
a certificate number. I need my query or my report to show a count of 1 for
certificate: 12345...Can I do this? Thanks...
 
Group your report by Certificate and display the group header or footer. Add
a text box in the group section:

Name: txtCountCert
Control Source: =1
Running Sum: Over All
Visible: No

Add a text box to your report footer section:

Control Source: =txtCountCert
 
Back
Top