Access database files, two tables, table 1: the Info, table 2: RoomInfo, two tables are field Barcode,
How to according to the Barcode, the table 1: field, Type, content, Copy to the table 2: field Type;

CodePudding user response:

Use the insert into table 2... The select... From table 1...

CodePudding user response:

It's about using
"The UPDATE table 2 SET type=" & amp; Rs! The type & amp; "' the WHERE Barcode='" & amp; Rs! Barcode & amp; "'"