> It's important to determine how the end points function. If the starting point of the "user described range" is considered to overlap the ending point of a record, then BETWEEN will work for you. An application similar to this did not consider this to be an overlap. In that situation, Garrett's approach will work for you.10-4. It's not considered an overlap, so the IF ... OR ... should do the trick.
Thanks for the input.
Randy Bosma
VFP - Because life is too short to code in something else...