Unanswered: Naming a new Table from a Make Table query
I want to use a Make Table Query to generate a new read-only Table. This I can do but my problem is that I want to be able to name the new Table containing only the records from a calendar year; e.y. Rents2001 and the next year another new table would be created and called Rents2002 and next year Rents2003 ...............
I require the Table to be generated yearly. I know I could do this in other ways but I really require the Table as once I have it I will be doing other things with it to give the final report.
Any suggestions how I can generate the Table with the YEAR being in the Table Name as part of running the Make Table Query? Thanks
Hmmm... This is a bit of a challenge in MS-SQL. I'm sure it can be done in Access, but darned if I know how. You might want to pose this question in the Access forum to see if one of the folks there have a clue.