In Access2000 with DAO...
Is there a way to base a Recordset on a Query witout creating a Table?
Jon
Printable View
In Access2000 with DAO...
Is there a way to base a Recordset on a Query witout creating a Table?
Jon
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?