Renaming linked tables

[Gates Is Antichrist]

I have devised a "new" technique and hereby ask you guru gods for your approval. Are there pros and cons I might not realize?

I have been running a set of queries each quarter. They once used table T_032003, and the next quarter they used table T_062003, and so on. I had to edit the queries every quarter to update the table reference.

Then for 9/30/03 I decided: why don't I just take the new link to T_092003, and rename the link to T_CurrQtr. Each quarter I can just repeat this, to link to the latest and greatest. Then I can have the queries simply always refer to T_CurrQtr, and I won't have to edit them every quarter.

The queries already used a linked table, so all I'm doing in adding a "layer" is in the rename. But I wonder if there might be a subtle drawback. Moreover is this a common practice already? TIA

 

[Dugantrain]

As long as it's linking to the correct table, I don't see why anything would be wrong.