J
Jodi J
Requirement is for the user to enter a range of numeric data, low to high.
Purpose of the range is to save data entry time when entering a record.
Instead of entering1,2,3,4.... in up to 99 fields, the user can enter "1" and
"47" into a low and high field. Later, the user needs to select the record
if a specified number falls within this range.
1. Can I, and if so how do I determine (via query?) whether a specified
number falls between the low and high range?
2. Is my assumption that the data has to be stored as numeric in two
separate fields correct?
I have tried creating one text field (1-47) and two numeric fields (1 47)
but either way, I simply don't know how to determine if the specified number
falls between the low and high values.
Thanks much in advance
Purpose of the range is to save data entry time when entering a record.
Instead of entering1,2,3,4.... in up to 99 fields, the user can enter "1" and
"47" into a low and high field. Later, the user needs to select the record
if a specified number falls within this range.
1. Can I, and if so how do I determine (via query?) whether a specified
number falls between the low and high range?
2. Is my assumption that the data has to be stored as numeric in two
separate fields correct?
I have tried creating one text field (1-47) and two numeric fields (1 47)
but either way, I simply don't know how to determine if the specified number
falls between the low and high values.
Thanks much in advance