>Hi All:
> Is there a way using RecordSet where I can add the value of a field depending on my requirement. Like Count for cnt where cnt = 1.

You can use the Filter property of a RecordSet in this case. Assuming that oRs is an existing ADO RecordSet.

oRs.Filter = "cnt = 1"
lnCount = oRs.RecordCount