Counting records

  • Thread starter Thread starter Jeff
  • Start date Start date
J

Jeff

I havea query where I am counting records in a table and I want
to perform an operation on the table if this value is greater than 1...

In my query, CountRecs_qry, my SPL looks like this:

SELECT Count(*) AS Expr1
FROM TEMP_tbl;

What sort of command do I need to put in my event procedure to check if the
value of Expr1 > 0?

Thanks
 
You'd probably be better off using DCount:

If DCount("*", "TEMP_tbl") > 0 Then
' It's greater than zero...
Else
' It's equal to zero
End If
 
Back
Top