Date in Table Name

T

Todd

Hi,
I'm writing a query to generate a table, i was just wondering how i can put
the date the table was made into the table name so it reads
enrolments20050118 rather then enrolments?

thanks
 
M

MGFoster

Todd said:
Hi,
I'm writing a query to generate a table, i was just wondering how i can put
the date the table was made into the table name so it reads
enrolments20050118 rather then enrolments?

thanks
Click to expand...

Why not put the date in the table instead of in the table name. Your
table naming convention indicates bad db design.
 
J

John Vinson

Hi,
I'm writing a query to generate a table, i was just wondering how i can put
the date the table was made into the table name so it reads
enrolments20050118 rather then enrolments?

thanks
Click to expand...

I'm with MG. Storing data (a date) in a tablename is very bad design.
You can't search on it; Access (quite properly) does not provide a way
of putting a table name as a parameter.

MakeTable queries are VERY rarely needed. If you store the date as a
datefield in your enrollment table, you can create a Query searching
for records with 1/18/05 in the date field; this will give you exactly
the same information as this table would, and can be used in the same
ways that the table could - as the recordsource for a form or report,
for an export, even for additional queries.

John W. Vinson[MVP]
 
Top