In desktop databases and Access Apps
- With the query in Design view, click Parameters (Design tab),
- Delete the parameter, click OK.
- Delete the parameter from the Criteria row.
- Save and run the query.
Note You may not find parameters in the Query Parameters dialog (steps 1-2), but check to be sure. For an Access App, you’ll probably want to delete the associated views and macro, too.
In a Union query
Delete the clauses after each FROM statement: WHERE [field name] = [your parameter]. Delete both clauses or Access will display a dialog.
In an expression
Look for and fix any typos in field names (the most common problem). If they aren’t the problem, follow the links to articles about expressions.