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.
Last edited by WT2008; 05-11-2010 at 05:19 PM.
Where is the subtotal field located, a form, a report, a query?
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
Hello split_atom18,
The subtotal field is located in a form.
Thanks
I would just create an unbound field, and put the following in the control source.
=nz([Amount1],0)+nz([Amount2],0)+nz([Amount3],0)+nz([Amount4],0)+nz([Amount5],0)
Hope this helps,
Dan
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
That was great! Thank you for your help.
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.
"I am not a rocket scientist, I am a nuclear engineer." - Split_atom18
If my advice has been helpful to you, then please help me by clicking on the "Star" and adding to my reputation, Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks