Skip to content
Advertisement

Why am I getting “Enter Parameter Value” when running my MS Access query?

I’m about selecting all employees who come New York but whenever I run the query, I always get a “Enter Parameter Value” box. How can I fix this?

Advertisement

Answer

This is because Access does not allow you to use field aliases in the query – it does not recognize [City Name] as a valid field name. Aliases are only used as field names in the result set. Rather, you need to use the entire expression.

As such, this query would probably be more easily defined in Access as:

Also, ‘Name’ is a reserved word – using it as a field name is not suggested.

User contributions licensed under: CC BY-SA
7 People found this is helpful
Advertisement