In your query you could try putting VarNo field in Descending order and then
right click - properties and where it says 'All' type in '1'. This will
return the top value (one record) in the VarNo field.
--
Gina


"access user" wrote:

> I have a query and I wish to restrict the returned values to only those
> where, for a particular field, the value is the highest.
>
> For example, a property can have had a number of rent agreements but, in the
> following example, I don't want ALL the records, just the one where VarNo is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/9869-query-retrieve-only-those-highest-value.html
> the highest
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=9869
>
> PropertyNo TenantNo VarNo
> 1 1 1
> 1 1 2
> 1 2 3
>
> I *only* want the last line not all three lines.
>
> TIA
> James