var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get rid of maximun and minimun values among several fields
This is it, say i have six numeric fields to fill in.
What i need is to get rid of the biggest and smallest numbers among these six fields, so i can take into account just the middle four left fields. It's a system for ranking persons performances.
and i need to get rid of the biggest and lowest entered values, in this case, i should get rid of fields #2 and #5
How can i do this?. any idea?
that depends on what you mean by "get rid of"
what are you actually trying to do, update the row?
Not really, i mean not to use them, maybe what i need is a subrecordset that doesn't take into account the highest and lowest values from those fields
could you show the query that you want to use the middle 4 fields in?
i'm having a hard time picturing a "subrecordset"
it's done. I'v used the LIMIT function to get rid of the last and first values.
Now, is there a way to sum these middle values?, i've tried the SUM() but had no luck.
use SUM() in an outer query, put your query as the subquery