How do i make a table using todays date as the name?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to implement some change control. Can i use a make table query to
make a table of what is todays data and name it in such a way that it is not
overwriten when i run the same query again tomorrow by using some variable
such as "today()"

Over time i should get a daily snapshot of the data which would be really
useful for analysis.

Please let me know if this is possible!
Thanks in advance
 
i wouldn't create multiple tables at all; that's going to make analysis
harder, not easier. i assume you're taking daily "snapshots" of table data
that changes frequently. suggest you create a single table to hold the
snapshot data, perhaps named tblHistory. include all the fields that you'll
be appending from the "live data" table, and add an additional Date/Time
field, which i'll call HistoryDate. create an *append* query (not
make-table), to append the data from the "live" table to tblHistory. in the
query, add a calculated field, as

HDate: Date()

to append into the HistoryDate field in tblHistory. so each day the snapshot
data will be appended from the live data table into tblHistory, each record
stamped with today's date. to analyse the data by date, or month, or
quarter, or year, or whatever time frame you choose, simply set criteria on
the HistoryDate field.

hth
 
Back
Top