Re: Adding two subtotals from two subreports in a main report

Once I try putting the brackets around them and go to view the report it
comes up with a box saying to enter parameter value for LABOUR R.

"Duane Hookom" wrote:

Either remove the spaces from your object names (my preference) or place
brackets around them.

=[LABOUR R].Report![LABOUR SUBTOTAL] + [PARTS R].Report![PARTS SUBTOTAL]

--
Duane Hookom
MS Access MVP


"Renee" <Renee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:BD31AEBD-C146-4ED1-BBB5-376F0398C820@xxxxxxxxxxxxxxxx
So I put that control source in and once I press tab to get to the next
field
it gives an error: The expression you entered contains invalid syntax. You
may have entered and operand without and operator. This is what I typed
in:
=[LABOUR R].Report!LABOUR SUBTOTAL + [PARTS R].Report!PARTS SUBTOTAL

So my subreport names are LABOUR R & PARTS R the subtotal fields are
called
LABOUR SUBTOTAL & PARTS SUBTOTAL


"Duane Hookom" wrote:

If both subreports
- are in the same report section and
- will always contain records and
- they have a text box named "txtRptTotal" containg the subtotals
You can create a text box in the main report with a control source like:

=[SWO R].Report!txtRptTotal + [LABOUR R].Report!txtRptTotal

If you don't find success, come back with some real values for us.
--
Duane Hookom
MS Access MVP

"Renee" <Renee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CAB1C48-B8E5-4349-BE26-39118A21AC60@xxxxxxxxxxxxxxxx
I have a report called SWO R that has two subreports in it called LABOUR
R
and PARTS R. Both of these subreports have subtotals in them created
using
a
text box and I would like to add the two subtotals together in the main
report but I can't seem to get it to work. Does anyone have any ideas
of
how
I can do this?






.

Relevant Pages

  • Re: Adding two subtotals from two subreports in a main report
    ... "Duane Hookom" wrote: ... the subreport but this is not always true. ... comes up with a box saying to enter parameter value for LABOUR R. ... they have a text box named "txtRptTotal" containg the subtotals ...
    (microsoft.public.access.reports)
  • Re: Adding two subtotals from two subreports in a main report
    ... MS Access MVP ... "Duane Hookom" wrote: ... they have a text box named "txtRptTotal" containg the subtotals ... You can create a text box in the main report with a control source like: ...
    (microsoft.public.access.reports)
  • Re: Adding two subtotals from two subreports in a main report
    ... Make sure that your subreport control name (not necessarily the subreport ... comes up with a box saying to enter parameter value for LABOUR R. ... "Duane Hookom" wrote: ... they have a text box named "txtRptTotal" containg the subtotals ...
    (microsoft.public.access.reports)
  • Re: how do I add subtotals from multiple subreports on my main report
    ... Duane Hookom ... MS Access MVP ... >I have a main report with 3 subreports and I want to add all subtotals ... > together at the bottom of my main report. ...
    (microsoft.public.access.reports)
  • Re: Calculated Field
    ... If so, when you view the query itself, you will see that the Labour field ... If you want to do it in the report, presumably you have used the Sorting And ... It's also easier to get the totals, since all costs are in the one table. ...
    (microsoft.public.access.reports)