calculation based on criteria

[Guest]

I am trying to get a field to calculate a certain way based on criteria. In
other words if the value of the Lite field is JD then the calculation should
be Sum([Cns].[FEE])*8*0.087 if the value is not JD then the calculation
should be Sum([Cns].[FEE])*7*0.140. Any suggestions?
This is what I put in the field line that didn't work (don't laugh it was
pure guess work! ):
Sum of FEEs:
IIf([Cns].[Lite]='JD',Sum([Cns].[FEE])*8*0.087,Sum([Cns].[FEE])*7*0.140)
Thanks a lot for any help!
-Jen

 

[Guest]

I don't have time to test this tonight (time to go), but give it a try. If
it doesn't work, post back and I can test it in the morning.

Sum([Cns].[Fee] * IIF([Cns].[LIte] = "JD", 8*0.087, 7*0.140)

 

[Gary Walter]

I am trying to get a field to calculate a certain way based on criteria.
In
other words if the value of the Lite field is JD then the calculation
should
be Sum([Cns].[FEE])*8*0.087 if the value is not JD then the calculation
should be Sum([Cns].[FEE])*7*0.140. Any suggestions?
This is what I put in the field line that didn't work (don't laugh it was
pure guess work! ):
Sum of FEEs:
IIf([Cns].[Lite]='JD',Sum([Cns].[FEE])*8*0.087,Sum([Cns].[FEE])*7*0.140)

Pardon me for...

if I am looking at a record in
the group I am making,

factor for that record is
IIF(Cns.Lite='JD', 8*0.087,7*0.140)

product for that record is
factor * Cns.FEE

again, want to do that for every single record
in the group

then, want to sum all those products
to produce a sum of products for all
records for that group


SUM(IIF(Cns.Lite='JD', 8*0.087,7*0.140)*Cns.FEE)

 

[Guest]

It works!! Thanks for your help!!
-Jenny

I don't have time to test this tonight (time to go), but give it a try. If
it doesn't work, post back and I can test it in the morning.

Sum([Cns].[Fee] * IIF([Cns].[LIte] = "JD", 8*0.087, 7*0.140)
--
Dave Hargis, Microsoft Access MVP

I am trying to get a field to calculate a certain way based on criteria. In
other words if the value of the Lite field is JD then the calculation should
be Sum([Cns].[FEE])*8*0.087 if the value is not JD then the calculation
should be Sum([Cns].[FEE])*7*0.140. Any suggestions?
This is what I put in the field line that didn't work (don't laugh it was
pure guess work! ):
Sum of FEEs:
IIf([Cns].[Lite]='JD',Sum([Cns].[FEE])*8*0.087,Sum([Cns].[FEE])*7*0.140)
Thanks a lot for any help!
-Jen