Query Function

Dumbfounded

Registered User.
Local time
Today, 14:07
Joined
Jul 26, 2007
Messages
92
Hello Lovely Access Forum Members,

I'm a bit brain dead and really need to go and sleep - but I know that this will keep me awake and go around and around in my head. I'm not seeing what I'm doing wrong because I'm tired and need a new pair(s) of eyes on it.

I'm doing a risk assessment database and the criteria in the query is as follows, I think I'm over complicating it and just need pointing in the right direction:-

If reversing check box only is true then return MEDIUM
but/and if speed limit >=40 return HIGH
but/and if item = Hospital, School, Nursery or Yes then also return HIGH

I know that it's a pretty easy formula but I'm just not getting it.

Thanks in advance.

Donna :o
 
How about:


Iif([speedlimit] > 39 OR Instr(1,"hospital,school,nursery,yes",[Item]) > 0,"HIGH",Iif([reversingcheckbox] = TRUE, "MEDIUM","NotMediumOrHigh"))
 
Just the Job

Hi DAL,

That's just the job, thanks a lot - I was over complicating it and I think I'd got things in the wrong order too - but I should be able to move on now.

Thanks again, much appreciated.

Donna x :D
 

Users who are viewing this thread

Back
Top Bottom