Results 1 to 5 of 5
  1. #1
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Filter by Form, Multiple Criterior (2003)

    It's been awhile but I am trying to use filter by form for a date search. When I enter =>"9/1/07" & =<"9/30/07" in a date field I get an invalid error message. In the past, I thought I used to see an "And" tab that would solved this problem but I only see an "Or" tab. So, I'm stuck. What am I doing wrong?
    You know it's time to diet when you push away from the table and the table moves.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter by Form, Multiple Criterior (2003)

    Try

    Between #9/1/07# And #9/30/07#

  3. #3
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Filter by Form, Multiple Criterior (2003)

    Hans, that got me started in the right direction. Filter by Form does not like the # characters but it will accept the double quote characters instead and it worked. I appreciate your help.
    You know it's time to diet when you push away from the table and the table moves.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Filter by Form, Multiple Criterior (2003)

    That Access didn't like the # characters indicates that the field is a text field instead of a date/time field as I had assumed. It is dangerous to use a text field to store dates - comparisons will be alphabetic instead of temporal.

  5. #5
    3 Star Lounger Omega3's Avatar
    Join Date
    Jan 2004
    Location
    Los Angeles, California, USA
    Posts
    343
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Filter by Form, Multiple Criterior (2003)

    Hans, you are right. When I imported it from Excel the column was type General and it looks like it converted to a text data type in Access. I need to change it to a date data type. Thanks!
    You know it's time to diet when you push away from the table and the table moves.

Posting Permissions

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