A little background info here. I'm accessing a FoxPro table / database from a CD-ROM (ick!). There are lots of tables, but one huge *mutha* of a table that takes up most of the CD. Now, imagine doing a SQL query on that... sorted, even... now you have entered my little room in hell.
Okay, I'm going thru various testing ideas here to help speed this thing up. There comes a point after the first SQL execution where I need to "fine tune" the data, in a branching kind of way. I need a subset of the original query, while keeping the original query.
Can this be done without executing a new query?
I know about the Filter property on a query, but that doesn't allow me to branch off...
I wish there was something like a query.assign where it could just transfer over the guts and then I could apply the filters.