Well, I did finally get the count of records to work, although it is not where I want it to be. Previously, I had been trying to put the textbox with the record source of =count(*) in the page footer, but I always got a #error. If I place the record count in the detail section of the report, however, it actually does count the number of records. However, this does me no good...I get a record count of the total number of records after each and every record in the report, which seems redundant and kinda stupid.
So where else would I put this text box?
Thanks for any suggestions.
btw, I did rebuild the report, Pat, but with the same results...the =count(*) will only work if I put it in the detail section.
Oh, one other thing....I just noticed that even when I get the record count to print in the detail section, it's printing the total count of all the records in the table, not the number of records in the recordset that's been specified by the SQL statement.
[This message has been edited by LQ (edited 10-30-2001).]
[This message has been edited by LQ (edited 10-30-2001).]