can I solve this by code?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

working with calculated field based upon different tables 4
Macro to add numbers in a text string 5
Scrabble Value calculation for Welsh words 0
unique records Access 2003 2
calculated field - difficult 11
Calculating totals in access 1
Nested IIF more than 10 8
parse txt file to add to table fields 4

Top