Dear All
I have been figuring a way to do this but it is not working...
I have a combo box named session which drops down either AM or PM.
I have an amount text box relating to the session. e.g.
AM £1000
PM £2000
I also have a Total Sales Amount text box that we input the day's Sales. In this case is £3000. However, I only get the AM amount from the epos that I key in. i.e.£1000
I dont get the PM amount from the epos. At end of the day, I get the Total Sales amount from the epos i.e. £3000
So I key in the £3000. The PM is a calculated field by subtracting AM amount from Total Sales Amount.
I dont know how to put this equation in the PM field as it is part of the combox box selection.
I hope i make this clear as I am pretty lost myself....
Is this impossible??
I have been figuring a way to do this but it is not working...
I have a combo box named session which drops down either AM or PM.
I have an amount text box relating to the session. e.g.
AM £1000
PM £2000
I also have a Total Sales Amount text box that we input the day's Sales. In this case is £3000. However, I only get the AM amount from the epos that I key in. i.e.£1000
I dont get the PM amount from the epos. At end of the day, I get the Total Sales amount from the epos i.e. £3000
So I key in the £3000. The PM is a calculated field by subtracting AM amount from Total Sales Amount.
I dont know how to put this equation in the PM field as it is part of the combox box selection.
I hope i make this clear as I am pretty lost myself....
Is this impossible??
