Put Records Returned In A Variable

I can get the number of records to be returned but I want to run a condition if the records returned is zero. To do this, I need to put the number returned into a variable but I haven't been find a way.

For instance, this code does work:

SQL = "SELECT Count(*) AS Records FROM Table1 GROUP BY Table1.Quantity HAVING (((Table1.Quantity)=4));"
conDatabase.Execute SQL

But I want to store the count as a variable. What I want is something that look this (it doesn't work but I just want to give an idea what I'm looking for)

SQL = "SELECT Count(*) AS Records FROM Table1 GROUP BY Table1.Quantity HAVING (((Table1.Quantity)=4));"
Dim hold as Integer
hold = conDatabase.Execute SQL

If(hold = 0) Then
'tell them nothing returned
End If



So how can I go about this?

Update: I see that someone posted a solution a few threads down using queries which did work. Can I still still do the same thing with SQL strings?

scratch