If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Check box Controls
I am a serious novice with access.
So my question is I am creating a simple program to calculate sales tax on work completed. I want to have a check box that controls the tax on items as some items are not taxable and some are I want the check box to either add the tax or not to. How do I set the controls to due so? Mike |
#2
|
|||
|
|||
Check box Controls
Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0)
-- Build a little, test a little. "mrbernh" wrote: I am a serious novice with access. So my question is I am creating a simple program to calculate sales tax on work completed. I want to have a check box that controls the tax on items as some items are not taxable and some are I want the check box to either add the tax or not to. How do I set the controls to due so? Mike |
#3
|
|||
|
|||
Check box Controls
Where does this get entered?
"KARL DEWEY" wrote: Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0) -- Build a little, test a little. "mrbernh" wrote: I am a serious novice with access. So my question is I am creating a simple program to calculate sales tax on work completed. I want to have a check box that controls the tax on items as some items are not taxable and some are I want the check box to either add the tax or not to. How do I set the controls to due so? Mike |
#4
|
|||
|
|||
Check box Controls
Open query in desogn view and place in a blank column of the field row of the
grid. -- Build a little, test a little. "mrbernh" wrote: Where does this get entered? "KARL DEWEY" wrote: Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0) -- Build a little, test a little. "mrbernh" wrote: I am a serious novice with access. So my question is I am creating a simple program to calculate sales tax on work completed. I want to have a check box that controls the tax on items as some items are not taxable and some are I want the check box to either add the tax or not to. How do I set the controls to due so? Mike |
#5
|
|||
|
|||
Check box Controls
When enter it works, but it asks me what the parameter value is instead of
opening the data sheet. "KARL DEWEY" wrote: Open query in desogn view and place in a blank column of the field row of the grid. -- Build a little, test a little. "mrbernh" wrote: Where does this get entered? "KARL DEWEY" wrote: Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0) -- Build a little, test a little. "mrbernh" wrote: I am a serious novice with access. So my question is I am creating a simple program to calculate sales tax on work completed. I want to have a check box that controls the tax on items as some items are not taxable and some are I want the check box to either add the tax or not to. How do I set the controls to due so? Mike |
Thread Tools | |
Display Modes | |
|
|