What is wrong with this Query

[shyamsundar]

Hi all,

I am trying to run this query and pass the value into variable and print it in the report.

docmd.runsql "Select count(*) as dcnt from table1"

and I am getting the error "A RunSql action requires an argument consisting of an SQL Statement"


Please Help



Shyam
cwizshyam@yahoo.com

 

[danvlas]

DoCmd.RunSQL is used to run an action query (append, delete, update)
Your SQL is a Select query...

You have to open a recordset based on your select statement, get the value from the field into a variable, close the recordset and do whatever you want.


Set rst = CurrentDb.OpenRecordset("Select count(*) as dcnt from table1&quot
varValue = rst.Fields("dcnt&quot
rst.Close
Set rst = Nothing

'do whatever you want with varValue

Good luck




Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[shyamsundar]

Dear Daniel Thanx

brilliant
Shyam
cwizshyam@yahoo.com