Select table to query

  • Thread starter Thread starter Jose Lopes
  • Start date Start date
J

Jose Lopes

I have some tables that are named according to the date they are created e.g.
20080101TABLE, 20080215TABLE… and so on. The field names on these tables are
exactly the same. Currently I’m building a query to analyze every table but I
want to make this procedure faster. Before I run the query I would like to
select the table I’m interested. How can I achieve this? My access skills are
quite limited but if someone could give an example or some guidance I think I
would be able to achieve it.

Thanks in advance.
 
Add a field for date and combine your tables into one. You will not need to
change tables, just add criteria for date or dates.
 
I have some tables that are named according to the date they are created e.g.
20080101TABLE, 20080215TABLE… and so on.
Click to expand...

That's really, really bad design for exactly the reason you are experiencing.
The field names on these tables are
exactly the same. Currently I’m building a query to analyze every table but I
want to make this procedure faster. Before I run the query I would like to
select the table I’m interested. How can I achieve this? My access skills are
quite limited but if someone could give an example or some guidance I think I
would be able to achieve it.
Click to expand...

Run Append queries to copy all of these tables into one big table, with one
additional field for the date.

"The table's too big" you say? You're mistaken; the Database is limited to two
gigabytes, and you'll run out of room FASTER by having the data in multiple
tables, each with its own system overhead.

"I need the date" you say? Sure, keep the date in an indexed date/time field
in the table, and use a Query selecting just the records for a given date.

"There are too many records"? 20,000,000 is getting a bit too big, maybe; and
if you have over a million records in each date table you need to be putting
your data into SQL/Server or another client/server database anyway. If you're
talking about under 100,000 records total you should have no problem.
 
Back
Top