Counting records on a report

[flybravo]

Firs off, I hope this is the right forum to be posting this question.

I have a report that has four other subreports in the report. I need to be able to count the number of records based on an inspectorsID at the top of the page, for each sections and show the number at the bottom of the main reports?

 

[Nowell]

Hi, on each subreport create a text box and set the control source to =Count(*)

 

[PaulBricker]

Nowell's suggestion is right on but if you have multiple inspectorID's on each subreport that have to be counted you may need something like this as the control source for your textbox.

=Sum(IIf(InspectorID = 1234,1,0))

This will give you a count for that specific inspector. Then you would create separate textboxes for each InspectorID.

Paul

 

[Nowell]

Paul, thanks for your input.
Could you tell me the difference between an IIF statement and an IF statement?

 

[PaulBricker]

The IIf statement is actually an Access built in function and the If..Then statement is a VBA condtional statement. They basically work the same way. They evaluate a condition and then branch to the appropriate response. The difference is where you can use them. You can use an IIf() function directly in the Control Source for your textbox where you can't use the If...Then statement. That needs to be placed in a module and used within the VBA framework.
Hope that helps.

Paul