If Functin within Access query

[Katrina]

Hi

I am new to if functins and wondered if anybody can tell me what I am doing
wrong.

I am using Access 2003 and and trying to use the if function in a query

It is one query based on another, can anyone tell me what I am doing wrong

SafetyTotal:
[S1C]+[S2C]+[S3C]+[S4C]+[S5C]+[S6C]+[S7C]+[S8C]+[S9C]+[S10C]+[S11C]+[S12C]+[S13C]+[S14C]+[S15C]+[S16C]+[S17C]+[S18C]+[S19C]+[S20C]+[S21C]

SafetyTraficLight:
IIf([SafetyTotal]<=7,"GREEN",IIf([SafetyTotal]>=8<=14,"AMBER",IIf([SafetyTotal]>=15,"RED")))

The first 2 parts of the function will work but anythng greated than 15 will
not return a red response.

Thanks everyone.

 

[Daryl S]

Katrina -

Try this:

IIf([SafetyTotal]<=7,"GREEN",IIf([SafetyTotal]>=15,"RED","AMBER"))

 

[Arvin Meyer [MVP]]

Try:

IIf([SafetyTotal]<=7,"GREEN", IIf([SafetyTotal]>=8 AND <=14,"AMBER","RED"))

 

[Tom van Stiphout]

On Tue, 1 Dec 2009 05:45:02 -0800, Katrina

Seems like a bad database design to me, with a large repeating group
SxC.
Your second IIf has a problem. It should say:
IIf(SafetyTotal>=8 AND SafetyTotal<=14,

-Tom.
Microsoft Access MVP

 

[Al Campagna]

Katrina,
Try... (all on one line)
IIf([SafetyTotal]<=7,"GREEN",IIf([SafetyTotal]>=8 AND
[SafetyTotal]<=14,"AMBER",IIf([SafetyTotal]>=15,"RED")))
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."