Hi,

>>
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?
>>
A variation on Tore's suggestion:

Select Recno() from yourtable where yourcondition into ARRAY aHits
* Assuming a bit of array bounds checking:
Goto aHits(2) in yourtable  && 2nd

HTH,
Viv