Microsoft Access - Updating Null fields with visible values

Can you post your current SQL, maybe table structures?

The SQL code I currently designed looks like this:

DoCmd.RunSQL "UPDATE test INNER JOIN test2 ON (test.group = test2.group) SET test2.phone = test.phone WHERE test2.phone Is Null 

I don't think the issue is with your update query, but with your reporting query.  Can you post the query you are using for your sample, along with table structure?

This DLookup code updates the results I'm looking for in an Access query:

Phone_Update: IIf(IsNull([test]),DLookUp("Phone ","Test"," Group='" & [Group] & "' AND phone "),"")

OK, now I'm even more confused. Why do you have a table with the same entries replicated four times?  Wouldn't it be better to have a table with the correct entries, then join it to a transaction table when needed?

You could use a query that links the table back to itself, checking for nulls and not nulls:

UPDATE Table1 INNER JOIN Table1 AS Table1_1 ON Table1.Group = Table1_1.Group SET Table1_1.Phone = [table1]![Phone]
WHERE (((Table1_1.Phone) Is Null) AND (Not (Table1.Phone) Is Null));

I apologize for the confusion above. The code you wrote extracts the value I'm looking for but only when the values are in the first row of the group. Since the values can display in random order of the group, I need a dlookup type function that will search the whole group and paste the value where the record is blank.   Thanks

The query I posted will update the null phone numbers with a non-null number from a matching group ID, not necessarily the first record in the table or the first record for a specific group.

Try pasting the SQL into the SQL view of a query and see if it works.

Wally Eye, I thank you very much for your awesome help and your patience. It works like a charm. 

You're most welcome, glad to be of assistance.