Split (divide) Number, and show halves in two fields
I am working on a scholarship budget database where we input student scholarship totals in one field, and would like it, in the Fall Semester and Spring Semester fields to populate the halved amount.
If I create a calculation field and divide the total amount, it will give only one number. But how do I set my fields up so that when I enter the total scholarship amount in the "Total Award" field, the other two fields are populated automatically with the halved amounts?
I'm guessing there's more than just a basic calculation involved..
I don't understand why you have a problem here.
Both ccan be defined as calculation fields with this expression:
You might even be able to get away with using a single field and placing two copies of the same field on your layout--one for spring and one for fall.