Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2004
    Posts
    11

    Unanswered: Rankings query not working when using Between..And operand

    I have a ranking query that I ask for rankings between one place and another. When I ask for rankings between 1 and 25 it gives me the ranking data for the following places.
    1
    2
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25

    It is not giving be placings 3-9. If I ask for placings 1-30 it gives me 1-3 and then rankings 10-30.

    Any help is appreciated.

  2. #2
    Join Date
    Jul 2005
    Posts
    39
    When you ask for rankings between 1 and 40, does it return 1-4 and 10-40?

  3. #3
    Join Date
    Sep 2004
    Posts
    11
    Yes it does.

  4. #4
    Join Date
    Jul 2005
    Posts
    39
    Try looking at the query itself. Suspect it is trimming the parameters so if you ask it for 4-60, it will return 4-6 and 10 (default) to 60.

  5. #5
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Ah Geez ... Let me guess. Your rankings are text/string right?
    Back to Access ... ADO is not the way to go for speed ...

  6. #6
    Join Date
    Sep 2004
    Posts
    11
    Thanks Taurus

    I see that it is reading the value of the number as text instead of number...I have fixed it and is now working properly.

Posting Permissions

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