DB search question

Results 1 to 2 of 2

Thread: DB search question

  1. #1
    Join Date
    Dec 1969

    Default DB search question

    I have set up a form for users to enter first name and last name, hit search, and then I do a select from DB where the criteria is met, and display the record associated with the name (Essentially...an online phone book). I am using Access DB, and my question is...<BR><BR>The problem with this is that I have to know how to spell the persons entire first/last name exactly. I am wanting to set up something so that if I am searching for Michael Wallace I only have to put the parts of his name that I am sure of...<BR><BR>For example...I want to be able to put "Mic" and "Wallac" in the first and last name fields, hit search, and display all records that have "Mic" and "Wallac" in the fields.<BR><BR>I think I&#039;ve even confused myself here. If you need further explanation, let me know.<BR><BR>Thanks.

  2. #2
    Join Date
    Dec 1969

    Default RE: DB search question

    sql = "select from yourtable where name like "&#039;& yourform &&#039;"<BR><BR>or somethink like that<BR><BR>just use the "like" statement

Posting Permissions

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