Hi there,
Please see the tables below....
Master
Organisation (No Duplicates) Office 1 a 2 3 4 a 5
Update
Organisation Office 1 a 1 b 1 c 2 a 3 a 3 b 4 a 5 a 5 b
I want to write an UPDATE query to update the 'Master' table's 'Office' column with an office from the 'Update' table where:
- Master!Office = blank
- Count(Update!Organisation)=1
This is what the result should look like:
Master Result
Organisation (No Duplicates) Office 1 a 2 a 3 4 a 5
Please advise!