Hey,
I am designing a report that is going to run of a temporary table being created on a SQL Server via VB6. My question is how do I change the source table name in my code so it will look at the current temporary table. My temporary table names will vary but the fields inside them will be identically named. Will changing the source table name of the report effect the report itself if all the field names are the same still?

any input is greatly appreciated.