calculating value from other footers. Dsum?

Could you help me. I have a sub form that has a "modifacation amount" for
several records. How can I subtotal each of those to a Total field on the
main form? Please let me know if you can help before I lose all my hair.
Thanks,
Barb.

"Duane Hookom" wrote:

You can do this with an expression like:
=Sum( Abs([Region] ="Southwest" OR [Region]="West") * [Field you want to
Sum] )

--
Duane Hookom
MS Access MVP
--

"Matt" wrote in message
...
I have built a report that calculates the number of lines, monthly revenue
and contract value for each of our regions (Southwest, Midwest, West, &
East). I have the report grouped by region so I have subtotals for each
region, and then a combined total at the bottom of the report for all
sales.
What I would like to do is below the combined totals, add a field that
calculates what the total is for the Southwest region plus the West
region,
but do not include the Midwest and east. Is this possible in a report?

Total the records in a form footer of the subform. Then add a text box on
the main form with a control source like:
=sfrmControl.Form.txtTotal

--
Duane Hookom
MS Access MVP


"Barb" wrote in message
...
Could you help me. I have a sub form that has a "modifacation amount" for
several records. How can I subtotal each of those to a Total field on the
main form? Please let me know if you can help before I lose all my hair.
Thanks,
Barb.

"Duane Hookom" wrote:

You can do this with an expression like:
=Sum( Abs([Region] ="Southwest" OR [Region]="West") * [Field you want to
Sum] )

--
Duane Hookom
MS Access MVP
--

"Matt" wrote in message
...
I have built a report that calculates the number of lines, monthly
revenue
and contract value for each of our regions (Southwest, Midwest, West, &
East). I have the report grouped by region so I have subtotals for
each
region, and then a combined total at the bottom of the report for all
sales.
What I would like to do is below the combined totals, add a field that
calculates what the total is for the Southwest region plus the West
region,
but do not include the Midwest and east. Is this possible in a report?

Will this add up all the $ enteries in the subform and give me a total on my
main form? How do I format the expression? Sorry I am not very savy in this
stuff.

"Duane Hookom" wrote:

Total the records in a form footer of the subform. Then add a text box on
the main form with a control source like:
=sfrmControl.Form.txtTotal

--
Duane Hookom
MS Access MVP


"Barb" wrote in message
...
Could you help me. I have a sub form that has a "modifacation amount" for
several records. How can I subtotal each of those to a Total field on the
main form? Please let me know if you can help before I lose all my hair.
Thanks,
Barb.

"Duane Hookom" wrote:

You can do this with an expression like:
=Sum( Abs([Region] ="Southwest" OR [Region]="West") * [Field you want to
Sum] )

--
Duane Hookom
MS Access MVP
--

"Matt" wrote in message
...
I have built a report that calculates the number of lines, monthly
revenue
and contract value for each of our regions (Southwest, Midwest, West, &
East). I have the report grouped by region so I have subtotals for
each
region, and then a combined total at the bottom of the report for all
sales.
What I would like to do is below the combined totals, add a field that
calculates what the total is for the Southwest region plus the West
region,
but do not include the Midwest and east. Is this possible in a report?

To find out if this will "add up all the $ enteries in the subform and give
me a total on my main form", you should try it.

You should be able to format this text box like you would format any other
text box.

--
Duane Hookom
MS Access MVP
--

"Barb" wrote in message
...
Will this add up all the $ enteries in the subform and give me a total on
my
main form? How do I format the expression? Sorry I am not very savy in
this
stuff.

"Duane Hookom" wrote:

Total the records in a form footer of the subform. Then add a text box on
the main form with a control source like:
=sfrmControl.Form.txtTotal

--
Duane Hookom
MS Access MVP


"Barb" wrote in message
...
Could you help me. I have a sub form that has a "modifacation amount"
for
several records. How can I subtotal each of those to a Total field on
the
main form? Please let me know if you can help before I lose all my
hair.
Thanks,
Barb.

"Duane Hookom" wrote:

You can do this with an expression like:
=Sum( Abs([Region] ="Southwest" OR [Region]="West") * [Field you want
to
Sum] )

--
Duane Hookom
MS Access MVP
--

"Matt" wrote in message
...
I have built a report that calculates the number of lines, monthly
revenue
and contract value for each of our regions (Southwest, Midwest,
West, &
East). I have the report grouped by region so I have subtotals for
each
region, and then a combined total at the bottom of the report for
all
sales.
What I would like to do is below the combined totals, add a field
that
calculates what the total is for the Southwest region plus the West
region,
but do not include the Midwest and east. Is this possible in a
report?