Display Total on a form

[Ray67]

Thank you very much that worked.

[pbaldy]

Happy to help.

[Ray67]

sorry one more question. I would like to add two them together. so 3+5

[pbaldy]

FieldName = 3 OR FieldName = 5

[Ray67]

i would like to add fieldname 3 and 5 together. So it would gave me the sum of both fieldnames.

[pbaldy]

Yes, I know.

=Sum(IIf([Source of Payment] = 3 OR [Source of Payment] = 5 , [Cash]+[Check]+[Credit Card], 0))

[Ray67]

Thank you very much it worked