Wondering if one can do a SQL query on a Recordset, I've searched and Googled, thus far found nothing useful. Currently my report project grabs data from an Access DB using SQL and does some aggregate on the data, works. What I am having trouble is that I like to do another SQL on that same Recordset, I am having trouble doing that. The way I am overcoming this problem is to create a temp table then do a SQL on that temp table. Just wondering if I can skip that step and do a direct query right on the Recordset.
Thanks.