Search Within Results

Results 1 to 3 of 3

Thread: Search Within Results

  1. #1
    Join Date
    Dec 1969

    Default Search Within Results

    I am building ASP with Access. I have included a search function for my site. How can I do a search within result of my current recordset.<BR>Let&#039;s say I search for students that are active, then how do I further search on students that are from USA and are active.

  2. #2
    Join Date
    Dec 1969

    Default I have kindof the same problem.

    Its somewhat similar, how do i search for multiple things<BR>at once. Like searhing for gender, age, city, activity and<BR>things like that, returning ppl who match "the most".<BR><BR>/Thomas

  3. #3
    Eddie Campbell Guest

    Default RE: Search Within Results

    Ideally you just do this:<BR>"Select StrStudentName from TblStudents Where Active = True AND Coutry = &#039;USA&#039;"<BR><BR>But if you really want to do it with 2 queries, you could try using rs.filter<BR><BR>1) Build a rs of all active students<BR>2) rs.Filter = "Country=&#039;USA&#039;"

Posting Permissions

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