Re: Help with Case Statement

completely off the top of my head, untested, and long after my bedtime:-

iif(10*instr("abnormalnormalcase3case4",text1)+instr("redgreenvioletpink",text2)
in(11,whatever,whatever), "It is good","BAD")


<lurch279@xxxxxxxxxxxx> wrote in message
news:1156985328.406157.118530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi folks!

I have two fields in a query txttext1 and txttext2 that I would like to
evaluate and based upon the result put a value in txttext3.

What I would like to do is call a function within my Access 2000 query
that would take a value of text1 and a value from text2 and give me a
'return' in text3

So if text1 = "Abnormal" and text2 = "red" then text3 = 'It is good"
but if text1 = "Normal" and text2 = "Green" then text3 = "This is not
good"

I cannot use iif as I will need about 15 nested iif's (plus it'd
confuse the hell outa me) - I have alot to compare :(

I can do this if I evaluate just one field but I don't have the 'know
how' to add a second evaluation.....I'm just a beginner!!

Any help you guys could provide would be MOST appreciated!!

Thanks!

Lurch



.

Relevant Pages

  • Re: Help with Case Statement
    ... Public Function Region(Province_State As String, ... Region = "Ontario South" ... I have two fields in a query txttext1 and txttext2 that I would like to ...
    (microsoft.public.access.queries)
  • Help with Case Statement
    ... I have two fields in a query txttext1 and txttext2 that I would like to ... confuse the hell outa me) - I have alot to compare:( ... how' to add a second evaluation.....I'm just a beginner!! ...
    (microsoft.public.access.queries)
  • Re: Help with Case Statement
    ... I could not go to bed having advocated such bad practise. ... I have two fields in a query txttext1 and txttext2 that I would like to ... confuse the hell outa me) - I have alot to compare:( ...
    (microsoft.public.access.queries)
  • Re: Help with Case Statement
    ... Can you create small lookup table with unique values of txtText1 and ... txtText2 with the resulting text3 value. ... I have two fields in a query txttext1 and txttext2 that I would like to ...
    (microsoft.public.access.queries)