Results 1 to 3 of 3

Thread: sEARCH

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: sEARCH

    Hi all I have a search query in access on one of my database's that when you click on the command button it window comes up that ask you for the last name. What I would like to do is alter it so that users can type in SM and get all the names that start with SM or Ma?? Like a Starts with. How can I do that


    how would I do that in access [organization] an edit parameter comes up and then enter in the value, how do I get it to where if they enter in the start of the name like A they get everything that starts with A?? With an MDB

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    In query criteria put:

    Like [Enter last name] & "*"

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Talking Thank you

    Thank you Mstef-g that did the trick

Posting Permissions

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