Im trying to make a nested FOR structure in a macro so I can match possible values against excluded values of the field "TestResult", the problem is that I make a selection in "year" and "course" fields and then run the macro ; possible values are working fine but the excluded values are takin every course along the entire years list and I only need the excluded values considering only the year.
So the question is: Is there any way to use "GetExcludedValues" considering certain fields only?
I was also trying to make this via variables but they didnt work in the for structure:
for ind1 = 1 to var1 // value of variable "var1" = count (total<year> {$<year=>} teacher)-CountPossible <----Not working either
