I needed to enter a new field in a form that divides gross yearly pay by 26. I created a field in my DB entitled "pay period". I then added that field to my form with the function of this file would equal the gross pay field divided by 26. Now, when I enter the gross pay on the form it automatically divides the same by 26 and enters the figure in my "pay period" box. However, when I run a query which includes the "pay period" field I get nothing but blanks. Looking at the database I have found that none of the entries on the form that are automatically calculated appear in the database.
Wondering if I should have set the function in the database instead of on the form, assuming that can be done???
Thanks!