I use the following in a field in a form but would like it to do this in the table .
Event Procedure: after update
Me.FinancedPrice = Round(([SystemPrice] + ([SystemPrice] *0.075 + 850)) / 0.57 / 0.95 + 0, 0)
Me.Estpayments = Round(([FinancedPrice] * 0.0116), 0)
Me.CashPrice = Round([FinancedPrice] - [FinancedPrice] *0.05, 0)