Query-based Recordset

[jkurpias]

In Access2000 with DAO...

Is there a way to base a Recordset on a Query witout creating a Table?

Jon

[DrewDog_21]

All you need to do to select data from a query is to establish the query itself in the database and then use the query name instead of a table name in your SELECT statment (e.g. "SELECT * From MyQuery ORDER BY MyField"). I don't exactly understand your problem, though. Could you explain it a little more?