Populate field with date msg box

[cooneyge]

Hi there,

I have an DB with many data tables. The data tables have the same characteristics, being Field Names and Data Types. They do however have different amounts of rows of data in them.

The output is required to have a field with every row in each table to be the previous month end date.

I would like to have a message box pop up where I can enter the date (this is the easiest solution I can think of) and this populates every table in in the data base.

Currently, I have an Update Query for table X, which has the Update To: [Enter Month End Date in format dd/mm/yyyy:]. This works fine for this one table but i am not sure how to replicate this across the remaining tables.

Is it possible to have an update query that will update all of the tables I request knowing each table has a different number of rows?



Thanks,
George

[ranman256]

Your update is possible, but, what is the nature of these other tables?
say 1 table is tClientHist. And you update dates in the history. I don't see what other table needs updating this way.
ALL client history is in 1 single table, not spread across many.
please explain.

[rpeare]

If all your tables are identical, why are you storing them as separate tables? Iterating through tables to update them is much more complex than if all the data is in a single table where you can likely perform the update you want with a single query.

[cooneyge]

If all your tables are identical, why are you storing them as separate tables? Iterating through tables to update them is much more complex than if all the data is in a single table where you can likely perform the update you want with a single query.

Thanks guys,
I am going the combined table option. Thanks for your help. This works now.