Counting records

[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

 

[Douglas J. Steele]

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