I have an unbound field with the calculation of
=IIf([Tax_Exempt]=0,[Account_Total]*0.065,0)
How do I take that value and store it in the table in the field called Tax? I need the value stored into the table so I can call upon it later in a query. The way the form is set now, the tax is calculated on the fly in the form, but in the table the field "TAX" is all zeros. Thanks for the advise, the users on this forum are ALWAYS helpful.
=IIf([Tax_Exempt]=0,[Account_Total]*0.065,0)
How do I take that value and store it in the table in the field called Tax? I need the value stored into the table so I can call upon it later in a query. The way the form is set now, the tax is calculated on the fly in the form, but in the table the field "TAX" is all zeros. Thanks for the advise, the users on this forum are ALWAYS helpful.