>I would like to find (and print) the last record in a table that has specific data.
>
>Example: a table consisting of 300 records, record numbers 3, 41 & 250 has the field (field.computer) populated with the name "hellcat". I would like to find/print record number 250. (The tricky part of course is, I do not know that recno()=250 has the data I need.)
>
>Any help on the proper syntax is greatly appreciated.
>
>Thanks,
>Billy
if you have an index on that field in your table you can try this:
SET ORDER TO MyTag DESCENDING
seek "hellcat"
this should give you the 'last' entry
hope this helps