Record Count

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
 
How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
Click to expand...

On a Form?.

Both of these work for me.
= Recordset.RecordCount
or
=Count(*)
 
I searched everywhere for the remedy. I should have shopped here first.
Thanks

fredg said:
How can I make a text box show the record count? I thought I could go to the
properties of the text box and under Control Source type in =Count([Ponum)]
and it would count the field. It works the way I typed it one time but then
gives me an error in the text box when I go out and back in.
Click to expand...

On a Form?.

Both of these work for me.
= Recordset.RecordCount
or
=Count(*)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count null fields 4
Excel VBA - counting cells by colors and names to it in two different rows. 0
Access MS Access DCount function problem 0
start count after 3rd. record. 2
count number in field 5
Access Dcount function in access 0
Access Dcount (multiple criteria) 3
Count in a Report Footer of a Report 2

Back
Top