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..