Archiving Query Results/Reports

[kamur]

Hello,

I have an application, through which I generate multiple reports in
RTF or Word Format. The application is in Access and the reports are
generated by SQL querying the backend database.

I label my reports with version numbers ..as Report 1.0, Report 1.1,
Report1.1.1 etc..

I need to archive all these versions of reports...How can I do this? (Storing them everything on a NT folder is okay,but I am looking a wider solution)
I need to archive all these query results/reports efficiently somewhere or using some software/tool....Appreciate any help..Thanks Kamur

Thanks
Kumar

 

[LittleSmudge]

WHY ?

The WHOLE point about Reports is that they DYNAMICALLY select the relevant data from the datapool based on the criteria selected then present that data for printing.

By providing the same criteria you can recreate the same report at any time in the future - so there is no need to store duplicate sets of the data.


However, if there really is some dynamic issue that means that you need to keep the dynaset results then:

Take the User inputs into a Make Table Query.
Base the Report on the table, then export the table to a specific file name of your choosing.


Or you could use the OutputTo function so save a snapshot of the Report to disk.

Syntax:
DoCmd.OutputTo objecttype[, objectname][, outputformat][, outputfile][, autostart][, templatefile]



'ope-that-'elps.

G LS