Check box Controls

  • Thread starter Thread starter mrbernh
  • Start date Start date
M

mrbernh

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
 
Where does this get entered?

KARL DEWEY said:
Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0)

--
Build a little, test a little.


mrbernh said:
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
Click to expand...
Click to expand...
 
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 said:
Where does this get entered?

KARL DEWEY said:
Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0)

--
Build a little, test a little.


mrbernh said:
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
Click to expand...
Click to expand...
Click to expand...
 
When enter it works, but it asks me what the parameter value is instead of
opening the data sheet.

KARL DEWEY said:
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 said:
Where does this get entered?

KARL DEWEY said:
Tax_Due: IIF([Tax_Check_Box] = -1, [Price] * [Tax_Rate]), 0)

--
Build a little, test a little.


:

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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top