Can Data be Stored in a Report

[jgross]

I'm wondering if it is possible to store data as part of a report, but not part of an underlying table. I have a simple calendar database with a report that prints one page for each day of a project listing all the various events for each day. I would like a version number to appear atop each page so that as events change and pages are reprinted with new information we can keep track of what information is most current.


My first thought was to place a combo box in the group header of the report (I've used the group feature to organize the record set into individual days) with fixed values of the version numbers we use. My hope was that in report view, I could simply select a version for each day and then that information would print with the report. The problem I've run into is that this information doesn't seem to "live" anywhere. Any time I navigate away from report view, the values are all reset to 1. As a possible solution I tried creating a table that would simply store the values v1 through v9 and making that the data source for the combo box. Access doesn't like this, though, because there is no actual relationship between the values in that table, and the value of the table that makes up the record set the report generates.
Is what I'm trying to do even possible, or am I simply approaching this from the wrong angle? Thank you for your help and patience.

-Jim

[pbaldy]

The short answer is that data can not be stored in a report. You'll need to store it in a table. You could use a DMax() to get the latest value from the table.