Create New Table not from Query

I have a need based on a value in my form to create a new table on the fly
and then later append additional data to it.

I know how to do the append however how do I CREATE a NEW table on the run
with the name of a variable field.

The new CREATE TABLE would have the following fields

The table name would be the variable [TEAM]

InputDate RunDate Team NrEmps

???
another thought I had was to use a generic table name like VarTeam however
if I do that is there a way to delete the contents of the table but not the
table its self so that each set of appended data will not continue to build up

Thanks for all of the help from this site it is GREAT.....




--
Hansford D. Cornett

On Jan 11, 12:54 pm, Hansford cornett
wrote:
I have a need based on a value in my form to create a new table on the fly
and then later append additional data to it.

I know how to do the append however how do I CREATE a NEW table on the run
with the name of a variable field.

The new CREATE TABLE would have the following fields

The table name would be the variable [TEAM]

InputDate RunDate Team NrEmps

???
another thought I had was to use a generic table name like VarTeam however
if I do that is there a way to delete the contents of the table but not the
table its self so that each set of appended data will not continue to build up

I'd recemmend the second approach i.e. have a permanent working table,
with a key column (TEAM), to which you can JOIN in other stored queries
and gets cleared (DELETE FROM MyWorkingTable and loaded (INSERT INTO
MyWorkingTable...) as required.

Jamie.

--