Nested parameter queries in access 2000.

[Nick A.]

Hi all

I have an Access 2000 DB. In it i have a query Q1:

PARAMETERS DATE_FROM DateTime, DATE_TO DateTime;
SELECT *
FROM TABLE_1
WHERE (TABLE_1.tb1_Date>=DATE_FROM) And (TABLE_1.tb1_Date<=DATE_TO);

I would like to call Q1 from within Q2. How do i pass the DATE_FROM and DATE_TO parameters from Q2 to Q1? I tried to create a Q2 like this:

SELECT *
FROM Q1
WHERE (DATE_FROM=#1/1/2005#) And (DATE_TO=#12/31/2005#);

but of course it didn't work.