Gowey Mike W
Mike.W.Gowey at doc.state.or.us
Fri Jan 27 09:18:51 CST 2006
I cycle through the table and the row number could be any number of 0 - 9 to check for a bin number. -----Original Message----- From: Gustav Brock [mailto:Gustav at cactus.dk] Sent: Friday, January 27, 2006 8:09 AM To: accessd at databaseadvisors.com Subject: Re: [AccessD] Function Error Hi Mike Have you tried running this on its own: qryInmatesBinNumberUpdate and this in a new query: SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0' or should it be: SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0 /gustav -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com