VBA - Processing field DATE in Sql statement

[fcail]

Hi,
When i run my sql Query, i have no problem, i try to execute in a vba code and it doesn't work :

My code :
SQL = " SELECT Extraction.Date FROM Extraction WHERE (((Extraction.Date) > #6/1/2006 0:0:1#))"
MsgBox SQL
DoCmd.RunSQL SQL

Thanks for your help.

Freddy

 

[JerryKlmns]

SQL = "SELECT Extraction.Date FROM Extraction WHERE (((Extraction.Date) > #2006-06-01 00:00:01#))

 

[PHV]

The DoCmd.RunSQL accepts only ACTION queries ...

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