wrong number of arguments

[anonymous]

[Originally posted by Johm]


wrong number of arguments used with query expression run time error 3075

I want to simplify the following sql:

stSQL = " SELECT customers.Customerid, customers.CompanyName,customers.afid ,customers.address, " & _
" customers.employee,customers.city,customers.works,customers.works1,customers.home,customer s.mobi," & _
" customers.taxid,customers.pass,customers.bulstat,customers.kindid,customers.afid

by making something like that:


strSQLÿ = " SELECT customers(Customerid,CompanyName,afid ,address,employee,city,works,works1,home,mobi,taxid,pass,bulstat)

But then i receive the message wrong number of arguments run time error 3075.
May i ask for help?

[anonymous]

[Originally posted by m.posseth]

this should work :-)

strSQLÿ = "SELECT Customerid, CompanyName, afid, address, employee, " & _
"city, works, works1, home, mobi, taxid, pass, bulstat FROM customers;"

complete naming customers.Customerid etc etc ,should alway`s be used when joining tables in a sql query to avoid name conflicts ,,, so you could even state that the previously used way is the better way !! of doing things :-)