Saving a Report and Cutting Links

[Guest]

I have a report with a subreport in it. I view this report by selelcting a
button in my form. Is it possible once I have the report open to run a save
as and save a specific report but then turn all my linked data into permanate
data. So my links from the query will break but I still keep all my values.
The reason I ask is that I'm creating this report based on current prices,
but the prices will change and I'm not sure how to save it. Is this possible
or not>

Thanks in advance.
Travis.

 

[Guest]

Or is there a way to export the report into Excel or something.

 

[CompGeek78]

Are you trying to do this manually or programatically?

If you are planning on doing it manually, you can go to the File menu,
to Export, then choose what format you want to use (Excel, HTML,
Snapshot, Text).

If you are doing it programatically, then you can use one of several
options to export it. If you want text or an Excel file, use either
docmd.transfertext or docmd.transferspreadsheet methods. If you want
HTML or Snapshot, the DoCmd.OutputTo method should serve you.