Querying data, retrieve only the first match-

[Guest]

I am querying some data in which some records have multiple cost prices
associated with one item. In these cases, I'd like the query to return only
the first cost price it finds (not all the costs) and then also the
coinciding retail price with that one cost. Thanks!

 

[Guest]

The 'first' one your query finds may not always be the same based on how you
sort or other factors. You need to use a different criteria such as lowest
dated.