Unanswered: Querying according to user specified field
Is it possible to have a query whereby a front-end user is asked to input a field which the query will use to search by? I am trying to use [text] in the field cell in the Query design but it is changed to Expr1: [text]. While the user is asked to enter a reponse, the query does not search according to the input.
What the OP is asking for can be achieved through dynamic SQL, which is rarely the best idea. How's about you create a new query for each field your users might want to filter on - and then let your users pick which query they wish to run?