it6 ok - ive got that covered - the database isnt for th web and has recent been imported from a spreadsheet, and after checking it was all logicallynumber from 1 to 999 (result!) -----Original Message----- From: thelist-admin at lists.evolt.org [mailto:thelist-admin at lists.evolt.org]On Behalf Of Chris Blessing Sent: 17 January 2002 18:28 To: thelist at lists.evolt.org Subject: RE: [thelist] Only display first 100 records from access Remember though that if your primary keys are not all incremented by 1 (i.e. 1, 2, 3, ... 100, 101, 102) you will miss records... (for example if you've deleted some records in between your min and max limits). Chris Blessing webguy at mail.rit.edu http://www.330i.net