Help with Iff statemet not working

[idavis1900]

Can someone help me with my iff statement
=IIf([ExpenseCategoryID]=3,([ExpenseItemAmount]-[ded])*0.5,([ExpenseItemAmount]-[ded])*0.8)

My problem is when [ded] is blank.
Thanks for any help in advance

 

[PHV]

=([ExpenseItemAmount]-Nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,0.8)


Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[idavis1900]

PH

Thank you that works much better. Can you tell me if there is a way to get the result to fill in a cell on a table

Irene

 

[PHV]

???

 

[idavis1900]

Sorry about that say the iff statement result is $50.00, is there away that 50.00 is filled in a table field name [ded]

 

[PHV]

WHAT DO YOU WANT TO DO ?

 

[idavis1900]

I would like to save the value of a text field on the access form into a table. Can you tell me how to do this? I would believe it is some code.

 

[randy700]

You're talking about saving a calculated field, which is not recommended.

Randy