Results 1 to 3 of 3

Thread: Banding (2000)

  1. #1
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Banding (2000)

    I would like to be able to analyse a table or query based on a table so I can get just a simple banding i.e

    the counts of records with values between 0 & 9.99 ,10 &19.99 ,20 & 29.99 etc

    cheers

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

    Re: Banding (2000)

    Welcome to Woody's Lounge.

    You can create a query based on your table and use the little-known Partition function for the banding.
    When you have created the query and added your table, select View | Totals
    In the first column, enter

    Band:Partition([FieldName],0,1000,10)

    (Replace FieldName with the name of the field on which you want to create bands)
    0 is the start value, 1000 the stop value (modify as needed) and 10 is the interval (the width of the bands).
    Leave the Total option as it is (Group By).
    In the second column, enter

    Number: Count(*)

    and change the Total option to Expression.

  3. #3
    Lounger
    Join Date
    Mar 2005
    Posts
    27
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Banding (2000)

    Hans

    Cheers that works really well, once it dawned on me that I could change the stop value from 1,000 upwards to over a million etc, I shall now be using it everywhere.

    thanks again

Posting Permissions

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