Too few parameter Expected 1

[rajiveisthename]

I am using a vb6 and the query that i am using is this

SELECT Count(txt_LNOSCLT.[customer_no]) AS kount, '123' AS amounts
FROM txt_LNOSCLT;

Is there any wrong with the query. This is an old MSAccess97.
Please help. Thanks

[Phill.W]

"Parameter count" errors are frequently caused by spelling mistakes.

Either something in the query is spelled incorrectly or something in the Access database (column name, perhaps?) has changed since this code was written.

Regards, Phill W.

[SamOscarBrown]

I don't know if there is anything 'wrong' with it. When you execute that statement, what do you get? An error? An unexpected result? Do you meant 'old MSAccess97' because it is a 97 version vice a 2016 version, or was the query written a long time ago and it once worked?

[SamOscarBrown]

This looks suspicious: '123'

[SamOscarBrown]

Just do the latter part of your query, "SELECT '123' AS amounts FROM txt_LNOSCLT;" what happens?
Is 123 a field name?

[ColinE66]

Just do the latter part of your query, "SELECT '123' AS amounts FROM txt_LNOSCLT;" what happens?
Is 123 a field name?

That's perfectly valid SQL (though I can't imagine why it's needed in this case). It's just a literal string that is being selected and aliased as 'Amounts'.

[gibra]

What type of object is: txt_LNOSCLT ? A table of database?