displaying the count of records in a subreport

[Sam Summers]

I am trying to display the total for the number of records that are displayed in a sub-report on the main report using a textbox?

I am using this:-

=Count [Reports]![VisualExamCert]![ItemLocation subreport].ItemNo

"VisualExamCert" is the main report.
"ItemLocation subreport" is the subreport, and ItemNo is the field on the subreport that I am referencing in order to give the total.

Thank you in advance

 

[Rich]

=Count(*) in the subreport footer, then just reference that textbox in the main report

 

[databasedonr]

Corollory ....

I have a similar situation, although in some cases I have a subreport that has no matching records, in which case I receive an "#Error" instead of a count of 0 .... Any help would be gratefully accepted!

 

[databasedonr]

Sheesh....

I figured it out myself *sorry* -- but I just added a Label and used the On No Data Event to set the value of the label to "No matching records" and then make either the text box with the Count visible, or my label visible, depending on the case. This might help someone else, though, and it works well.