Calculator in a Continous form

[lilbit27]

Is there a way to create a calculator on a coninous form?

I have three amounts gross, commisson, and net. not based on what
they select I want to create a running total.

So say the checks (checkbox) line 1,2,3 or 1,5,7,9,11,1200. I want to
have a text box that would show the total of the items that they
selected and remove that item if they removed the check from the check
box.

 

[lilbit27]

yes it did thanks

Hi

Not really sure what it is you are looking for so you could place an unbound
text box in the form's footer or header and use something like this is as the
control source

= Sum ( IIf ([CheckBox]=-1, [FieldName])
or
= Count ( IIf ([CheckBox]=-1, [FieldName])
etc

Hope this helps

--
Wayne
Manchester, England.

Is there a way to create a calculator on a coninous form?

I have three amounts gross, commisson, and net. not based on what
they select I want to create a running total.

So say the checks (checkbox) line 1,2,3 or 1,5,7,9,11,1200. I want to
have a text box that would show the total of the items that they
selected and remove that item if they removed the check from the check
box.