Recordcount always show 1....

[Learnerprog]

Hello all,
I don't know why my recordcount always show 1 even though there are more than one records return.. please help..

Thanks, JM

 

[glalsop]

Are you refering to a recordset? Try:

rs.MoveLast: rs.MoveFirst

before you use the count.

-Gary

 

[Elysium]

Depending on your SQL, a record count of one may indeed be the right answer. For example, the sql of:

SELECT COUNT(US_State) as Total_States FROM STATES

Will show a record count of 1. However, we all know that the US has 50 states. You will only see the number 50 if you reference the value of the recordset field.

Give that a try.

Regards,



Randy

 

[Learnerprog]

glalsop,
it works... thank you much.