Calculation in a Text Box

[CEV]

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

 

[Guest]

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.

 

[CEV]

Thanks!!! It is in the footer.

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

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

 

[Wei Lu [MSFT]]

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.