Results 1 to 6 of 6
  1. #1
    MrLuvigz2
    Guest

    Filter problem (Access 2000)

    This filter doesn't return the data within this date range when I try to use it on a report. Any suggestions?

    [Date Issued] > 11/11/01 and [Date Issued] < 11/30/01 and [Supplier ID] = 1

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter problem (Access 2000)

    You need to use date delimiters (#) when there are dates involved. Try this:

    [Date Issued] > #11/11/01# and [Date Issued] < #11/30/01# and [Supplier ID] = 1
    Charlotte

  3. #3
    MrLuvigz2
    Guest

    Re: Filter problem (Access 2000)

    I have tried this and it still doesn't work. I know data should be coming back with this filter but is isn't. Any other suggestions?

  4. #4
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Edmonton, Alberta, Canada
    Posts
    326
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Filter problem (Access 2000)

    You've checked your data to make sure there really are records that have a supplier id of 1 and a date from November 12 2001 to November 29 2001 inclusive?

  5. #5
    MrLuvigz2
    Guest

    Re: Filter problem (Access 2000)

    Yes, still not pulling up data.

  6. #6
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Filter problem (Access 2000)

    Where are you trying to apply this filter, in a query, in code, or somewhere I haven't thought of? And are the values in your date field formatted as short dates? If they aren't, then you won't get some of the matches you would otherwise expect.

    Do you get records for those dates if you remove the other criteria?
    Charlotte

Posting Permissions

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