Formula on Main Report Using a Field from Subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two fields on a subreport named HRSWKD & TTLRPCS. I have one field on
my main report named RPCS. All of these are in the detail section. My
formula on my main report needs to be:

=(RPCS/TTLRPCS)*HRSWKD

but I do not know how to format it correctly. If someone could help me it
would be most appreciated.
 
Brent said:
I have two fields on a subreport named HRSWKD & TTLRPCS. I have one field on
my main report named RPCS. All of these are in the detail section. My
formula on my main report needs to be:

=(RPCS/TTLRPCS)*HRSWKD

but I do not know how to format it correctly. If someone could help me it
would be most appreciated.
Click to expand...


The way to refer to the value of the HRSWKD control in a
subreport is:

subreportcontrolname.Report.HRSWKD
 
When I put:

ARLSetterAgentSubreport.Report.TTLRPCS

It asks me for parameter values.


Marshall Barton said:
Not without some more clues. At least explain what you mean
by "not working".
--
Marsh
MVP [MS Access]

For some reason this is not working for me. Any idea why???
Click to expand...
Click to expand...
 
That means you used the wrong or a misspelled name for the
subreport control or the control in the subreport. It could
also mean you forgot the = sign.
 
OK. When I look at the properties for the subreport the Source Object is:

Report.ARLSetterAgentSubreport

I put:

=ARLSetterAgentSubreport.Report.TTLRPCS

as the control source for my text box. TTLRPCS is the name of the text box
That means you used the wrong or a misspelled name for the
subreport control or the control in the subreport. It could
also mean you forgot the = sign.
--
Marsh
MVP [MS Access]


When I put:

ARLSetterAgentSubreport.Report.TTLRPCS

It asks me for parameter values.
Click to expand...
Click to expand...
 
It would have helped you had posted the parameter it's
prompting for. It's probably prompting for
ARLSetterAgentSubreport
which you said is the subreport control's SourceObject
property.

You need to use the subreport control's Name property.
They're often the same, but not always.
 
I should have known that. I don't think I have ever changed the name of a
subreport but in this case I did. I knew it was something simple I was
overlooking. Thank you for taking time to help me.

Marshall Barton said:
It would have helped you had posted the parameter it's
prompting for. It's probably prompting for
ARLSetterAgentSubreport
which you said is the subreport control's SourceObject
property.

You need to use the subreport control's Name property.
They're often the same, but not always.
--
Marsh
MVP [MS Access]


OK. When I look at the properties for the subreport the Source Object is:

Report.ARLSetterAgentSubreport

I put:

=ARLSetterAgentSubreport.Report.TTLRPCS

as the control source for my text box. TTLRPCS is the name of the text box
Click to expand...
Click to expand...
 
Back
Top