I have limited experience with creating functions in access, but I was asked to create a function for this.
I have two tables that are connected in access The tables are lists of products and their corresponding product number as well as other information. Most of the products in the table have a corresponding company-specific product number but there are a few that don't for those I was asked to create an IF function that will pull the national product number from the connected table for each product that doesn't a company product number already listed.
I have only been able to create a function that leaves those without a product number blank, but I need to figure out how to populate those blank fields with those national product numbers.
I'm not sure how to move forward and would really appreciate some tips.
I have two tables that are connected in access The tables are lists of products and their corresponding product number as well as other information. Most of the products in the table have a corresponding company-specific product number but there are a few that don't for those I was asked to create an IF function that will pull the national product number from the connected table for each product that doesn't a company product number already listed.
I have only been able to create a function that leaves those without a product number blank, but I need to figure out how to populate those blank fields with those national product numbers.
I'm not sure how to move forward and would really appreciate some tips.