Need to consolidate data from 2 queries

[robinzworld]

At work a database has been built for use in QA of installed devices. The Access file is then used on tablets.

The data is brought in from excel and a table is created. From that table only certain columns are used in the Cutsheet Query. A form has been built that is used to pass/fail the devices and the results go to the Report Query. to run the report to sent to our client the QA Report Query is run, then we copy it and paste it into excel.

My problem is I will have 2 separate team out in the field tomorrow collecting data on different devices. I need to find a way to consolidate the Report Query from two files into one of the existing queries. All devices start out with a - in the status (and other fields) so I'm wondering how to run a query to only replace the - if there is data in the same ID number. See screenshot below.

Any help would be greatly apprciated

[June7]

You want to pull into 'master' db data collected by the field teams? Set links to field copies. Then use query builder to start a query that joins tables on the ID fields and switch it to an UPDATE sql to update the QA_Status field. Include filter criteria ="-"

You will have to do two UPDATE actions.