make-table with field as name

[miss031]

For archiving purposes, I would like to make an automatic query that, when
ran, would make a new table with a particular field as the name of the table.

I'll elaborate:

Each time a new job is begun, there is table called "Job Information" in
which the date of beginning is entered in a field called "begindate". When
the job is completed, I want to archive it, by making a new table named the
date entered into the "begindate" field.

There is data from several other tables that will be added to the new
archive table, and removed from the original tables.
Please be gentle, I'm rust on the VB & SQL.

 

[KARL DEWEY]

A better way is to add a field in your existing table named Archived. Then
in your queries pull records that are not archived.

You only need to flag the record that has the project information. Any data
that is related (project details) would not need to have a flag field as the
one side of the relation would not be pulled into your queries and in turn
the details would also not appear.

Later is you wanted to see some project that was archived just unflag it in
the table and all information is available. This will save a lot of time
appending, deleting, and then to view next time to either append the records
back into the prime tables or build additional queries and forms, reports,
etc. to be able to view the data,

 

[miss031]

Do you think I should just add a date field to the each of the tables, and
when a new job is created, all of its records automatically have that job
date in them, and then filter by job date?

I am trying to make a very simple-to-use database, so I would like to
automate as much as possible.