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
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
