In desktop databases and Access web apps

  1. With the query in Design view, click Parameters (Design tab),

  2. Delete the parameter, click OK.

  3. Delete the parameter from the Criteria row.

  4. 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.

See also

Precisa de mais ajuda?

Expand your skills

EXPLORE TRAINING >

Get new features first

JOIN MICROSOFT INSIDERS >

As informações foram úteis?

O que afetou a sua experiência?

Obrigado pelo seu feedback!

×