One field dividing # in another filed.

[PATRICKPBME]

I have a field (BasePay) for yearly pay. I then have field )PayPeriod) to divide that number by 26. In design view I have entered into the latter field the expression =[BasePay/26]. However, when I then go back to form view I get the following: #Name?




​Both fields are formatted as currency. Thanks!

[davegri]

Try =[BasePay] / 26

[PATRICKPBME]

Try =[BasePay] / 26

BINGO! That did it. Thanks so much!!