Check box Controls

[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

 

[KARL DEWEY]

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

 

[mrbernh]

Where does this get entered?

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

 

[KARL DEWEY]

Open query in desogn view and place in a blank column of the field row of the
grid.
--
Build a little, test a little.

Where does this get entered?

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

 

[mrbernh]

When enter it works, but it asks me what the parameter value is instead of
opening the data sheet.

Open query in desogn view and place in a blank column of the field row of the
grid.
--
Build a little, test a little.

Where does this get entered?

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