Unwanted parameter prompts in select queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have set up a simple select query in Access 2003, but when I open it a
number of prompts appear for parameters. Can anyone explain why these are
appearing and how I stop them?

Thanks.
 
I have set up a simple select query in Access 2003, but when I open it a
number of prompts appear for parameters. Can anyone explain why these are
appearing and how I stop them?

Thanks.
Click to expand...

They are probably misspelled field names, or field names from some
table not included in the query. Anything in [brackets] which Access
doesn't recognize as a fieldname in the selected table (in the FROM
clause of the SQL) will generate a prompt. One common way to get this
is to assume that a field named [Last Name] is the same as a field
named [Last_Name] - blanks are not underscores, and these names *are*
different!

If this doesn't help - please open the Query in SQL view and post it
here, and indicate what parameter prompts you're getting.

John W. Vinson[MVP]
 
Back
Top