My table has 100 fields named F1 to F100. I want to ask the user in a query what field do they want to sum values on due to so many fields.
So in my query I have Var1: Sum(iif([F1]=1,1,0)) Var2: Sum(iif([F1]=2,1,0)).
Rather than using F1, I want to ask the user which of the 100 fields do they want the calculations on.
So it would 1st ask "what field do you want". If they answered F56, the above query would read:
Var1: Sum(iif([F56]=1,1,0)) Var2: Sum(iif([F56]=2,1,0))
Thank you!