Search results

Hello, yes the semicolons are rigt there. After time I found out that I forger the GROUP BY function. when I put it there, next err.message occured run-time error '2342' an runsql action requires an argument consistin of a sql statement . and when I removed the semicolons, it wrote me something...

OK, I found out that there is missing GROUP BY function and after I put it there it writes me thah runtime error 2342, a runSQL action requires an argument consisting of an SQL statement. so it is bad at all I think

OK, I found out that according to SQL view in query designer is missing a GROUP BY function. after I put it there, it tells me "Run time error '2342' A RunSQL action requires an argument consisting of an SQL statement". Holly pig.

Hey Rob, thnx for ur answer. I know that spaces are important and dont know why there were not some spaces in this message, but in my code there were spaces. To check the whole statement I put there Me.lblStatus.Caption = sSQL and the statement seems to be right. I tried your advice to put the...

I found some hint in here to replace docmd.runsql with docmd.openquery but it still does not work. It makes a errormessage Microsoft Office Access can't find the object ....

I dont know if is it a lookup function, but in sql it would be: select name, sum(points) from students group by name;

Hi guys, I have a problem with OnClick event procedure. I have a button and I want to execute query after clicking that button. Of course. And event I wanna execute is: sSQL = "PARAMETERS [Forms]![frmOne]![cmbProvincia] Text ( 255 );" & _ "TRANSFORM Sum(product!price*sales!qty) AS Expr1" & _...