A
access user
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
the highest
PropertyNo TenantNo VarNo
1 1 1
1 1 2
1 2 3
I *only* want the last line not all three lines.
TIA
James
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
the highest
PropertyNo TenantNo VarNo
1 1 1
1 1 2
1 2 3
I *only* want the last line not all three lines.
TIA
James