Calculation in a Text Box

C

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
 
K

KARL DEWEY

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.
 
C

CEV

Thanks!!! It is in the footer.

KARL DEWEY said:
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 said:
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
 
W

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top