Update query problem

  • Thread starter Thread starter WWV
  • Start date Start date
W

WWV

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
 
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
Click to expand...

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?
 
Back
Top