Asking for a table

[Guest]

I now have another question. In my database, I have three different tables
(ie Nov_2006, Dec_2006,Jan_2007). I can create queries on these table to
create say base, previous, current tables, then do other items to these.

Now when March rolls around, I will want to move up the months to Dec_2006,
Jan_2007, Feb_2007, and repeat the process.

When I create the first query they will have the first three month of Nov,
Dec and Jan, but when I move to the next month, I will be using Dec, Jan and
Feb. I will have to write many queries because I have over 24 different area
to work with.

I want to be able prompted for the months to create the queries. This way I
don't have to change over 24 queries each month.

Thanks for helping me on this.
Terry

 

[Douglas J. Steele]

You're probably not going to want to hear this, but your database isn't
designed properly.

You should never store information as the name of a table or field, and
that's what you're doing.

You should have 1 table, with all the data in it, and an additional field
for the Date information. In that way, you simply put a WHERE clause to
extract the appropriate entries.