If I write a select case statement for a field X i.e. 6 to 7 for example will this:
1. Select any fields X where the number is greater than or equal to 6 but less than (and not including) 7
B. Select any fields X where the number is greater than or equal to 6 but includes decimels of 7 i.e. 7.5
OR
C. Select any fields X where the number is greater than or equal to 6 but includes but literally only includes cases where the the whole number 7 appears>
I only ask because in an example in a book I am looking at says:
Case 10000 to 20000
......
Case 20001 to 30000
I would have through the word "to" means until but not including but in this case the field that equals 20000 would never be selected?
1. Select any fields X where the number is greater than or equal to 6 but less than (and not including) 7
B. Select any fields X where the number is greater than or equal to 6 but includes decimels of 7 i.e. 7.5
OR
C. Select any fields X where the number is greater than or equal to 6 but includes but literally only includes cases where the the whole number 7 appears>
I only ask because in an example in a book I am looking at says:
Case 10000 to 20000
......
Case 20001 to 30000
I would have through the word "to" means until but not including but in this case the field that equals 20000 would never be selected?