Hi All,
on a "Run Report" button of a form,i have the following code:
Dim strsql
strSQL = "SELECT sum(shutdowns) FROM System1"
when i debug and try to read the "strSQL" value,it always shows strSQL holding the string "SELECT sum(shutdowns) FROM System1" instead of the sum.
could anyone please point as to what I am doing wrong?
Thanks
on a "Run Report" button of a form,i have the following code:
Dim strsql
strSQL = "SELECT sum(shutdowns) FROM System1"
when i debug and try to read the "strSQL" value,it always shows strSQL holding the string "SELECT sum(shutdowns) FROM System1" instead of the sum.
could anyone please point as to what I am doing wrong?
Thanks