Summing in a Report Footer

A

Alberta Rose

"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 :)
 
D

Duane Hookom

" 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.
 
A

Alberta Rose

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

Duane Hookom said:
" 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 said:
"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 :)
 
D

Duane Hookom

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 said:
Thanks for your response. I'm unfamiliar with the "public function"...Help :)

Duane Hookom said:
" 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 said:
"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 :)
 
A

Alberta Rose

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 said:
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 said:
Thanks for your response. I'm unfamiliar with the "public function"...Help :)

Duane Hookom said:
" 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


:

"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 :)
 
D

Duane Hookom

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 said:
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 said:
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 said:
Thanks for your response. I'm unfamiliar with the "public function"...Help :)

:

" 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


:

"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 :)
 
A

Alberta Rose

Is there somewhere I could email you a screen print?

Duane Hookom said:
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 said:
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 said:
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


:

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

:

" 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


:

"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 :)
 
D

Duane Hookom

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

--
Duane Hookom
Microsoft Access MVP


Alberta Rose said:
Is there somewhere I could email you a screen print?

Duane Hookom said:
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 said:
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.



:

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


:

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

:

" 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


:

"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 :)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top