Update Query Help????

[Mac1206]

If Product_SubFamily is blank in my update table(Middle Table), how can I write the query to update the Channel_Value for main Tbl based on the fields available but also include MR TOM who has a value assigned.

Strat_Price Sample MainTbl to Update
Product_Family	Product_SubFamily	Country	Currency	Channel_Code	Channel_Value
BAR	MR JEAN	US	USD	Store
BAR	MR BILL	CA	USD	Markets
BAR	MR SMITH	US	USD	Markets
BAR	MR JEAN	CA	USD
BAR	MR JONES	US	USD
BAR	MR JONES	US	USD	Markets
BAR	MR TOM	US	USD	Markets

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

Channel_Value Sample Update Tbl (This table need to update main Channel Values Tbl above)
Product_Family	Product_SubFamily	Country	Currency	Channel_Code	Channel_Value
BAR		US	USD	Store	0
BAR		US	USD	Markets	40
BAR	MR TOM	US	USD	Markets	0

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

My Results needed from the Update Tbl
Product_Family	Product_SubFamily	Country	Currency	Channel_Code	Channel_Value
BAR	MR JEAN	US	USD	Store	0
BAR	MR BILL	CA	USD	Markets
BAR	MR SMITH	US	USD	Markets	40
BAR	MR JEAN	CA	USD
BAR	MR JONES	US	USD	Store	0
BAR	MR JONES	US	USD	Store	0
BAR	MR JOHNSON	US	USD	Store	0
BAR	MR TOM	US	USD	Store	0

<colgroup><col><col><col span="2"><col><col></colgroup><tbody>
</tbody>

 

[Joe4]

Duplicate: https://www.mrexcel.com/forum/microsoft-access/997858-help-query-update-access-2013-a.html

Since this is continuation of the thread we were working on, let's please keep it in one thread. All clarifications, directly related follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

I had replied with some questions in that other thread that you never replied to.