Syntax error in SQL statement

[ktb916]

Hi,

Can't see the problem with this piece of SQL statement but my query keeps crashing when i try to use it.

 strSql = strSql & "HAVING(((DatePart('" & "q" & "',[MainQA_Log]![Date]))=1 AND ((DatePart('" & "yyyy" & "',[MainQA_Log]![Date]))=2004)) "

Any ideas?

KT

 

[PHV]

my query keeps crashing
Any error message ?
What is the output of Debug.Print strSql ?

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

 

[ktb916]

Actually I just figured it out, one to many parentheses

Thanks for the response!!