connie.kamrowski at agric.nsw.gov.au
connie.kamrowski at agric.nsw.gov.au
Fri Jul 2 00:54:02 CDT 2004
Andrew, I tried using count(*) but that did not work either. I am about to give up and go home I think ... except I know I will spend all weekend trying to figure it out In this case use count(*) instead of specify field name. andrew Andrew, yes it is an integer, I tried declaring as a long as well but still got the error. Curtis, Andrew (WAPL) andrew.curtis at wapl.com.au Fri Jul 2 00:41:54 CDT 2004 Is AuthorityID in tblDAuthorityConditionSpecific an integer field? WHERE [tblDAuthorityConditionSpecific].[AuthorityID] = " & RenewID & "; " Is saying that it must be if renewed is an integer. Another possibility is that the integer variables should be declared as LONG instead. Andrew Curtis Andrew, yes it is an integer, I tried declaring as a long as well but still got the error. Curtis, Andrew (WAPL) andrew.curtis at wapl.com.au Fri Jul 2 00:41:54 CDT 2004 Is AuthorityID in tblDAuthorityConditionSpecific an integer field? WHERE [tblDAuthorityConditionSpecific].[AuthorityID] = " & RenewID & "; " Is saying that it must be if renewed is an integer. Another possibility is that the integer variables should be declared as LONG instead. Andrew Curtis -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of connie.kamrowski at agric.nsw.gov.au Sent: Friday, 2 July 2004 1:12 PM To: accessd at databaseadvisors.com Subject: [AccessD] Quick Syntax Question -- Connie Kamrowski Analyst/Programmer Information Technology NSW Department of Primary Industries Orange Ph: 02 6391 3250 Fax:02 6391 3290 This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient or received it in error, please delete the message and notify sender. Views expressed are those of the individual sender and are not necessarily the views of their organisation. This message is intended for the addressee named and may contain confidential information. If you are not the intended recipient or received it in error, please delete the message and notify sender. Views expressed are those of the individual sender and are not necessarily the views of their organisation.