I'd like to use a cell reference containing a date from a
worksheet in my MS Query to filter the record set.

I'm receive a syntax error when specifying the cell in the
SQL query shown below:

WHERE (EXCEL_FOrwardPlanning.fStartDate<='Summary - Perth'!
B4:D4) AND (EXCEL_FOrwardPlanning.fStopDate={ts '2004-06-
21 00:00:00'})

Does MS query allow you to use data from worksheets as
part of the query criteria and if so, what would be the
correct format?

Many thanks in advance.

Mark