M
Mark
Hello all,
How can I display the results of SQL in VB. Here is the SQL and it will
have multiple records.
vSql = "select count(*), area_id from wcs_to_via_t " & _
"where trans_stt = '00' " & _
"and dtimecre Between #" & vSDate & "# and #" & vEDate & "#" & _
"group by area_id " & _
"Order by area_id, count(*)"
DoCmd.RunSQL (vSql)
How can I display the results of SQL in VB. Here is the SQL and it will
have multiple records.
vSql = "select count(*), area_id from wcs_to_via_t " & _
"where trans_stt = '00' " & _
"and dtimecre Between #" & vSDate & "# and #" & vEDate & "#" & _
"group by area_id " & _
"Order by area_id, count(*)"
DoCmd.RunSQL (vSql)