[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