Results 1 to 3 of 3
  1. #1
    Join Date
    May 2006
    Posts
    28

    Unanswered: Query Parameter to Search Month

    I have a text field for Birthday (I'm not using the date/time datatype because I don't want to save the year with it and just the month and day) and was wondering how to be able to create a parameter in a query for people to be able to search the month. I want it to say "Enter Month" and have them type in the Month and all the corresponding records will be pulled. The field has the format: "Jun 14" or "Aug 06"

    Is this possible and if so, can somebody help me accomplish this? Thanks.

  2. #2
    Join Date
    Apr 2004
    Location
    outside the rim
    Posts
    1,011
    Put
    Like "*" & [Enter the 3 letter abr. for the month:] & "*"
    as the criteria under the "date" field.

  3. #3
    Join Date
    May 2006
    Posts
    28
    Thanks! It worked after I took out the "." after abr.

Posting Permissions

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