//RECORDSET - MISSING RECORDS

[trystanhuwwilliams]

Hello there, this may be something simple i don't know - but this is my code for counting all the records within my table 'CONTRACTORS':

[/code]
Dim RS As DAO.Recordset
Dim DB As DAO.Database
Set DB = CurrentDb()
Set RS = DB.OpenRecordset("CONTRACTORS&quot
With RS
.MoveFirst
.MoveLast
End With
tot = RS.RecordCount
MsgBox tot
RS.Close: DB.Close
Set DB = Nothing: Set RS = Nothing [/code]

This procedure tells me that there are 1948 records in this table - when in fact there are exactly 2000 - Does anyone know why this may be?

Thanks

Trystan