Can't total in footer

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

Guest

My report shows me the number of cross sales by CSR and then the branch total
in the footer. I can also see the total incentive pay by CSR but when I try
to total the pay in the footer by branch, it counts the rows. I'm confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
 
You can't sum controls such as text boxes. You can sum expressions based on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1
 
What is stored/displayed in the 'Text' fields is the answer to the formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item sold by
CSR, and total incentive pay for item sold by CSR (incentive pay is figured
by using the formula I gave you, total number of items sold * dollar value).

In the footer, I want to see the Branch total number of items sold. This is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows. This
is where I am lost at. I think it has something to do with the fact that I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section and then
by Branch in the footer work except for this one. But this is the only one
where I used a formula in the details and then tried to total it in the
footer. I hope this helps.


Duane Hookom said:
You can't sum controls such as text boxes. You can sum expressions based on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


Newbie said:
My report shows me the number of cross sales by CSR and then the branch
total
in the footer. I can also see the total incentive pay by CSR but when I
try
to total the pay in the footer by branch, it counts the rows. I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
 
Do you understand that you can't sum controls and Text35 is most likely a
control?

You would need to replace [Text35] with an expression based on your report's
fields. You haven't provided use with any information about the control
sources of Text35, Text37, or Text38. For instance, if Text35 has a control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

Newbie said:
What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold. This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows. This
is where I am lost at. I think it has something to do with the fact that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section and
then
by Branch in the footer work except for this one. But this is the only
one
where I used a formula in the details and then tried to total it in the
footer. I hope this helps.


Duane Hookom said:
You can't sum controls such as text boxes. You can sum expressions based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


Newbie said:
My report shows me the number of cross sales by CSR and then the branch
total
in the footer. I can also see the total incentive pay by CSR but when
I
try
to total the pay in the footer by branch, it counts the rows. I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
I'm sorry I can't seem to get this across correctly. The control source for
Text35 is the expression I gave you (qty * price). Then, to total for each
CSR, I used the following expression:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

In the footer, to try to get the total by branch, I used:
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

