You have two "WHERE" words back to back.  This should throw an error...

AR
----- Original Message -----
From: "Himanshu Chaudhari" <himanshuchaudhari@y...>
To: "sql language" <sql_language@p...>
Sent: Thursday, June 21, 2001 10:46 PM
Subject: [sql_language] RE: date problem


> I  used this function
>
> axz=DateAdd("h",-1,dtNow)
> sqlss="select distinct[smsto] from smsto where WHERE
> dates>=#"&axz &"#"
>
>
> now it is showing right date but it is giving error on
>  running query:
>
>
> Microsoft OLE DB Provider for ODBC Drivers error
> '80040e14'
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error
> (missing operator) in query expression 'WHERE
> dates>=#6/22/01 9:09:00 AM#'.
>
>
>
>
>
>