User Input value to use as criteria for multiple fields

[hfreedman1957]

Hi,


When I run a particular query, I want the user to be prompted for a value, and then use that value as criteria in multiple fields in the query. I tried declaring a global temporary variable, then added that tempvar as a field in the query prompting the user for input in the criteria. I then used that temporary variable as criteria for the other fields. Running this query displayed no results. Please help.

[hfreedman1957]

I just figured out a solution. I create a macro that first set the temporary variable via ImputBox and then ran the query (without inputting the tmpvar). It works fine. Is there a more efficient way to do this all inside the query without using a macro? Thanks!