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.