>I would like to search a table for a record where a paricular field equals a value and then to give me a particular value from another field. This is fine. What if I wanted to look for a particular occurence. For example the 2nd occurence or the 3rd. But not the 1st or 4th. Is this possible?
>
>Many Thanks

'Piece of cake!'

Select * from yourtable where yourcondition into cursor curdummy nofilter && Nofilter is vital!
If only_one_record_at_a_time
  Goto 2 && Second hit
  Goto 3 && Third hit
Else
  Select * from curdummy where recno()=2 or recno()=3
Endif