Simple Counting Function

[breeden.christopher]

Sorry, I'm fairly new to access, but I need to figure out how to:

Count the number of records in a query.
and display it in a text box named txtBox.

Could I get a hand with this? Thanks in advance.

 

[Guest]

I assume you are using the query as a source for a form? Put the following in
the control source of the text box

=RecordsetClone.RecordCount

 

[Marshall Barton]

Sorry, I'm fairly new to access, but I need to figure out how to:

Count the number of records in a query.
and display it in a text box named txtBox.

Use a text box (in the form's header or footer section) with
the expression =Count(*)