Dynamic table changes

[CharlesCook]

Each month my customer will create a new Access table showing the current forecast of sales. I need to create a report that shows data from this table comparied to data from a different table (Last months table).

Each time the report is run 2 different tables could be used.

The layout of the tables will allways be the same.

The customer can not put all the data in one table (adding more data each month) because it will change many times before it is finalized. They want to drop the table and reload it over and over and over till the numbers stop changing...

How can I change the tables each time dynamicly.

Thanks in advance for you help.
CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining

 

[dgillz]

Database, verify database will read the changes in the database. The "verify on every print" option may be good to use until the database is somewhat more static.

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com