I have been looking through the forums for the answer to this but cannot get anything to work.

I'm looking for a global that will do this:
using the search results
display only the first record
that has the field 'axis' filled in.

ie: if the first record found has the field 'axis' filled in, it will be displayed in the results.
if, however, the first record does not have the field 'axis' filled in, it will keep doing down the list until it finds a record to display.

Can anyone help me with this?
Thanks