Changing Database Table

[Montana751]

I am currently pointing to a database that has a table called 2001. Every year I have to change my reports to poit to a new table in that database (has all of the same fields). The new table is called 2002 for this year. I set the location for 2001 to point to 2002. But, how can I change the name of the table? Is it even possible?

2001.AccountName will still read 2001.AccountName but will pull the data from the 2002 table.

 

[dgillz]

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