can access handle nested sub queries

  • Thread starter Thread starter raj chahal
  • Start date Start date
R

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
 
I've kindly recieved help on a previous topic. The question now is : will
the code below work with acess ?
Click to expand...

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

Tim F
 
Back
Top