Count records in data report

justus
10-19-2004, 08:40 AM
Hi Buddies
I have a report that displays data from a recordset.I need to number the records.How do i do this? I need your assistance urgently.But how do i dsiplay the count on the data report.
Regards
Justus Njoroge

Shurik12
10-19-2004, 08:46 AM
Hi,

rs.RecordCount

waits77
10-19-2004, 09:52 AM
be sure to .CursorLocation = adUseClient as the RecordCount doesn't work properly with server

MKoslof
10-19-2004, 05:38 PM
In addition, if the sole purpose of this query is to return the recordcount, you can do a SELECT COUNT(*) query to return the recordcount.

Dennis DVR
10-21-2004, 04:03 AM
Hi Buddies
I have a report that displays data from a recordset.I need to number the records.How do i do this? I need your assistance urgently.But how do i dsiplay the count on the data report.
Regards
Justus Njoroge

you can also use the function control of Data Report and set it to count vertically and set the datafield to a keyfield in your recordset.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum