Can you query a recordset ?

[kirkm]

Hope that isn't a silly question... I already have a query that gets most of what's required but would like to further refine it. I realise I could use many queries first, each with the required criteria but if it's possible to run a query on an existing recordset result that would be better. I think.
Thanks for any advice.

 

[Maximation]

Are you asking about something like a dynamic search to use on a query? If so here is an example I found on the forum that might help:
http://www.access-programmers.co.uk/forums/showthread.php?t=188663&highlight=search

 

[Galaxiom]

A recordset can be filtered.

 

[MarkK]

But generally it's faster, safer, and clearer to open the recordset you need, rather than try to navigate, tweak or manipulate the recordset you opened for some other purpose.

What does make sense is to query a query, so if you have . . .

SELECT * FROM Table WHERE Field1 > 50

. . . saved as 'qBiggerThan50,' you can do . . .

SELECT * FROM qBiggerThan50 WHERE Field1 < 60

. . . with obvious results.