N
NHAnimator
I have two tables: Table1 contains the fields "CaseDigits" and
"OldNotes". Table2 contains the fields "CaseDigits" and "NewNotes". In
Table2, CaseDigits is unique, but there may be numerous matching
records (on the CaseDigits field) in Table1.
I want to eventually eliminate Table1 by appending the OldNotes in
each record to the matching NewNotes field in Table2 (which may
already contain data).
Essentially, I want the following...
[Table2].[NewNotes]=[Table2].[NewNotes]&" "&[Table1].[OldNotes]
So if Table2.CaseDigits=111 and NewNotes="ABC"
and 2 matching records in are Table1.CaseDigits=111 and OldNotes="DEF"
and Table1.CaseDigits=111 and OldNotes="GHI",
then the final result should be
Table2.CaseDigits=111 and Table2.NewNotes="ABC DEF GHI"
This seems like a simple update query, but alas, I have no clue.
Suggestions?
Thanks very much in advance,
John
"OldNotes". Table2 contains the fields "CaseDigits" and "NewNotes". In
Table2, CaseDigits is unique, but there may be numerous matching
records (on the CaseDigits field) in Table1.
I want to eventually eliminate Table1 by appending the OldNotes in
each record to the matching NewNotes field in Table2 (which may
already contain data).
Essentially, I want the following...
[Table2].[NewNotes]=[Table2].[NewNotes]&" "&[Table1].[OldNotes]
So if Table2.CaseDigits=111 and NewNotes="ABC"
and 2 matching records in are Table1.CaseDigits=111 and OldNotes="DEF"
and Table1.CaseDigits=111 and OldNotes="GHI",
then the final result should be
Table2.CaseDigits=111 and Table2.NewNotes="ABC DEF GHI"
This seems like a simple update query, but alas, I have no clue.
Suggestions?
Thanks very much in advance,
John