I have a form in access database with toggle buttons next to amounts.
For example) Amount A =2; toggle button. Amount B = 3; toggle button. The form has a record source pointing to a query called "values" that calculates all the values.
I have a sum text box below the amounts, the sum text box has a formula that says [amountA]+[amountB]. Instead of the formula how can I remove the formula and add functionality that says =IF[amount A] toggle button = pressed on and if amount b toggle button = pressed on then sum the two amounts in the text box sum. if its pressed off do not include the amounts in the total.
Any help or ideas is appreciated. thanks!!