between in calculations
Hello, have FMP 11 advancesd
I have three parameters and am trying to calculate the number of each in a summary field.
Under 6000 Case ( Number < 6000 ; 1 ; "" )
6000 to 9999 ???
Over 10000 Case ( Number > 9990 ; 1 ; "" )
I am thinking that I have to have six fields, one each for the numbers that fall into each of the boundaries and then the summary field of each of those numbers. First, is this correct and then how do I do the calculation for 6000 to 9999?
Thank you for any help on this.