[AccessD] Quick Syntax Question

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


Hi guys,

Am trying to code an SQL statement behind a form as follows

RenewID = Me.AuthorityRenewalID.Value
Specific = "COUNT([SpecificCondition])FROM
[tblDAuthorityConditionSpecific]
WHERE [tblDAuthorityConditionSpecific].[AuthorityID] = " & RenewID & ";
"

The variables have been declared as integers but I am getting a type
mismatch error on the second sentence, The value for RenewID is working
but
it won't let me past this

any suggestions

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.


-- 
_______________________________________________
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.