Updating blank fields for existing records

[NoDatabaseGuru]

Good day all!!

I am in the process of building Append Queries for new records, and I know I can do an Update Query to enter specific information. However, how can I update multiple records from a (externally sourced) linked table to fill in blanks of an existing table? I have created a query to identify records with 1 or more matching criteria which contain the blank fields. I now want to update those blank fields. The data in each blank field is different for each record (same type, just different data). Note: I do not know SQL, so I'm relying on Access to help me build the Macros with very basic knowledge.....

 

[NoDatabaseGuru]

I see a lot of people visiting, but no replies. Will it help with some additional information?

Main Table of Purchase Orders with specific reference information


Primary Table - Information generated internally when PO is created:

PO Sales # Invoice # Qty Rcvd Ship Date Rcv Date PO Date
12345 a122 bill1234 10/1/2014
23456 b6452 bill6542 10/3/2014
34567 10/6/2014
45678 10/8/2014




External Report

PO SO # Ship Date Inv # Rcvd Date Qty Rcvd
12345 a122 10/10/2014 bill1234 0/12/2014 16
23456 b6542 10/9/2014 bill6542
34567 c3222
45678 d1566


I alter the unmatched query to search existing PO's. I used that query to 'Make a Table', which I then use to create my update query.

I'm using the 'Update To' of of the created table. [Internal Report].[Fieldname]. How do I get the second step to update blank fields in the Internal Table based on external data for each separate PO number?


This is almost my last step, and I could really use some guidance.

THANK YOU, in advance!!