Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Searching values in several fields

There are situations when i need to find records with certain values in more than one field.
I'm using ADO and when i want to find a value in just a single field, i use the Recordset.Seek and the Recordset.Find methods, the problem is that i cant use this methods to search throw several fields
Is there any way to perform a search in a recordset, in multiple fields for more than one value?

Comments

  • chamlingchamling Member Posts: 35
    : There are situations when i need to find records with certain values in more than one field.
    : I'm using ADO and when i want to find a value in just a single field, i use the Recordset.Seek and the Recordset.Find methods, the problem is that i cant use this methods to search throw several fields
    : Is there any way to perform a search in a recordset, in multiple fields for more than one value?
    :

    Hi there.

    If you know, and wish, you can use SQL statements to extract records supplying the field values as where criteria.
Sign In or Register to comment.