Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count records

Status
Not open for further replies.

impulse24

IS-IT--Management
Jul 13, 2001
167
US
I have a report in Access whose ControlSource is set to =Count(Title)

When opening the report #ERROR is displayed. What am I doing wrong? The report RecordSource is set to table Books, and there is a field in the table called titles(Text field). I just want to get the count of records in the table displayed on the report. Please help
 
You need to just use Count(*), or use the Count(*) with some criteria (~Where([Title] <> &quot;&quot;)?
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top