im using access 97 and i need to get the reult of a query that is to be run in vb.
ive tried the following but to no avail..
note: & [Mem No] & = field in form
SQL = "SELECT Count([tblHire]![Mem No]) AS Expr1 " & _
"FROM tblHire " & _
"HAVING ((tblHire.[Mem No])='" & [Mem No] & "')"
If (DoCmd.RunSQL(SQL)) > 4 Then
.thnx for your help