Hello,

I have a table with 4 fields. I want to insert value into one of the fields, based on If condition of other fields...

Company1, Company2, Company3, NoOfCompanies
xxx,,,
xxx,xxx,,
xxx,xxx,xxx,

I would like to count how many companies (total number of companies) in each row.

So, if Company1 is not empty, and Company2 & Company3 is empty, then I would like...