CODEWITHSUNDEEP
sqlms-access
user1523129
user1523129

Reputation: 11

Access Query Alias asks for parameter value

SELECT r1.* FROM QueryName  AS r1

Throws a box asking to give a value for a column [Date] in a table that doesn't exist. Clicking OK run the query, Cancel doesn't do anything.

SELECT r1.* FROM QueryName  r1

Fine. No problem

Any idea why?

Upvotes: 1

Views: 1595

Answers (3)

HVMP
HVMP

Reputation: 72

I was getting this Parameter issue just a little while ago. My error, though, was a mispelled column name. Check spelling again, just to be sure.

Upvotes: 0

Fionnuala
Fionnuala

Reputation: 91326

I suspect that the query has been previously sorted or filtered by a column that no longer exists. Open the query in design view in the query design window and check the properties.

Query property sheet

Upvotes: 1

Madhivanan
Madhivanan

Reputation: 13700

Some RDBMSs do not need keyword AS for table alias but happy with column alias. In ORACLE and ACCESS keyword AS is not needed for table alias

Upvotes: 0

Related Questions