help with calculation field: if value is between x and y...
im trying to create a field that tells me: how many values in field X are between "value" and "value"
like if value is between 0 and 10... then i want the total number of instances.
my thinking is that i need two fields
1. calculation field If ( %score= "is between 0 and 10" ;1;0)
2. summary field total of above field 1.
but i cannot figure out the range part.
is there a better way?
fmpa 9, mac osx 10.5.8