I have a dataset with the following data:
I've started a master loop where I loop through the accounts.
I now need to do a sub loop and compare this account to the rest of the accounts in the dataset and to check whether the item_codes match or not.
If account_number_master_loop = account_number_sub_loop Then If item_code_master_loop = item_code_sub_loop Then 'Not sure what type of variable this should be variable = account_number_sub_loop,item_code_sub_loop,score Else variable = account_number_sub_loop,item_code_sub_loop,0 End If End If
What would be the best way to achieve this?