none
Access 2013 Null Value Query Help RRS feed

  • Question

  • I have a table with a Channel, Product, Subfamily, Country and Value which I need to update the Value with 0,40,0 but my update table has NULL values for the SubFamily as you can see below with only one SubFamily (Food) with a update value of 0...My question is how can I update my main table with the Various subfamilies if my update table SumFamily shows NULL but has a Channel and Product_Family....Please Assist...Thanks in Advance....


    CHANNEL PRODUCT_FAMILY PRODUCT_SUBFAMILY COUNTRY VALUE
    Price Steve US 0
    Market Steve US 40
    Market Steve Food US 0

    Main Table To Update With Values From Above
    CHANNEL PRODUCT_FAMILY PRODUCT_SUBFAMILY COUNTRY VALUE
    Price Steve Vender
    Price Steve Agency
    Price Steve Govt
    Market Steve Microsoft
    Market Steve Google
    Market Steve Apple
    Market Steve Food

    

    Friday, March 24, 2017 8:30 PM

All replies

  • Hi,

    If the subfamily is null, how do you decide which value to use to update the table? For example, can you enter the values you want the table updated in the sample list you posted above? It might give us the logic or rules to help figure out how to perform the update.

    Just my 2 cents...

    Friday, March 24, 2017 8:35 PM