Line numbering in recordset

[boyet0911]

strSQL = "SELECT tblBillDetails.*, " & _
"(tblBillDetails.SubscriptionFee + tblBillDetails.InstallationFee + tblBillDetails.Arrears + tblBillDetails.Others) as TotalAmountDue, " & _
"(tblSubscribers.Lastname & ', ' & tblSubscribers.Firstname & ' ' & tblSubscribers.Middlename) as SubscriberName, " & _
"tblSubscribers.Barangay " & _
"FROM tblBillDetails " & _
"INNER JOIN tblSubscribers ON tblBillDetails.SubscriberNo=tblSubscribers.SubscriberNo " & _
"WHERE MasterBillNo='" & strMasterBillNo & "' " & _
"ORDER BY tblSubscribers.Barangay, tblSubscribers.Lastname, tblSubscribers.Firstname, tblSubscribers.Middlename"

This query will return a recordset. Normally, it does not have a line numbering in each row.

Can anyone help me modify this code so that i can add line number which is autoincrement or serially.

thanks a lot!


BTW. I am using MS Access and VB6 and ADO.

[Hack]

What do you do with the records that are returned in the recordset?

[Mark Gambo]

What database are you using?

[Hack]

Judging by the use of the tbl prefix in the table names, I would guess Access.

[Mark Gambo]

. . . BTW. I am using MS Access and VB6 and ADO.

Judging by the use of the tbl prefix in the table names, I would guess Access.

I guess we missed this part. So I guess my Stored Procedure example wouldn't apply.