If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Daily Make Table Query
I have a Make Table Query that I will need to run every morning. Is there
anyway to have the query add today's date to the name of the table (without going in and changing it everyday) so that the new table won't overwrite yesterday's table? |
#2
|
|||
|
|||
Daily Make Table Query
=?Utf-8?B?SkQ=?= wrote:
I have a Make Table Query that I will need to run every morning. Is there anyway to have the query add today's date to the name of the table (without going in and changing it everyday) so that the new table won't overwrite yesterday's table? In VBA you can use a command like: DoCmd.RunSQL "SELECT * INTO T" & Format(Date, "yyyymmdd") & " FROM T1" -- Groeten, Peter http://access.xps350.com |
#3
|
|||
|
|||
Daily Make Table Query
JD wrote:
I have a Make Table Query that I will need to run every morning. Is there anyway to have the query add today's date to the name of the table (without going in and changing it everyday) so that the new table won't overwrite yesterday's table? Just wondering, but is there a reason you can't just keep all the data in the same table and index it so you can filter it easily? Whenever I see someone asking about chunking data into lots of tables with the same structure, it makes me leery... -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|