make table query

[inexperienced user]

I am an inexperienced user of Microsoft access. I would like to be able to produce a stock checking system. I need to produce a form that enables items to be entered into a specific table depending on the month. For example data into a stock check from on the 09/09/2003 automatically generates a table with the date 09/09/2003 as it’s name. I have already tried to produce as system where by date entered into a table via a form is transferred to another table via a make table query, however each time I run the query table produced the previous run is over written. I would like a new table to be produced every time with the current date as it title.

 

[John Vinson]

I am an inexperienced user of Microsoft access. I would like to be able to produce a stock checking system. I need to produce a form that enables items to be entered into a specific table depending on the month. For example data into a stock check from on the 09/09/2003 automatically generates a table with the date 09/09/2003 as it’s name. I have already tried to produce as system where by date entered into a table via a form is transferred to another table via a make table query, however each time I run the query table produced the previous run is over written. I would like a new table to be produced every time with the current date as it title.

I agree with Jackie, but even more emphatically. THIS IS VERY BAD
DESIGN. Storing data in tablenames will very quickly make your
database unusable!

Rather than having 268 tables each with a day's worth of stock checks,
have ONE table with a Date/Time field specifying which day's data this
record contains. You can then create a Query selecting the #9/09/2003#
data from your table, or compare that data to the previous day's data,
or any of a vast array of other possible searches.