Saving Reports

[MoJo76]

I have created a monthly report in Access and it populates on it's own when
records are modified. However, I cannot seem to save each monthly report,
it is always modified. I have been exporting to excel but the report header
is all screwy looking. I then import back into Access and save. How can I
save a report form yet save each one as an individual?

 

[Klatuu]

Reports don't contain any data. Only tables contain data. Reports are one
way of manipulating and displaying data. Each time you run a report, it will
show the current state of the data in the underlying tables.

I don't know your data, so I can't say what it would take to reproduce a
previous month's data. In some cases, it can be done by filtering the
report's data for a specific time period. That would assume the data for
pervious time periods does not change.

But, if all you are looking for is a way to save a report, you can either
create and save a pdf or snapshot view (.snp) in a folder. If you want to
use Excel, don't use a report, just export the data to an Excel workbook and
save it.