peeverocket
December 5th, 2006, 07:20 AM
I have a select expert formula comprising of the following {KIT_TBL.KIT_PART_ONLY} startswith ["A-", "F-", "L-"] but I want to show only the top 10 records for any that start with A- There is a quantity field that i can use for the top ten.
I guess the formula would be something like:
{KIT_TBL.KIT_PART_ONLY} startswith ["F-", "L-"] and
{KIT_TBL.KIT_PART_ONLY} startswith ["F-"] where topcount {quantity} 10 something a long those lines but i know the code is wrong but I am just trying to explain. Can anyone help??
I guess the formula would be something like:
{KIT_TBL.KIT_PART_ONLY} startswith ["F-", "L-"] and
{KIT_TBL.KIT_PART_ONLY} startswith ["F-"] where topcount {quantity} 10 something a long those lines but i know the code is wrong but I am just trying to explain. Can anyone help??