IIf statement?

[Guest]

I have a IIf statement. Now I want to add some limit, but it won't accept it.
Could someone tell me where is wrong? Or I can't use it like that? Thank you.
Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

 

[Dirk Goldgar]

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

 

[Guest]

No, Expression Builder still won't accept the change.

BTW, I use Aceess 2000.

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

No, Expression Builder still won't accept the change.

BTW, I use Aceess 2000.

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Where are you trying to put this expression?

 

[Guest]

In a report, textbox

No, Expression Builder still won't accept the change.

BTW, I use Aceess 2000.

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Where are you trying to put this expression?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

In a report, textbox

No, Expression Builder still won't accept the change.

BTW, I use Aceess 2000.

:

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Where are you trying to put this expression?

As the controlsource of a text box, you need to begin the expression
with an equals sign:

=Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Forget the expression builder. If you copy and paste that into the text
box's ControlSource property, does it work?

 

[Guest]

No, it still wont change controlsource. Sorry, actually, it's more complex.
Here is the whole thing.

The original
=Count([Charge])-Sum(IIf([Fail]>4,1,0))-Sum(IIf([Type]<>"AAA" And
[Type]<>"BBB",1,0))
Here is the modified one.
=Count([Charge])-Sum(IIf([Type]="AAA" Or
[Type]="BBB",IIf([Fail]>4,1,0),0))-Sum(IIf([Type]<>"AAA" And
[Type]<>"BBB",1,0))

In a report, textbox

No, Expression Builder still won't accept the change.

BTW, I use Aceess 2000.

:

I have a IIf statement. Now I want to add some limit, but it won't
accept it. Could someone tell me where is wrong? Or I can't use it
like that? Thank you. Current:
Sum(IIf([Fail]>4,1,0))
New: (If Type = AAA or BBB, Check the fail)
Sum(IIf([Type] = "AAA" Or [Type] = "BBB"), IIf([Fail]>4,1,0),0)

I see errors in your parentheses. Try this:

Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Where are you trying to put this expression?

As the controlsource of a text box, you need to begin the expression
with an equals sign:

=Sum(IIf([Type] = "AAA" Or [Type] = "BBB", IIf([Fail]>4,1,0),0))

Forget the expression builder. If you copy and paste that into the text
box's ControlSource property, does it work?

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

 

[Dirk Goldgar]

No, it still wont change controlsource. Sorry, actually, it's more
complex. Here is the whole thing.

The original
=Count([Charge])-Sum(IIf([Fail]>4,1,0))-Sum(IIf([Type]<>"AAA" And
[Type]<>"BBB",1,0))

So the original worked?

Here is the modified one.
=Count([Charge])-Sum(IIf([Type]="AAA" Or
[Type]="BBB",IIf([Fail]>4,1,0),0))-Sum(IIf([Type]<>"AAA" And
[Type]<>"BBB",1,0))

Huh. I don't see anything wrong with that. That's an exact copy/paste
of what you're trying? What error message do you get?