Simple Counting Function

  • Thread starter Thread starter breeden.christopher
  • Start date Start date
B

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.
 
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
 
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.
Click to expand...


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