G
Gerry
My query contains a field 'scope' which can only contain the value 5,
10 or 15.
If the value for 'scope' is 5, then another field, lets call it
'result' equals 1. If the value is 10, this result value is 2 ans if
it is 15, we have 3 as a value for the field 'result'.
As my query runs sometimes the records contain only the value 5 (or 10
or 15) for the scope-field. Sometimes the 'scope' field contains more
values for a set of records. So I have 2 or 3 of them (5 and 10, 10
and 15, 5 and 15, 5 and 10 and 15). Thing is that when this happens
the field 'result' should contain for all records in the set the value
that corresponds with the highest value of the 'scope' field.
Can somebody help me with this?
Thanks!
geert
10 or 15.
If the value for 'scope' is 5, then another field, lets call it
'result' equals 1. If the value is 10, this result value is 2 ans if
it is 15, we have 3 as a value for the field 'result'.
As my query runs sometimes the records contain only the value 5 (or 10
or 15) for the scope-field. Sometimes the 'scope' field contains more
values for a set of records. So I have 2 or 3 of them (5 and 10, 10
and 15, 5 and 15, 5 and 10 and 15). Thing is that when this happens
the field 'result' should contain for all records in the set the value
that corresponds with the highest value of the 'scope' field.
Can somebody help me with this?
Thanks!
geert