Calculation in a Text Box

I have a text box on the footer of my form. The control source is as
follows:

=Sum(Abs([Department]="Vocational"))

That text box calculates a number for me. Now what I want to do is take that
number and divide it by another number, we'll say 6 and have that show up in
a new text box. So what would the control source of the new text box be? I
want it to show "=Sum(Abs([Department]="Vocational"))" divided by 6. Is
there an easy way to do this?

Thanks,

CEV

You did not say where the new textbox was going to be. Is it also to be in
the Footer?
If so then it is easy as --
=Sum(Abs([Department]="Vocational"))/6

If it is to be somewhere else then it depend where.

--
KARL DEWEY
Build a little - Test a little


"CEV" wrote:

I have a text box on the footer of my form. The control source is as
follows:

=Sum(Abs([Department]="Vocational"))

That text box calculates a number for me. Now what I want to do is take that
number and divide it by another number, we'll say 6 and have that show up in
a new text box. So what would the control source of the new text box be? I
want it to show "=Sum(Abs([Department]="Vocational"))" divided by 6. Is
there an easy way to do this?

Thanks,

CEV

Thanks!!! It is in the footer.

"KARL DEWEY" wrote in message
...
You did not say where the new textbox was going to be. Is it also to be in
the Footer?
If so then it is easy as --
=Sum(Abs([Department]="Vocational"))/6

If it is to be somewhere else then it depend where.

--
KARL DEWEY
Build a little - Test a little


"CEV" wrote:

I have a text box on the footer of my form. The control source is as
follows:

=Sum(Abs([Department]="Vocational"))

That text box calculates a number for me. Now what I want to do is take
that
number and divide it by another number, we'll say 6 and have that show up
in
a new text box. So what would the control source of the new text box be?
I
want it to show "=Sum(Abs([Department]="Vocational"))" divided by 6. Is
there an easy way to do this?

Thanks,

CEV

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.