Sum dynamic fields

Here is my problem today.
I have 5 currency fields that are filled in order when I add records to the database.
Amount1, Amount2, Amount3, Amount4 and Amount5.

I need to sum all these fields into another field called SubTotal.

I need to put in the SubTotal field the Amount1 if no other Amount field contains data, or
Amount1 plus Amount2 if only these fields contain data, or
Amount1 plus Amount2 plus Amount3…
In other words, the SubTotal field will be the adjusted according to the data of these 5 previous fields.

How can I do this please?
Thank you.

Where is the subtotal field located, a form, a report, a query?

I would just create an unbound field, and put the following in the control source.

Please Login or Register  to view this content.

Hope this helps,

Dan

No problem at all, Glad I could help! Be sure to mark your thread as solved, by editing your first post and selecting solved pre-fix.