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