pedro at plex.nl
pedro at plex.nl
Mon Jan 19 10:04:35 CST 2009
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