Re: Help with Case Statement

Can you create small lookup table with unique values of txtText1 and
txtText2 with the resulting text3 value. Then just join this lookup and
maintain data rather than expressions.


--
Duane Hookom
MS Access MVP

<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)
  • 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
    ... completely off the top of my head, untested, and long after my bedtime:- ... 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)
  • 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)