When I do this, it asks for a value for each field ([Text35, Text37 and
Text38). So if I type in '1' when it prompts for a value, I get the display
of 111. It won't take the total of each CSR and add them together.

Duane Hookom said:
Do you understand that you can't sum controls and Text35 is most likely a
control?

You would need to replace [Text35] with an expression based on your report's
fields. You haven't provided use with any information about the control
sources of Text35, Text37, or Text38. For instance, if Text35 has a control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

Newbie said:
What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold. This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows. This
is where I am lost at. I think it has something to do with the fact that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section and
then
by Branch in the footer work except for this one. But this is the only
one
where I used a formula in the details and then tried to total it in the
footer. I hope this helps.


Duane Hookom said:
You can't sum controls such as text boxes. You can sum expressions based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


My report shows me the number of cross sales by CSR and then the branch
total
in the footer. I can also see the total incentive pay by CSR but when
I
try
to total the pay in the footer by branch, it counts the rows. I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
I'm sorry that I can't explain any better that you "can't sum controls".

Where did you ever state "qty * price". Do you mean "total number of items
sold * dollar value"? If so, try
=sum(nz([total number of items sold] * [dollar
value],0)+nz([...],0)+nz([...],0))
You need to fill in the replacements for Text37 and Text38.

BTW: You really need to take the time to rename your controls.

--
Duane Hookom
MS Access MVP
--

Newbie said:
I'm sorry I can't seem to get this across correctly. The control source
for
Text35 is the expression I gave you (qty * price). Then, to total for
each
CSR, I used the following expression:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

In the footer, to try to get the total by branch, I used:
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

When I do this, it asks for a value for each field ([Text35, Text37 and
Text38). So if I type in '1' when it prompts for a value, I get the
display
of 111. It won't take the total of each CSR and add them together.

Duane Hookom said:
Do you understand that you can't sum controls and Text35 is most likely a
control?

You would need to replace [Text35] with an expression based on your
report's
fields. You haven't provided use with any information about the control
sources of Text35, Text37, or Text38. For instance, if Text35 has a
control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

Newbie said:
What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item
sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold.
This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows.
This
is where I am lost at. I think it has something to do with the fact
that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section and
then
by Branch in the footer work except for this one. But this is the only
one
where I used a formula in the details and then tried to total it in the
footer. I hope this helps.


:

You can't sum controls such as text boxes. You can sum expressions
based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


My report shows me the number of cross sales by CSR and then the
branch
total
in the footer. I can also see the total incentive pay by CSR but
when
I
try
to total the pay in the footer by branch, it counts the rows. I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
I understand you can't sum controls. Here's what I don't understand. In the
details of the report, I can see the amount of each item sold by CSR and the
total dollar value. When I try to total them in the footer, I can total the
items sold, but I can't total the dollar value.

I've tried the nz function and it didn't work. I used the same expression I
used to get the totals by CSR and put SUM in front of it, it just says
#error.

I'm sorry my controls have bad names but someone just loaded Access on my
PC, handed me a book and said 'write a database'. I have no training and my
book sucks!

Duane Hookom said:
I'm sorry that I can't explain any better that you "can't sum controls".

Where did you ever state "qty * price". Do you mean "total number of items
sold * dollar value"? If so, try
=sum(nz([total number of items sold] * [dollar
value],0)+nz([...],0)+nz([...],0))
You need to fill in the replacements for Text37 and Text38.

BTW: You really need to take the time to rename your controls.

--
Duane Hookom
MS Access MVP
--

Newbie said:
I'm sorry I can't seem to get this across correctly. The control source
for
Text35 is the expression I gave you (qty * price). Then, to total for
each
CSR, I used the following expression:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

In the footer, to try to get the total by branch, I used:
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

When I do this, it asks for a value for each field ([Text35, Text37 and
Text38). So if I type in '1' when it prompts for a value, I get the
display
of 111. It won't take the total of each CSR and add them together.

Duane Hookom said:
Do you understand that you can't sum controls and Text35 is most likely a
control?

You would need to replace [Text35] with an expression based on your
report's
fields. You haven't provided use with any information about the control
sources of Text35, Text37, or Text38. For instance, if Text35 has a
control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item
sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold.
This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows.
This
is where I am lost at. I think it has something to do with the fact
that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section and
then
by Branch in the footer work except for this one. But this is the only
one
where I used a formula in the details and then tried to total it in the
footer. I hope this helps.


:

You can't sum controls such as text boxes. You can sum expressions
based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


My report shows me the number of cross sales by CSR and then the
branch
total
in the footer. I can also see the total incentive pay by CSR but
when
I
try
to total the pay in the footer by branch, it counts the rows. I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Are you seeing totals/sums in group footers? This is what is suggested when
you state "amount of each item sold by CSR". Is each CSR in the detail
section or in a footer for CSR?

What are the significant fields in your report's record source?
What are the control sources of text35, text37, and text38?


--
Duane Hookom
MS Access MVP


Newbie said:
I understand you can't sum controls. Here's what I don't understand. In
the
details of the report, I can see the amount of each item sold by CSR and
the
total dollar value. When I try to total them in the footer, I can total
the
items sold, but I can't total the dollar value.

I've tried the nz function and it didn't work. I used the same expression
I
used to get the totals by CSR and put SUM in front of it, it just says
#error.

I'm sorry my controls have bad names but someone just loaded Access on my
PC, handed me a book and said 'write a database'. I have no training and
my
book sucks!

Duane Hookom said:
I'm sorry that I can't explain any better that you "can't sum controls".

Where did you ever state "qty * price". Do you mean "total number of
items
sold * dollar value"? If so, try
=sum(nz([total number of items sold] * [dollar
value],0)+nz([...],0)+nz([...],0))
You need to fill in the replacements for Text37 and Text38.

BTW: You really need to take the time to rename your controls.

--
Duane Hookom
MS Access MVP
--

Newbie said:
I'm sorry I can't seem to get this across correctly. The control
source
for
Text35 is the expression I gave you (qty * price). Then, to total for
each
CSR, I used the following expression:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

In the footer, to try to get the total by branch, I used:
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

When I do this, it asks for a value for each field ([Text35, Text37 and
Text38). So if I type in '1' when it prompts for a value, I get the
display
of 111. It won't take the total of each CSR and add them together.

:

Do you understand that you can't sum controls and Text35 is most
likely a
control?

You would need to replace [Text35] with an expression based on your
report's
fields. You haven't provided use with any information about the
control
sources of Text35, Text37, or Text38. For instance, if Text35 has a
control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item
sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold.
This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows.
This
is where I am lost at. I think it has something to do with the fact
that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section
and
then
by Branch in the footer work except for this one. But this is the
only
one
where I used a formula in the details and then tried to total it in
the
footer. I hope this helps.


:

You can't sum controls such as text boxes. You can sum expressions
based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


My report shows me the number of cross sales by CSR and then the
branch
total
in the footer. I can also see the total incentive pay by CSR but
when
I
try
to total the pay in the footer by branch, it counts the rows.
I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
BTW: is your #error text box in the Report Footer or Page Footer? Page
Footer won't work.

--
Duane Hookom
MS Access MVP


Newbie said:
I understand you can't sum controls. Here's what I don't understand. In
the
details of the report, I can see the amount of each item sold by CSR and
the
total dollar value. When I try to total them in the footer, I can total
the
items sold, but I can't total the dollar value.

I've tried the nz function and it didn't work. I used the same expression
I
used to get the totals by CSR and put SUM in front of it, it just says
#error.

I'm sorry my controls have bad names but someone just loaded Access on my
PC, handed me a book and said 'write a database'. I have no training and
my
book sucks!

Duane Hookom said:
I'm sorry that I can't explain any better that you "can't sum controls".

Where did you ever state "qty * price". Do you mean "total number of
items
sold * dollar value"? If so, try
=sum(nz([total number of items sold] * [dollar
value],0)+nz([...],0)+nz([...],0))
You need to fill in the replacements for Text37 and Text38.

BTW: You really need to take the time to rename your controls.

--
Duane Hookom
MS Access MVP
--

Newbie said:
I'm sorry I can't seem to get this across correctly. The control
source
for
Text35 is the expression I gave you (qty * price). Then, to total for
each
CSR, I used the following expression:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

In the footer, to try to get the total by branch, I used:
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

When I do this, it asks for a value for each field ([Text35, Text37 and
Text38). So if I type in '1' when it prompts for a value, I get the
display
of 111. It won't take the total of each CSR and add them together.

:

Do you understand that you can't sum controls and Text35 is most
likely a
control?

You would need to replace [Text35] with an expression based on your
report's
fields. You haven't provided use with any information about the
control
sources of Text35, Text37, or Text38. For instance, if Text35 has a
control
source of =[Qty] * [Price] then you could use something like:

=Sum(Nz([Qty]*[Price],0) + ... + ...)

--
Duane Hookom
MS Access MVP
--

What is stored/displayed in the 'Text' fields is the answer to the
formula.
Here's what I have:

In the details of my report, it shows me the CSR name, total of item
sold
by
CSR, and total incentive pay for item sold by CSR (incentive pay is
figured
by using the formula I gave you, total number of items sold * dollar
value).

In the footer, I want to see the Branch total number of items sold.
This
is
done by adding all the CSR totals together. I can get that to work.

When I try to total the incentive pay by Branch, it counts the rows.
This
is where I am lost at. I think it has something to do with the fact
that
I
am trying to add unbound text boxes with formulas.

All my other reports I have that show by CSR in the details section
and
then
by Branch in the footer work except for this one. But this is the
only
one
where I used a formula in the details and then tried to total it in
the
footer. I hope this helps.


:

You can't sum controls such as text boxes. You can sum expressions
based
on
fields from your report's record source.

I have no idea:
-what might be stored/displayed in Text35, Text37, or Text38
-what you mean by [text] formula=[CountOfField]*1

--
Duane Hookom
MS Access MVP


My report shows me the number of cross sales by CSR and then the
branch
total
in the footer. I can also see the total incentive pay by CSR but
when
I
try
to total the pay in the footer by branch, it counts the rows.
I'm
confused.
Here's my formulas:

Total Incentive by CSR (this works)
=(nz([Text35],0)+nz([Text37],0)+nz([Text38],0))

Total Incentive by Branch (this doesn'twork)
=sum(nz([Text35],0)+nz([Text37],0)+nz([Text38],0)

FYI
[text] formula =[CountOfField]*1

Any ideas?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top