Make table query

  • Thread starter Thread starter Fab
  • Start date Start date
F

Fab

I have a make table query. Is there a way to dynamically name the table.

here is an exmaple of thw file name i want.

Table1_"current date"

i.e. Table1_Jul/12/2005

so in other words tablename and append the date it was runned?

Thanks
 
Why not just use an append query and add a date field to identify when the
records were created.
 
One way to do this is to make the maketable table name something like
"Table1_Current", then copy the table to the name you want:

DoCmd.OpenQuery "MyQuery"
DoCmd.CopyObject, "Table1_" & Format(Date,"mmddyyyy"),acTable,"Table1_Current"

....where MyQuery is your query name (replace with your own name) and format
the date as you like.

I have an aversion to putting special characters like "/" in object names.

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using the latest date in a table as criteria 4
Adding records to a table 18
Append Queries in 2007 5
drop-down based on parameter query 4
Make Table using VBA 8
Date Range Query. Criteria based in a table. 4
Make Table query. 2
Dlookup 7

Back
Top