Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Splitting a Tie! (A97)

    I have used Top Values = 10 in a query to select data for a Pareato Graph. For the most part this works fine but if there is a tie for 10th and 11th place then the query returns 11 results and spoils my graph <img src=/S/sad.gif border=0 alt=sad width=15 height=15>

    I have thought of adding a very small random number to the results, which would break the tie but be small enough not to affect the apparent result. The problem is that this does not cure the problem but just reduces the probability of it happening.

    I was wondering if anyone has another approach to this problem?

    Peter

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Splitting a Tie! (A97)

    In your query, add a field with an expression that combines your value field formatted with 0 and any other field you know will be different. ex an ID field that you also format with 0. Sort the query on this new expression. something like this:
    Expr1: Format([ValueField],"000000") & Format([IDField],"000000"
    Be sure to have enough 0 to cover the greatest number of digits in the fields.
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Maidstone, Kent, England
    Posts
    398
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Splitting a Tie! (A97)

    Thanks Francois, will give that a try <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    Peter

Posting Permissions

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