[AccessD] query question

I would set up a loop that strips the 4 leading characters from this serial
number, then does a subtraction to see if the difference is = 1.  If not
then subtract 1 from the F08-00003 to record F08-00002 in your 'missing'
table.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of pedro at plex.nl
Sent: Monday, January 19, 2009 10:05 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] query question

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