1 Reply Latest reply on Sep 21, 2009 8:56 AM by philmodjunk

    problem with summary field

    cartz

      Title

      problem with summary field

      Post

      Hello,

       

      I have a table with an indexed field called KEY that is a calculated field combining three other fields. The key is not unique and there will be up to 24 records for each key. There is a price field that the table has been sorted by so that the records for each KEY are sorted in ascending order.

       

      I have added a field to the database called ORDER and made that a SUMMARY field being a COUNT of KEY, a running count, restart summary for each group when sorted by KEY. I have selected Individually for Summarize Repetitions.

       

      The ORDER field gives me a running count of all of the records in the table. So the first record in the table has a value of 1 and record 6500 has a value of 6500.

       

      This is not what I want. I want the count to reset after each change in KEY. So when the KEY changes the count resets to 1.

       

      I'm wanting to do this so I can easily grab the lowest price for a given key, or list the 2nd lowest through to the 5th lowest etc.

       

      Am I misunderstanding how the Summary Fields should work? I thought having Restart Summary for Each Group would achieve what I'm after.

       

      Thanks,

       

      cartz.