record count issue

[iccsi]

I use recordcount to check my DAO.recordset is empty or not.
The recordcount returns 1 when the resordset is empty.

Are there any work around for this?

Your help is great appreciated,

 

[Dirk Goldgar]

I use recordcount to check my DAO.recordset is empty or not.
The recordcount returns 1 when the resordset is empty.

Are there any work around for this?

I've never heard of such a thing, and doubt your results. Please post your
code.

 

[iccsi]

I've never heard of such a thing, and doubt your results.  Please post your
code.

--
Dirk Goldgar, MS Access MVP
Access tips:www.datagnostics.com/tips.html

(please reply to the newsgroup)

Thanks for the message,
Yes, there is a bug in the query.
Thanks again,