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