I want to change the table at run time. I will explain u the situation.

I have a database operating in the multiuser environment. User keeps on consolidating the reports at the end of the year (or they may do it in the mid'ts also).

They r stored in a table with the name and the year eg. Consolidation 1998, Consolidation 1999 etc.

My problem is if I want a single rpt file to generate all the report based on the different Consolidation tables.

I am using Vb 5.0 to generate reports.

I hope I have given u a clear picture. any doubt please ask me.

See if u can answer me at the earliest.

Thanks in adv.