G
Guest
I am trying to create an Update Query. I have the following tables:
Table1
Accts Item ID
Acct1 01
Acct2 04
Acct3 01
Acct4 03
Table2
ID Name Items
B23 Pam 01,05,09
B35 Amy 02,06,10
A72 Frank 03,07,11
Z53 Dan 04,08,12
I want to update [Table1]![ID] with the [Table2]![ID] where the
[Table1]![Item] is in the string [Table2]![Items]. Both fields are text
fields so there should not be any data-type problems but I just don’t know
what to do next!
Table1
Accts Item ID
Acct1 01
Acct2 04
Acct3 01
Acct4 03
Table2
ID Name Items
B23 Pam 01,05,09
B35 Amy 02,06,10
A72 Frank 03,07,11
Z53 Dan 04,08,12
I want to update [Table1]![ID] with the [Table2]![ID] where the
[Table1]![Item] is in the string [Table2]![Items]. Both fields are text
fields so there should not be any data-type problems but I just don’t know
what to do next!