Hi,

Please help!

I'm need to find out if it's possible to pass parameters to an MS Access query through an SQL statement.

So my query looks like this:

PARAMETERS Param1 Long;
SELECT RecID, Currentvalue
FROM tbl_Mytable
WHERE CurrentValue >= [Param1];

Can I then use this from another query?
select * from qry_Values {pass parameter}

It would seem crazy to me if you can't but I can't find anything on it.

Many thanks.
SW