Count records in data reportjustus 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