ms access parameter query - HELP

[wigs]

my query in access asks for a parameter value when I go to run it. But there are no and should not be any parameters as far as thee eye can see. anyone know what I'm doing wrong.

[doctorgonzo]

In the query design view, right-click on the area where you can display tables. Click on "Parameters," and make sure there are none listed. If there aren't any and you still have the problem, check the spelling of your fields in the query.

If this happens when you open a form or report based on the query, make sure that the form or report isn't sorting or grouping on any fields not included in the query.

[sdkfz]

as an addendum to the dr, when the parameter comes up it gives you the field that it is treating as a parameter so if it comes up say "mailng address" and the actual field in the underlying table is "mailing address" you could easily miss the missing "I" in 'mailng' with a quick read.

you also may have deleted/re named the field in the table that the query is reading from in which case either stop using the field in the query or undo the delete in the table.