>I have an index that is called stu_day which is >str(stu_day)+stu_room+str(stu_bgntime). > >Lets say I have a student scheduled for day 1, room 1 , and from 1:00pm to >2:00pm. > >My problem is ... that if I set order to stu_day and do a seek on day 1, >room 1 and bgntime of 1:30 I would like this particular student to be >selected, However the index is set on stu_bgntime so this student will not >be selected. If I "Set Near on" it will find the next record. Is there a >way to do a find <= on an index in VFP. Or is the best way to do this to >"Set Near On" and then if !found() do a seek -1 and then do some checking >to make sure the time is "Between" stu_bgntime and stu_endtime and the day >and room are correct?