i am creating a questionnaire program but am stuck on one problem.

i have a list of number answers say:

23

25

60

100

5000

46

and i have a separate table of sectors i wish to sumerise these answers

eg

text sector--------------min value-------------max val

10 - 50 ---------------- 10 ------------------ 50

51 100 ----------------- 51 ------------------ 100

101 - 1000 ------------- 101 ----------------- 1000

1001 - 10000 ----------- 1001 ---------------- 10000

10001+ ----------------- 10001 --------------- 99999999999999

totally stuck as to how i can do this, does any one have any ideas

Cheers

text sector=

Case(

number > 10000,"10001+",

number >1000,"1001-10000",

number > 100,"101-1000",

number >50,"51-100",

number > 9, "10-50"

)

This is assuming that your values are records in a FileMaker File.

the values are in records of a filemaker table

but so are the sectors and for each question there are different sectors

so i need somthing that is dynamic for each question

the answers are linked to its parent question by an id num and the sectors are related in the same way to question (Question ID)

so indirectly the answers and the corresponding sectors are related by the foreign key of question id

is there any way i can use this

i can see a way to do this with a script by looping through the related portal of sectors and matching the relevant min and max figures. but i dont want to make them have to run this every time they enter or change answer