S
sanj
Guest
This problem has been bugging me for a whole week, and I would be eternally grateful if anyone can help solve it:
I have a form where customers can order a variety of products. The forms' underlying table is called TableCustomers and stores (almost) all the information inputted in its respective form. I have three fields in the form that display the sub total, VAT (tax) and Total (an addition of Sub Total and VAT)
These three fields are calculated by using simple formulas, by pulling information from other areas. For instance, if a customer chose a particular wine from a drop down box, the cost of that wine would be 'sent' to the running sub total (i.e: =Text97). Due to all the calculations being performed on the form, the final totals for some reason will not save to Table Customers, whilst everything else (such as customer details) will. What am I doing wrong? Should I give up the computing degree? Is Access not so accessible?
Thanks in advance
I have a form where customers can order a variety of products. The forms' underlying table is called TableCustomers and stores (almost) all the information inputted in its respective form. I have three fields in the form that display the sub total, VAT (tax) and Total (an addition of Sub Total and VAT)
These three fields are calculated by using simple formulas, by pulling information from other areas. For instance, if a customer chose a particular wine from a drop down box, the cost of that wine would be 'sent' to the running sub total (i.e: =Text97). Due to all the calculations being performed on the form, the final totals for some reason will not save to Table Customers, whilst everything else (such as customer details) will. What am I doing wrong? Should I give up the computing degree? Is Access not so accessible?
Thanks in advance