Formula

[JL Wright]

I have two fields:
1. Gross
2. FICA

FICA is 6.2%

Could someone help with that formula? I am assuming that I write the
formula in the Control Source of the FICA field on the form .

I did a searh but could not find exactly what I need.

 

[KARL DEWEY]

I am assuming that I write the formula in the Control Source of the FICA
field on the form .
Did you try it? Why not?

What are you trying to accomplish? You say you have two field, one named
FICA, and FICA - 6.2%. If the records have that data in the field then why
do you need a formula?

Control Source is for a text box - the field to which it is bound.
What did you search for?

 

[JL Wright]

Let me re-write the question. I have a table named tblSalary. The table has
several what I call fields. One field is named Gross and the other FICA.

I also have a form name frmSalary. Gross and FICA is on that form. I would
like for FICA to figure the amount if FICA is 6.2%.

Now that I am thinking about it, do I need FICA in the table or do I just
need to create an unbound text box in frmSalary and name it FICA to get the
desired amount?

In other words, if a person’s salary is $1,500, I need to figure out 6.2% of
that.

 

[KARL DEWEY]

In the properties for your Gross textbox on the form you need an AfterUpdate
event to SetValue FICA = ([Gross] * .062)

 

[JL Wright]

That did it, thank you so much.