Update table referred to in a query

[ed1967]

Hi

I'm sure this is something fairly straightforward, but I'm having trouble working out how to do it as I'm not really an Access expert by any means; any thoughts would be much appreciated.

Every month, I need to run a report which links to a specific table - the name of the table changes every month (say from "data 2010-05" to "data 2010-06" [so all that's changing is the date]). I know how to amend the table that's referred to in the query through various manual methods, but is there any way that I can create a form which asks the user which table he wants the data to come from?

Hope that makes sense!

Thanks for any ideas

Ed

 

[DCrake]

Why are you changing the name of the table. What's going to happen in years to come? what you need is a query that filter out the dates from the main table.

 

[ed1967]

Sorry, I didn't make that clear - we receive a new set of data from a client every month and need to keep each of the tables as a reference. The tables are kept separately and each month the report refers to the latest set of data.

 

[DCrake]

How is the data being introduced to your mdb?