Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Select Query (Access 2K)

    I'm trying to come up with a query using the following criteria on a column called "ClosingDate":
    Month([ClosingDate])>=[AnyNumberBetween1And12]
    Could anyone explain why the results don't show data for months 10, 11 or 12?
    Thanks in advance for any assistance!

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

    Re: Select Query (Access 2K)

    Is this a parameter query with [AnyNumberBetween1And12] as parameter? In that case, you should "declare" it explicitly by selecting Query/Parameters... in design view, and typing [AnyNumberBetween1And12] in the first column, and selecting Integer in the second column. Then click OK. This forces Access to treat it as a number instead of text.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Sunrise, Florida
    Posts
    324
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Select Query (Access 2K)

    I apologize for being dumb. Your solution works as advertised! Thanks!

Posting Permissions

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