Jim Lawrence
accessd at shaw.ca
Fri Jan 27 13:09:52 CST 2006
Mike: Will the SQL statements work in the query builder? Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gowey Mike W Sent: January 27, 2006 9:41 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Function Error 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com