I have two table in Microsoft Access They are named as "master" and "O3". I want to align "ozone" data in the "O3" table by synchronizing the "Corrected_Time" column between "master" and "O3" tables. I confirm that all the times in the "Corrected_Time" column of "O3" table are also present in the column of "Corrected_Time" of master table. The format of time is long (hh:mm:ss). Note there different number of rows in the two tables.
I have designed a query in the following way.
1. Connected "Corrected_Time" column of the two tables.
2.
Field: Ozone
Table: master
Update To: [O3]![ozone]
When run the query, only 5279 data points are arranged. But there are 8623 data points in the "ozone" column of "O3" table. Please help me to find my error. Thank you so much.
Best regards,
Kundu