multiple query

[sal.fresco]

Hello and thanks in advance for any help.

I need to do the following:

three ranges in age:
<45
between 46 and 55
>56

six ranges in "pieces":
75000
75000 to 150000
150001 to 250000
250001 to 350000
350001 to 450000
450001 to 550000
> 550000

and 11 ranges in "Result"
QM
1
2
3
4
5
6
7
8
9
10

for example:

if "age" is <45 and "values" = 75000 the "result" should be "QM"

but if "age" is ">56" and "value" is 75000 result should be "1"


can anyone help?

regards
Sal

[Dave H9]

We would need to understand the criteria for producing the result to help, can you provide these details? Also check your use of < (less than) and > (greater than), I think you may be mixing them up.

[sal.fresco]

We would need to understand the criteria for producing the result to help, can you provide these details? Also check your use of < (less than) and > (greater than), I think you may be mixing them up.

Hi Dave,
Sorry about the mistake on the <> signs, you were right.

What I need to do is in the attached file.

Regards

[Dave H9]

Hi Sal,

It's not the most elegant solution but please try the attached.

Dave

[sal.fresco]

Hi Dave H9,

sorry for the late reply, but I've been away for a few days...
The solution you provided works.

thanks a bunch

Sal