>Hi Eric,
> I am developing a project in VB for Excise purpose in that our some
>calculations will be base on data entered by user into grid(temp
>cursor) for that purpose I want to use select clause on recordset.
>If there is any another method for selecting particular col. from
>recordset then pls. tell me.

You can't query a recordset.

To do some calculation in the grid, you can use somtehing like this:

Private Sub grdResult_AfterColEdit(Index As Integer, ByVal ColIndex As Integer)
With grdResult
.Columns(ColIndex + 2) = (Replace(.Columns(ColIndex), "%", "") - _
Replace(.Columns(ColIndex + 1), "%", "") _
) * 10000
End With
End Sub

> Also tell me how should i use find method for finding particular
>record with more than one field i.e. can I use find like this
>rs.find "field ='" & value &"' and field ='" & value "'" because
>in this it fire me an error

ADO can't have more than one criteria passed to the Find method. You can combine it to the filter method (which can accept more than one criteria).

> Also is there any method in VB like Replicate() function what we
>have in FoxPro for replicating the character pass to it.

Look at the String function which the syntax is:
String(number, character)