[AccessD] query question

Pedro:

Two approaches I can think of right off: 1) a bit of code - if the format of
the field is consistent, you can take the VAL of the right 5 characters and
see if they follow in sequence; 2) build a complete table of those Fxx-xxxxx
values and use the unmatched query wizard to make a query that would show
all the values in the complete set of values that are missing from the
original set. 


Rocky Smolin
Beach Access Software
858-259-4334
www.e-z-mrp.com
www.bchacc.com
 
 

-----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