Calculating text boxes

[Bill Neilsen]

I'm running a report on how to split up the fee for a band.
Because all members of the band aren't equal (eg road crew work on a fixed
fee) I have a code allocated to each member.
Members
Crew
Agent
In my query I have calculated a subtotal after the fixed fees are taken out
and I now want to divide the remainder up amongst the Members equally.
In my report I now have a field [FeeSubtotal] and a calculating text box
called Text 27 with the control source =-Sum(

="Member")

As an example, when I run the report the field show FeeSubtotal $5170 and
the Text box showing 4 members. I now need to divide the subtotal by the
number of members ie $5170/4

My problem is this - I am trying to calculate the share amongst the members
by using another text box with the control source
=Sum([FeeSubtotal])/([Code]="Member")
I have even tried to use the build event wizard and came up with the control
source of =Sum([FeeSubtotal])/[Text27]

None of which seem to work.
Can anyone guide me on the correct method please.

Thanks in advance.

 

[Marshall Barton]

I'm running a report on how to split up the fee for a band.
Because all members of the band aren't equal (eg road crew work on a fixed
fee) I have a code allocated to each member.
Members
Crew
Agent
In my query I have calculated a subtotal after the fixed fees are taken out
and I now want to divide the remainder up amongst the Members equally.
In my report I now have a field [FeeSubtotal] and a calculating text box
called Text 27 with the control source =-Sum(

="Member")

As an example, when I run the report the field show FeeSubtotal $5170 and
the Text box showing 4 members. I now need to divide the subtotal by the
number of members ie $5170/4

My problem is this - I am trying to calculate the share amongst the members
by using another text box with the control source
=Sum([FeeSubtotal])/([Code]="Member")
I have even tried to use the build event wizard and came up with the control
source of =Sum([FeeSubtotal])/[Text27][/QUOTE]


Since the FeeSubtotal field has been calculated in the
query, I don't see why you are trying to sum it in the
report.  Why doesn't the expression:
=[FeeSubtotal] / [Text27]
provide the desired result?

 

[Bill Neilsen]

Thanks Marsh, such a simple solution.
Sometimes I can't see the forrest for the trees.
I appreciate your help.

I'm running a report on how to split up the fee for a band.
Because all members of the band aren't equal (eg road crew work on a fixed
fee) I have a code allocated to each member.
Members
Crew
Agent
In my query I have calculated a subtotal after the fixed fees are taken out
and I now want to divide the remainder up amongst the Members equally.
In my report I now have a field [FeeSubtotal] and a calculating text box
called Text 27 with the control source =-Sum(

="Member")

As an example, when I run the report the field show FeeSubtotal $5170 and
the Text box showing 4 members. I now need to divide the subtotal by the
number of members ie $5170/4

My problem is this - I am trying to calculate the share amongst the members
by using another text box with the control source
=Sum([FeeSubtotal])/([Code]="Member")
I have even tried to use the build event wizard and came up with the control
source of =Sum([FeeSubtotal])/[Text27][/QUOTE]


Since the FeeSubtotal field has been calculated in the
query, I don't see why you are trying to sum it in the
report.  Why doesn't the expression:
	=[FeeSubtotal] / [Text27]
provide the desired result?
[/QUOTE]