can access handle nested sub queries

[raj chahal]

hi
I've kindly recieved help on a previous topic. The question now is : will
the code below work with acess ?

SELECT EventName, dt
FROM tablename
WHERE (dt >= #20030928# AND dt <#20031006#)
OR (recurring = 1 AND DayOfWeek IN (SELECT DayOfWeek FROM DatesTable
WHERE
(dt >= #20030928# AND dt <#20031006#) AND dt >= tablename.dt))

Thanks again

Raj

 

[Tim Ferguson]

I've kindly recieved help on a previous topic. The question now is : will
the code below work with acess ?

No: because the date literal values are corrupt. But the subselect will
work.

Tim F

 

[Albert D. Kallal]

Yes, but you have to format your dates in use fomrat for jet.

mm/dd/yyyy