Changing the data type from Integer to Long could be one solution (if the
table is too large).
The idea of looping through the recordset to increment a counter (as suggested
by someone in this forum), SHOULD BE AVOIDED - it is a very ineffecient
way of doing it.