Rocky Smolin - Beach Access Software
bchacc at san.rr.com
Sat Jan 28 12:05:05 CST 2006
How is Row defined as a field in the table that the query uses? Rocky Gowey Mike W wrote: > Sorry about that, > > If I run qryInmatesBinNumberUpdate it runs fine. > > If I run > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = '0' > > OR > > SELECT SID FROM qryInmatesBinNumberUpdate WHERE Row = 0 > > They both give me invalid procedure call > > Interesting...... > > -----Original Message----- > From: Gustav Brock [mailto:Gustav at cactus.dk] > Sent: Friday, January 27, 2006 10:35 AM > To: accessd at databaseadvisors.com > Subject: Re: [AccessD] Function Error > > Hi Mike, you didn't reveal the result of this: > > >> 2005-01-27 16:09:23 >> > > 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 > > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com