Results 1 to 3 of 3

Thread: Query Criteria

  1. #1
    Join Date
    Jul 2004
    Posts
    56

    Unanswered: Query Criteria

    I have a list box on a form that uses a query to populate it. The query selects the returns based upon a text box on a page of the form. I would like to have the query place the wild card search * just prior to and just after the data that it looks for from that text box. So that the critera would look like

    Like Forms![Fm Staff Input]!*[Unique ID Number]*

    This would have the same result of creating a parameter query and having the operator input *00045*.

    Is this possible as the criteria above doesn't work.

    Thanks


    Col_Bol

  2. #2
    Join Date
    Feb 2004
    Location
    CT,USA
    Posts
    250
    Try:
    Like "*" & Forms![Fm Staff Input]![Unique ID Number] & "*"

  3. #3
    Join Date
    Jul 2004
    Posts
    56

    Thank

    Thanks - worked a treat !

Posting Permissions

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