Results 1 to 7 of 7

Thread: Query criteria

  1. #1
    Join Date
    May 2012
    Posts
    33

    Unanswered: Query criteria

    Hi.

    I try to make a query witch sort out only what I specify in a text box in a form.

    I like it to use anything containing whats in the text box, hence not exactly. So I tried this:
    [Forms]![New Issue Input Form]![Like "*"&Text174&"*"]

    Like "*"&Text174&"*"] this is not working, I dont get any errors however..

    It dont work. Any tip?

    Thanks!

  2. #2
    Join Date
    Apr 2005
    Location
    Zagreb - Croatia
    Posts
    372
    Try this:
    Like "*" & [Forms]![formName]![fieldName] & "*"

  3. #3
    Join Date
    May 2012
    Posts
    33
    Awesome, thanks!

  4. #4
    Join Date
    May 2012
    Posts
    33
    Any tip if I want to use between dates with two text boxes? Tried a few things without luck

  5. #5
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    between lowerdate and higherdate
    or
    betrween #2012/01/15# and #2012/04/30#
    I'd rather be riding on the Tiger 800 or the Norton

  6. #6
    Join Date
    May 2012
    Posts
    33
    I tried this one and it works

    Between [Forms]![New Issue Input Form]![Text181] And [Forms]![New Issue Input Form]![Text183]

  7. #7
    Join Date
    Apr 2012
    Posts
    14
    How do you query data from 6:00 PM to 6:00 AM daily? What I meant is How to put it in parameter query to include date and time
    Last edited by mdjet; 06-04-12 at 16:33.

Posting Permissions

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