SQL Problem

Results 1 to 3 of 3

Thread: SQL Problem

  1. #1
    Join Date
    Dec 1969

    Default SQL Problem

    I need to "Find" a record and still have all<BR>the other record present in the recordset.<BR><BR>Select * From [myTable] Where [myField] = &#039;Me&#039;<BR><BR>Will return only one record (if me is unique)<BR>But I need to find the record (make it current)<BR>yet still have all the other records there.<BR><BR>Can any one help?<BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: SQL Problem

    Research the Filter() Method of the Recordset Object.

  3. #3
    Join Date
    Dec 1969

    Default What are you trying to..

    .. accomplish?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts