[AccessD] Function Error

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





More information about the AccessD mailing list