Saving recordsets for future reference

[scotent]

What is the easiest way to save a recordset? The idea is that after having dynamically created a query, the user can save those results for future reference.

Saving the bquery will not produce an accurate reord of the a previous recordset as the records will be ammended, added and changed over time. So the actual result is what I am after, also the ability to save the query for a future requery would be a bonus.

TIA

 

[JGillespie]

Run the query and then go to File, Export and save it as an RTF file. Jamie Gillespie
j-gillespie@s-cheshire.ac.uk

 

[mdthornton]

If the output columns are the same in each case you could store the results in an archive table with something like run date/time and user added as a look up key. Eg,

insert into queryArchive
select myUser, Now(), aQuery.*
from aQuery

If the columns are not the same output as a delimited text
file (via TransferText method). That way you can reimport the data at a later date if necessary.


Good Luck,
Mike

 

[scotent]

Both excellent suggestions - will try both in combination.
Will let u know how i get on.

Thanks