Date in Table Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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]
 
Back
Top