Using date as table Name with clause INTO

  • Thread starter Thread starter Michel L.
  • Start date Start date
M

Michel L.

I have 2 questions :

1- In creating a new table from the results of a select
statement, I would like to name de new table with current
date

Exemple: Into "031205" for (2003-12-05) as table name or
something similar.

Is't possible to do that and if so,how to write the right
clause into

2- Do you know where I can find a good design exemple of
a Inventory database and if possible one using Firts In,
First Out method as cost flow assumptions.


Thanks in advance for your help

Michel Laflamme
 
See comments in-line.

--
HTH
Van T. Dinh
MVP (Access)



Michel L. said:
I have 2 questions :

1- In creating a new table from the results of a select
statement, I would like to name de new table with current
date

Exemple: Into "031205" for (2003-12-05) as table name or
something similar.

Is't possible to do that and if so,how to write the right
clause into
Click to expand...
What you proposed may mean that the database is not properly structured and
implemented. In Relational Database Design Theory, you don't store data in
the object names (and "031205" sounds it is data in your database.)

Suggest you read up on the relational Database Design Theory first and then
check the structure of your database.

An inappropriate database structure often leads to difficulties and problems
later so it is important to get it right at the beginning.



2- Do you know where I can find a good design exemple of
a Inventory database and if possible one using Firts In,
First Out method as cost flow assumptions.
Click to expand...
Not a sample database but try:

http://users.bigpond.net.au/abrowne1/AppInventory.html
 
Back
Top