SQL Access 97 problem

[peekay]

I have the following query that I wish to run on a table named activities with the fields startdatetime as date,penddate as date,username as string,done as boolean :

Select * from activities where done=false and username='peka' and (isnull(penddate)=true and datevalue(startdatetime)=<#05-May-01#) or (isnull(penddate)=false and penddate>#05-May-01# and penddate<=#05-May-01#) order by startdatetime

I get the error Syntax error (missing operand)
Can somebody please help me with the correct syntax

PK Odendaal
pko@mweb.co.za

 

[BlackKnight]

Hi,

Get rid of the datevalue() and change the =< to <=

Have a good one!
BK

 

[tlbroadbent]

The problem is definitely the =<. You can keep the datevalue which may be required if &quot;startdatetime&quot; is stored as a string. Terry

http://members.home.net/tlbroadbent/index.htm

 

[peekay]

BlackKnight and tlbroadbent.

Thanks for the tip. The <= did the trick. It is permissible and necessary in this case to keep the datevalue if you wish to compare only the date parts of the field.

Thanks.

PK Odendaal
pko@mweb.co.za