Tubes

  • Thread starter Thread starter Matti Koski
  • Start date Start date
M

Matti Koski

Hi Group,

I have a form which has fields for total of tubes, tube white (Yes/No), tube red (Yes/No) , tube green (Yes/No), tube blue (Yes/No), Back up tube 1 (Yes/No) and Back up tube 2 (Yes/No). The data entry will mark each tube Yes or No. How can I calculate the total of tubes automatically ? I would like to have a function to do that.

Thanks,

Matti
 
Matti,

Create a textbox on a form and in the control source of the text box place
something like :
=abs([field1]+[field2]+[field3])
Insert your field names in the field 1,2 ect.
 
On Thu, 18 Sep 2008 12:11:35 +0300, "Matti Koski"

In TotalTubes, set the ControlSource to be:
=TubeWhite + TubeRed + TubeGreen ... etc.

That will give you -6 if all are checked.
I'm sure you can figure out how to make that +6.

-Tom.
Microsoft Access MVP
 
Back
Top