This should be an easy question, and quite frankly im pretty annoyed ive spent the ammount of time i have on this problem.
I have a column on Table 1 that is DIV. Ihere are 5 possible values. (ABUS, ABCA, ABMX, BCUS, and BCCA)
Those 5 values have corresponding columns on Table 2.
On Table 2 my goal is for each of the 5 columns to have an if statement that looks and the table 1 value. If it makes i want the criteria for that column to be "True"
ex for table 2 column ABUS criteria.
My if statement in lamens terms is IIF(Table 1 DIV = "ABUS","True","")
My actual if statement is:
IIf([Dealer_DIVCOUNTRY]![DIV]="ABUS","True","")
I am using the "Group By" option and have tried it with Expression, Whereas "Group By"
Let me know what you guys think.