[AccessD] Function Error

Mike:

IN your OpenRecordset you refer to 'Row' but that's not in your query, 
is it?

Rocky


Gowey Mike W wrote:
> This is the SQL of qryInmatesBinNumberUpdate:
>
> SELECT Mid([inmates].[sid],(Len([inmates].[sid])-1),1) AS BinRowNum,
> Inmates.SID, Inmates.Namef, Inmates.Namel, Inmates.Namem, Inmates.DOB,
> Inmates.Cell, Inmates.Race, Inmates.Custody, Inmates.Age,
> Inmates.HasBlues
> FROM Inmates
> WHERE (((Inmates.Cell) Not Like "DS*" And (Inmates.Cell) Not Like "IM*"
> And (Inmates.Cell) Not Like "IN*" And (Inmates.Cell) Not Like "M-*" And
> (Inmates.Cell) Not Like "S-*" And (Inmates.Cell)<>"") AND ((Exists
> (SELECT SID FROM FTLaun WHERE FTLaun.SID = Inmates.SID))=False) AND
> ((Exists (SELECT SID FROM BinNumSIDAssign WHERE BinNumSIDAssign.SID =
> Inmates.SID))=False))
> ORDER BY Mid([inmates].[sid],(Len([inmates].[sid])-1),1), Inmates.SID; 
>
> -----Original Message-----
> From: Gustav Brock [mailto:Gustav at cactus.dk] 
> Sent: Friday, January 27, 2006 10:54 AM
> To: accessd at databaseadvisors.com
> Subject: Re: [AccessD] Function Error
>
> Hi Mike
>
> So what is the SQL of qryInmatesBinNumberUpdate?
>
> /gustav
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
>   

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