Help with a count..

[mgonzalez]

Hello

I hope that someone coul help me... I am trying to do a simple count of registers from a access database like this

sql = " select count(1) as con_reg from tab_mx "
set rstmx = bd_tmx.execute(sql)

I did the query in the database and worked but when I try to do in the code always sent me 0 records I did it in another form,whith another table and nothing.The others querys(not count) worked perfectly...Please someone could tell what could be the problem????

Thanks

 

[jebry]

Hi!

I think that, instead of .Execute, you need to use .OpenRecordset. I have never been able to get the Execute method to function the way you are trying to.

hth
Jeff Bridgham