Update query problem

I have a table (table 1) with many date ranges in them for grouping by age
ie start, end dates for group 1, start end dates for group 2 etc. I have
another table that has these start, end dates for each group in each of many
records. (this is how i inherited it) I need to update the start, end dates
in each record of table 2 from the entries in table 1. The dates in table 1
can change and need to updated in table 2. I tried an update query but do
not have a field I can join on.
Any ideas?
WWV

On Mon, 31 May 2004 23:08:43 -0400, "WWV" wrote:

I have a table (table 1) with many date ranges in them for grouping by age
ie start, end dates for group 1, start end dates for group 2 etc. I have
another table that has these start, end dates for each group in each of many
records. (this is how i inherited it) I need to update the start, end dates
in each record of table 2 from the entries in table 1. The dates in table 1
can change and need to updated in table 2. I tried an update query but do
not have a field I can join on.
Any ideas?
WWV


If there is no field that you can join on, I cannot imagine any way
that Access - or any program, or any human being - could correctly
identify which record in Table2 should be updated to which date in
Table1. If you had the two tables printed out, would you be able to
look at a Table2 record and determine which Table1 record was
appropriate? If so, how?

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public