[AccessD] query question

Hello Mark, Rocky and Dan,

thanks for your help.
Together with the reference Gustav gave me, it will be no problem to get the 
missing numbers easier then i did before.

Pedro




----- Original Message ----- 
From: "Mark A Matte" <markamatte at hotmail.com>
To: <accessd at databaseadvisors.com>
Sent: Monday, January 19, 2009 5:36 PM
Subject: Re: [AccessD] query question



Pedro...something like this might help you Isolate the 'Number' missing...a 
little code and you could re-build the serial...

Hope it helps...

Mark

SELECT IIf(IsNull((select serial from tblserial where 
Int(Right(tblserial![serial],5))= 
Int(Right(s1![serial],5))+1))=True,Int(Right([s1]![serial],5))+1) AS Missing
FROM tblSerial AS s1
WHERE (((IIf(IsNull((select serial from tblserial where 
Int(Right(tblserial![serial],5))= 
Int(Right(s1![serial],5))+1))=True,Int(Right([s1]![serial],5))+1)) Is Not 
Null));

----------------------------------------
> From: pedro at plex.nl
> Date: Mon, 19 Jan 2009 10:04:35 +0000
> 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
_________________________________________________________________
Windows Live™: Keep your life in sync.
http://windowslive.com/explore?ocid=TXT_TAGLM_WL_t1_allup_explore_012009
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com