Summing in a Report Footer

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

By public function, I mean you might be able to create your own function that
accepts some arguments and returns the calculated value. I don't know if this
is practical for you since you haven't shared what you mean by "one line
which is fed through VBA".

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

in the detail section of the report there is vba coding that checks the
contracthourscost table and returns all values for that particular contract.
some may have 25 entries, some over 50, but there is only one line in the
design view of the report in the detail section.



"Duane Hookom" wrote:

By public function, I mean you might be able to create your own function that
accepts some arguments and returns the calculated value. I don't know if this
is practical for you since you haven't shared what you mean by "one line
which is fed through VBA".

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

Thanks for the reply but it doesn't provide enough specifics or details to
provide any additional suggestions or support.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

in the detail section of the report there is vba coding that checks the
contracthourscost table and returns all values for that particular contract.
some may have 25 entries, some over 50, but there is only one line in the
design view of the report in the detail section.



"Duane Hookom" wrote:

By public function, I mean you might be able to create your own function that
accepts some arguments and returns the calculated value. I don't know if this
is practical for you since you haven't shared what you mean by "one line
which is fed through VBA".

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

Is there somewhere I could email you a screen print?

"Duane Hookom" wrote:

Thanks for the reply but it doesn't provide enough specifics or details to
provide any additional suggestions or support.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

in the detail section of the report there is vba coding that checks the
contracthourscost table and returns all values for that particular contract.
some may have 25 entries, some over 50, but there is only one line in the
design view of the report in the detail section.



"Duane Hookom" wrote:

By public function, I mean you might be able to create your own function that
accepts some arguments and returns the calculated value. I don't know if this
is practical for you since you haven't shared what you mean by "one line
which is fed through VBA".

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please

You could copy and paste your code and type in your comments.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Is there somewhere I could email you a screen print?

"Duane Hookom" wrote:

Thanks for the reply but it doesn't provide enough specifics or details to
provide any additional suggestions or support.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

in the detail section of the report there is vba coding that checks the
contracthourscost table and returns all values for that particular contract.
some may have 25 entries, some over 50, but there is only one line in the
design view of the report in the detail section.



"Duane Hookom" wrote:

By public function, I mean you might be able to create your own function that
accepts some arguments and returns the calculated value. I don't know if this
is practical for you since you haven't shared what you mean by "one line
which is fed through VBA".

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

Thanks for your response. I'm unfamiliar with the "public function"...Help

"Duane Hookom" wrote:

" there is no where to put the running sum in the body of the document" This
doesn't have to be visible. I would set the font color to red and make it
hidden.

I would first attempt to change the VBA to a public function so it could be
used in a simple Sum() text box in the Report Footer section.

--
Duane Hookom
Microsoft Access MVP


"Alberta Rose" wrote:

"Note When you set the RunningSum property to Over All, you can repeat the
grand total in the report footer (report footer: A report section that is
used to place information that normally appears at the bottom of the page,
such as page numbers, dates, and sums.). Create a text box in the report
footer and set its ControlSource property to the name of the text box that
calculates the running sum; for example, =[OrderAmount]."

I have a report that compiles cost code/cost type $$ in columns, there is no
where to put the running sum in the body of the document. The Detail section
of the report contains one line which is fed through VBA, so depending on the
contract number, the report pulls in all cost code/cost types with $$ in them
and lists them. In the report footer I have 2 txt boxes called Distributed
Cost Estimate and Distributed Cost Actual. What I need is to know how to get
Access to check the values in the Detail area and populate the sum's in
either of these two txt boxes, depending on which column they are in.

Help please