How to ask for what field name to use in query.

[PDS]

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!

[Micron]

Var1: Sum(iif([Input Field Number]=1,1,0))
You could try a parameter prompt as a simple solution. If they enter nothing and click you will likely get no results. If the field names have spaces they'll have use brackets around the field name. There are clues that you have a table design problem but I will leave it at that.

[Welshgasman]

Sounds like not normalized at all?
Are you an Excel person at all?

I would use a combo for a field list for the table and work from that.

Hopefully the user would know what on earth F56 is for?

Perhaps give then a more descriptive name as to what they are meant to be choosing?