Curtis, Andrew (WAPL)
andrew.curtis at wapl.com.au
Fri Jul 2 01:11:37 CDT 2004
This is going to sound far out, Try it without the "; " on the end andrew -----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:54 PM To: accessd at databaseadvisors.com Subject: [AccessD] Quick Syntax Question 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. -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com CONFIDENTIAL COMMUNICATION If you receive this confidential communication by mistake, please contact the sender immediately by return electronic mail. Worsley Alumina Pty Ltd ABN 58 008 905 155 is the manager of the Worsley Joint Venture - Bauxite/Alumina Operation. Liability and responsibility of the Joint Venturers is several in accordance with the following schedule of participating interests: Billiton Aluminium (RAA) Pty Ltd 56 percent, Billiton Aluminium (Worsley) Pty Ltd 30 percent, Japan Alumina Associates (Australia) Pty Ltd 10 percent, Sojitz Alumina Pty Ltd 4 percent.