CODEWITHSUNDEEP
sqlms-accessselectsubquery
Teiv
Teiv

Reputation: 2635

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

SELECT ID, 
       Name, 
       (SELECT CityName 
        FROM City 
        WHERE Employee.CityID = City.CityID) AS [City Name] 
FROM Employee 
WHERE [City Name] = "New York"

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?

Upvotes: 10

Views: 40704

Answers (5)

Abdullah Rasoul
Abdullah Rasoul

Reputation: 1

Just found out regarding this error: "One of your parameter is invalid".

To fix this, I had to change my data type for customer ID from Large number to number as it does contain a few numbers only. This fixed my issue.

Upvotes: -1

Hasan Shouman
Hasan Shouman

Reputation: 2362

Check that you have not added a query to the "Default Value" field.

Upvotes: 0

Jacob Church
Jacob Church

Reputation: 176

Another thing to check is on the Home tab if you have any manual sorts or filters active on the query results. There is a button on that tab to remove sorting that you wont find on the dropdown menu for the field.

Upvotes: 0

Remi Despres-Smyth
Remi Despres-Smyth

Reputation: 4253

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:

SELECT ID, 
       Name, 
       CityName AS [City Name]
FROM Employee INNER JOIN City
    ON Employee.CityID=City.CityID
WHERE CityName = "New York"

Also, 'Name' is a reserved word - using it as a field name is not suggested.

Upvotes: 9

Mohamad Alhamoud
Mohamad Alhamoud

Reputation: 4929

try single quotes instead of double quotes.

Upvotes: -1

Related Questions