sum of a sum

T

Tina S

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
 
T

Tina S

I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

KARL DEWEY said:
Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


Tina S said:
In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
 
K

Klatuu

Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

KARL DEWEY said:
Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


Tina S said:
In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 
T

Tina S

I added the "SUM" and it still did not work.

What do you mean " You can't Sum on a report control, it has to be field or
combination of fields."?

Klatuu said:
Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

KARL DEWEY said:
Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


:

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 
K

Klatuu

I mean to work, [IDE_Total] and [ODE_TOTAL] have to be fields in the report's
record source. It will not work if they are the names of text boxes on the
report.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I added the "SUM" and it still did not work.

What do you mean " You can't Sum on a report control, it has to be field or
combination of fields."?

Klatuu said:
Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

:

Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


:

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 
T

Tina S

they are the names of 2 different text boxes in the details section of the
report.

Klatuu said:
I mean to work, [IDE_Total] and [ODE_TOTAL] have to be fields in the report's
record source. It will not work if they are the names of text boxes on the
report.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I added the "SUM" and it still did not work.

What do you mean " You can't Sum on a report control, it has to be field or
combination of fields."?

Klatuu said:
Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


:

I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

:

Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


:

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 
B

Bill Neilsen

Give this a try Tina
=([Text1]+[Text2])

Insert the text box names into the [brackets]

Tina S said:
they are the names of 2 different text boxes in the details section of the
report.

Klatuu said:
I mean to work, [IDE_Total] and [ODE_TOTAL] have to be fields in the report's
record source. It will not work if they are the names of text boxes on the
report.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I added the "SUM" and it still did not work.

What do you mean " You can't Sum on a report control, it has to be field or
combination of fields."?

:

Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


:

I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

:

Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


:

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 
K

Klatuu

To use a Sum, you have to use the names of fields in the form's recordset.
You can add text boxes, but you can't use Sum on text boxes.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
they are the names of 2 different text boxes in the details section of the
report.

Klatuu said:
I mean to work, [IDE_Total] and [ODE_TOTAL] have to be fields in the report's
record source. It will not work if they are the names of text boxes on the
report.
--
Dave Hargis, Microsoft Access MVP


Tina S said:
I added the "SUM" and it still did not work.

What do you mean " You can't Sum on a report control, it has to be field or
combination of fields."?

:

Actually, it should be:
=Sum([IDE_Total]+[ODE_TOTAL])

You can't Sum on a report control, it has to be field or combination of
fields.
--
Dave Hargis, Microsoft Access MVP


:

I tried this and it did not work. It gave me a result of zero. I did not
get the parameter box.

:

Try using =([IDE_Total]+[ODE_TOTAL]) and set textbox Running Sum to Over
All.
--
KARL DEWEY
Build a little - Test a little


:

In the Detail area of my report I have a text box Named "TOT_SEG" where the
control source is "=([IDE_Total]+[ODE_TOTAL])" and I receive the correct
information from this.
This is repeated about 20 times in the details.
In the Report Footer I want to add all of these together to get a grand
total. I cannot get thsi to work. I tried =SUM([TOT_SEG]) and when I go to
preview it, it asks me to enter a parameter value for TOT_SEG.

What am I doing wrong? What is the right "formula"?
Click to expand...
Click to expand...
Click to expand...
 

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

Similar Threads

Report Sums of Sums 1
Summing in a Report Footer 7
Running Sum 13
Total not correct in Footer 2
SynNeed to account for null values in subreports 2
Sum unique entries in report footer 2
RunningSum Problem 0
sum totals in report footer 3

Top