max values

N

Nero

hi there.... i need help with the following.

I need find the max value of the top 60% of entries filtered in acsending
order.
 
K

KARL DEWEY

I need find the max value of the top 60% of entries
The max value will the same no matter what percent is selected.
Filtering has nothing to do with order.

Or do you mean that you want to sort ascending, extract 60%, then take the
last record which will be the maximum of that record set?
 
N

Nero

yes, thats what i mean.... i have a table with a field named ActualAht, this
is input by date and agentID. i have to sort the data in ascending order,
then filter 60% of those records and find the Max value as this would set a
target for the following month.
 
Top