IIf Statement

[D]

Hi:

I have two IIf statements; I did the split cause I could not get them into
one. I would please need jut one field called Value_Date.
Is there a way to consolidate them?

Thank you,

Dan

1. Value_Date: iif([P_Subtp] = "FWD" and [T_date]<[rpt_date],0,[T_date]
2. Value_Date1: iif([P_Subtp] <> "FWD" and [S_date]<[rpt_date],0,[S_date]

 

[RonaldoOneNil]

Value_Date: iif([P_Subtp] =
"FWD",iif([T_date]<[rpt_date],0,[T_date]),iif([S_date]<[rpt_date],0,[S_date]))

 

[Michel Walsh]

In fact, if that should return one value_date, that makes 3 cases:

case 1: NOT( [P_Subtp] = "FWD" and [T_date]<[rpt_date] )
return T_date
case 2: NOT( [P_Subtp] <> "FWD" and [S_date]<[rpt_date] )
return S_date
case else:
return 0


so:


Value_Date: Switch(
NOT( [P_Subtp] = "FWD" and [T_date]<[rpt_date] ) , T_date,
NOT( [P_Subtp] <> "FWD" and [S_date]<[rpt_date] ), S_date,
true, 0 )



Vanderghast, Access MVP

 

[D]

Would that take in consideration when [P_subtp]<> "FWD"

Thank you Ronaldo!

Value_Date: iif([P_Subtp] =
"FWD",iif([T_date]<[rpt_date],0,[T_date]),iif([S_date]<[rpt_date],0,[S_date]))

Hi:

I have two IIf statements; I did the split cause I could not get them into
one. I would please need jut one field called Value_Date.
Is there a way to consolidate them?

Thank you,

Dan

1. Value_Date: iif([P_Subtp] = "FWD" and [T_date]<[rpt_date],0,[T_date]
2. Value_Date1: iif([P_Subtp] <> "FWD" and [S_date]<[rpt_date],0,[S_date]

 

[RonaldoOneNil]

Yes, because the 3rd iif is the False part to the 1st iif - or in other
words when [P_subtp]<> "FWD"

Would that take in consideration when [P_subtp]<> "FWD"

Thank you Ronaldo!

Value_Date: iif([P_Subtp] =
"FWD",iif([T_date]<[rpt_date],0,[T_date]),iif([S_date]<[rpt_date],0,[S_date]))

Hi:

I have two IIf statements; I did the split cause I could not get them into
one. I would please need jut one field called Value_Date.
Is there a way to consolidate them?

Thank you,

Dan

1. Value_Date: iif([P_Subtp] = "FWD" and [T_date]<[rpt_date],0,[T_date]
2. Value_Date1: iif([P_Subtp] <> "FWD" and [S_date]<[rpt_date],0,[S_date]

 

[D]

Thanks a lot Michel!

I will try and let you know.

Thanks again,

Dan

In fact, if that should return one value_date, that makes 3 cases:

case 1: NOT( [P_Subtp] = "FWD" and [T_date]<[rpt_date] )
return T_date
case 2: NOT( [P_Subtp] <> "FWD" and [S_date]<[rpt_date] )
return S_date
case else:
return 0


so:


Value_Date: Switch(
NOT( [P_Subtp] = "FWD" and [T_date]<[rpt_date] ) , T_date,
NOT( [P_Subtp] <> "FWD" and [S_date]<[rpt_date] ), S_date,
true, 0 )



Vanderghast, Access MVP

Hi:

I have two IIf statements; I did the split cause I could not get them into
one. I would please need jut one field called Value_Date.
Is there a way to consolidate them?

Thank you,

Dan

1. Value_Date: iif([P_Subtp] = "FWD" and [T_date]<[rpt_date],0,[T_date]
2. Value_Date1: iif([P_Subtp] <> "FWD" and [S_date]<[rpt_date],0,[S_date]

 

[D]

Thank you very much, Ronaldo!

Dan

Yes, because the 3rd iif is the False part to the 1st iif - or in other
words when [P_subtp]<> "FWD"

Would that take in consideration when [P_subtp]<> "FWD"

Thank you Ronaldo!

Value_Date: iif([P_Subtp] =
"FWD",iif([T_date]<[rpt_date],0,[T_date]),iif([S_date]<[rpt_date],0,[S_date]))

:

Hi:

I have two IIf statements; I did the split cause I could not get them into
one. I would please need jut one field called Value_Date.
Is there a way to consolidate them?

Thank you,

Dan

1. Value_Date: iif([P_Subtp] = "FWD" and [T_date]<[rpt_date],0,[T_date]
2. Value_Date1: iif([P_Subtp] <> "FWD" and [S_date]<[rpt_date],0,[S_date]