[Question] How to count all entries in a field

[boblarson]

i need to verify what is actually showing up on the report to ensure they are all accounted for.

Okay, so the Count as I showed on the report will show the number of records showing on the report. But if there are duplicate ID's then it will show that number as well. You can Group by ID and have a hidden Group Footer and have a text box with =1 as the control source and with the RUNNING SUM property of that text box set to OVER ALL so when you get to the end of the report the total will be the total number of unique ID's on the report. If you set the Report Footer text box to refer to that text box, I think it should show you the final total.

 

[jackshield]

so i will have to add some textboxes to read other textboxes.

do you use the textbox names in the control source to link them?

( i really have no access skills at all )

 

[boblarson]

so i will have to add some textboxes to read other textboxes.

do you use the textbox names in the control source to link them?

( i really have no access skills at all )

It would be

=[ControlNameHere]

 

[jackshield]

Just got to figure out how to do those things, got interrupted right in the middle of it to chase othere tangents. i will give this a try in the morning.

i would thank you for all your HELP, but that would be a falicy, so thank you for doing the WORK to make my job easier.

you, sir, are a true rock star from mars, with tiger blood coursing through your veins!