[AccessD] Quick Syntax Question

On 2 Jul 2004 at 15:11, connie.kamrowski at agric.nsw.go wrote:

> 
> 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
> 
The only thing I can spot is a missing space before "FROM"

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.