[AccessD] query question

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





More information about the AccessD mailing list