Gustav Brock
Gustav at cactus.dk
Mon Jan 19 03:34:26 CST 2009
Hi Pedro A nice article by two well known authors is on-line on the subject: Find and Generate Missing Values in an Access Table http://www.devx.com/dbzone/Article/40345 You should be able to tweak the code for your purpose from adding 1 (one) to a Long key/id to your string key. /gustav >>> pedro at plex.nl 19-01-2009 10:04 >>> Hello Group, in lists of serialnumbers i have to determine if there are any numbers missing. Normaly i make a serialnumber list in excel, import it to access and do a Non-related records query to filter the difference. Can this also be done directly in access? For example. I have an number list from F08-00001 to F08-00005 F08-00001 F08-00003 F08-00004 F08-00005 The query must give F08-00002 as result, because this is missing in the serialnumber list. Thanks Pedro -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com