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