[AccessD] Quick Syntax Question

Hi Connie:

Could this work...

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

HTH
Jim

-----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: Thursday, July 01, 2004 10: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