What is wrong with this Access Query

[meinhunna]

SELECT A.CompanyCode, C.IndustryCode, B.Risk, B.PeriodEndDate
FROM (CompanyDetails AS A INNER JOIN CompanyFigures AS B ON A.CompanyKey = B.CompanyKey) INNER JOIN tblSubIndustry AS C ON B.SubIndustryCode = C.SubIndustryCode
WHERE C.IndustryCode = [IndCode]
AND B.PeriodEndDate BETWEEN #01/06/2002# AND #31/02/2003#;

when i run it i get an error saying

Syntax error in date in query expression 'C.IndustryCode = [IndCode]
AND B.PeriodEndDate BETWEEN #01/06/2002# AND #31/02/2003#'

 

[jbpez]

What's [IndCode] ?

John Borges

 

[PHV]

#31/02/2003#
What day it is ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[meinhunna]

such a silly mistake. thanks