Grand Totals

G

Guest

I have created a report that prints out customer invoices and totals their
cost in a field called CustTotalCost. I am wanting to get grand totals for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it to
calculate a GrandTotal for all the customers. This would give us the total
monthly invoice amount.

I have tried creating a text box that in the control source box I have used
=Sum([CustTotalCost]) but it displays nothing - not even an error message. I
thought this would be simple straight forward thinking but obviously not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an unbound
control in the Report footer.
 
G

Guest

The control source for the monthly total for a customer is [CustTotalCost].
I created a text box in the report footer and put only that in the control
source of the new unbound box and it gives the total of the last customer
only not a grand total. Did I do what you were saying correctly or am I
missing something else?

Thanks
Curt

Lynn Trapp said:
You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
I have created a report that prints out customer invoices and totals their
cost in a field called CustTotalCost. I am wanting to get grand totals
for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it to
calculate a GrandTotal for all the customers. This would give us the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error message.
I
thought this would be simple straight forward thinking but obviously not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the control
source of the new unbound box and it gives the total of the last customer
only not a grand total. Did I do what you were saying correctly or am I
missing something else?

Thanks
Curt

Lynn Trapp said:
You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
I have created a report that prints out customer invoices and totals
their
cost in a field called CustTotalCost. I am wanting to get grand totals
for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it to
calculate a GrandTotal for all the customers. This would give us the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Larry Linson

Let me guess... "CustTotalCost" is a Calculated Control on the report. You
can't use Sum on Calculated Controls.

If what you want to sum is a calculation of "NoOrdered*UnitCost", you can
put Sum([NoOrdered]*[UnitCost]), where NoOrdered and UnitCost are Fields in
the underlying RecordSource.

Possibly the misunderstanding came from the fact that the documentation will
talk about using Fields in Calculated Controls, and many people refer to the
Controls as "Fields". Fields in Tables and Queries contain data, but
information is displayed on Forms and Reports in Controls.

Larry Linson
Microsoft Access MVP
 
G

Guest

No. [CustTotalCost] is a calculated field in the footer of the report. (The
report is divided by Customer) However, in the report footer it will
calculate TotalHaulingCost for all customer and TotalLaborCharge for all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

Lynn Trapp said:
is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the control
source of the new unbound box and it gives the total of the last customer
only not a grand total. Did I do what you were saying correctly or am I
missing something else?

Thanks
Curt

Lynn Trapp said:
You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


I have created a report that prints out customer invoices and totals
their
cost in a field called CustTotalCost. I am wanting to get grand totals
for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it to
calculate a GrandTotal for all the customers. This would give us the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
G

Guest

CustTotalCost is a calculated control on the report. The report is segmented
so each customer has its own page (invoice). The last page of the report is
supposed to calculated GrandTotals for HaulingCost, LaborCost, etc. (for
company records) and it does that perfectly but a GrandTotal of all the cost
is where the problems lays. It only shows the last customer's monthly bill.
Not sure how to rectify.
Thanks for your attention
Curt Wedbush

Larry Linson said:
Let me guess... "CustTotalCost" is a Calculated Control on the report. You
can't use Sum on Calculated Controls.

If what you want to sum is a calculation of "NoOrdered*UnitCost", you can
put Sum([NoOrdered]*[UnitCost]), where NoOrdered and UnitCost are Fields in
the underlying RecordSource.

Possibly the misunderstanding came from the fact that the documentation will
talk about using Fields in Calculated Controls, and many people refer to the
Controls as "Fields". Fields in Tables and Queries contain data, but
information is displayed on Forms and Reports in Controls.

Larry Linson
Microsoft Access MVP

Curt Wedbush said:
I have created a report that prints out customer invoices and totals their
cost in a field called CustTotalCost. I am wanting to get grand totals for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it to
calculate a GrandTotal for all the customers. This would give us the total
monthly invoice amount.

I have tried creating a text box that in the control source box I have used
=Sum([CustTotalCost]) but it displays nothing - not even an error message. I
thought this would be simple straight forward thinking but obviously not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

What is the control source for [TotalHaulingCost] and [TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
No. [CustTotalCost] is a calculated field in the footer of the report.
(The
report is divided by Customer) However, in the report footer it will
calculate TotalHaulingCost for all customer and TotalLaborCharge for all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

Lynn Trapp said:
is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly or am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and totals
their
cost in a field called CustTotalCost. I am wanting to get grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it
to
calculate a GrandTotal for all the customers. This would give us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
G

Guest

The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and it works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
Lynn Trapp said:
What is the control source for [TotalHaulingCost] and [TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
No. [CustTotalCost] is a calculated field in the footer of the report.
(The
report is divided by Customer) However, in the report footer it will
calculate TotalHaulingCost for all customer and TotalLaborCharge for all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

Lynn Trapp said:
is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly or am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report. Open the
report in Design view and see what the control source is for the field
[CustTotalCost]. Place the same thing in the control source of an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and totals
their
cost in a field called CustTotalCost. I am wanting to get grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields (Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get it
to
calculate a GrandTotal for all the customers. This would give us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum ([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
Lynn Trapp said:
What is the control source for [TotalHaulingCost] and [TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
No. [CustTotalCost] is a calculated field in the footer of the report.
(The
report is divided by Customer) However, in the report footer it will
calculate TotalHaulingCost for all customer and TotalLaborCharge for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report. Open
the
report in Design view and see what the control source is for the
field
[CustTotalCost]. Place the same thing in the control source of an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and
totals
their
cost in a field called CustTotalCost. I am wanting to get grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get
it
to
calculate a GrandTotal for all the customers. This would give us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
G

Guest

The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of HaulingCost]

But the CustTotalCost is the page footer and is a total of each customer
(their monthly bill). That works fine. What I am trying to do is get a
total of all the customers invoices for a grand total that is located in the
report footer.

Thank you for your attention
Curt Wedbush
Lynn Trapp said:
If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum ([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
Lynn Trapp said:
What is the control source for [TotalHaulingCost] and [TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


No. [CustTotalCost] is a calculated field in the footer of the report.
(The
report is divided by Customer) However, in the report footer it will
calculate TotalHaulingCost for all customer and TotalLaborCharge for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report. Open
the
report in Design view and see what the control source is for the
field
[CustTotalCost]. Place the same thing in the control source of an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and
totals
their
cost in a field called CustTotalCost. I am wanting to get grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't get
it
to
calculate a GrandTotal for all the customers. This would give us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

Ok,
Let's go back to square one. The control source for a calculated value in
any of the section footers, including the report footer, must be the
calculation of a field that is in the Record Source of the report.
Therefore, if you have a field called [LaborCharge] in the Record source of
your report, to get the total of that in any of the footers you have to put
=Sum([LaborCharge]) in the control source of the control that will display
the sum. If you want the calculation of 2 fields in a footer (say
[LaborCharge] and [HaulingCost]), then you need to put =Sum([LaborCharge]) +
Sum([HaulingCost]) in the control source of your control.

Do you have a field in the Record Source of your report called [Sum of
LaborCharge] and one called [Sum of HaulingCost]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of
HaulingCost]

But the CustTotalCost is the page footer and is a total of each customer
(their monthly bill). That works fine. What I am trying to do is get a
total of all the customers invoices for a grand total that is located in
the
report footer.

Thank you for your attention
Curt Wedbush
Lynn Trapp said:
If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum
([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
:

What is the control source for [TotalHaulingCost] and
[TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
No. [CustTotalCost] is a calculated field in the footer of the
report.
(The
report is divided by Customer) However, in the report footer it
will
calculate TotalHaulingCost for all customer and TotalLaborCharge for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in
the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly
or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report.
Open
the
report in Design view and see what the control source is for the
field
[CustTotalCost]. Place the same thing in the control source of
an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and
totals
their
cost in a field called CustTotalCost. I am wanting to get
grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't
get
it
to
calculate a GrandTotal for all the customers. This would give
us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source
box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an
error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
G

Guest

OK, let me go back to the starting point. The report I am working on is
based on a query. So in the query I must have a field that calculates the
HaulingCost and another one that calculates the LaborCharge. If I call those
SumHaulingCost and SumLaborCharge, then I need another field in the query
that calculates the sum of each of these called TotalCost (or whatever I what
to call it). If I do this, then I can put this new field [TotalCost] in the
report footer and that would calculate everything? correct?

Thanks
Curt Wedbush

Lynn Trapp said:
Ok,
Let's go back to square one. The control source for a calculated value in
any of the section footers, including the report footer, must be the
calculation of a field that is in the Record Source of the report.
Therefore, if you have a field called [LaborCharge] in the Record source of
your report, to get the total of that in any of the footers you have to put
=Sum([LaborCharge]) in the control source of the control that will display
the sum. If you want the calculation of 2 fields in a footer (say
[LaborCharge] and [HaulingCost]), then you need to put =Sum([LaborCharge]) +
Sum([HaulingCost]) in the control source of your control.

Do you have a field in the Record Source of your report called [Sum of
LaborCharge] and one called [Sum of HaulingCost]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of
HaulingCost]

But the CustTotalCost is the page footer and is a total of each customer
(their monthly bill). That works fine. What I am trying to do is get a
total of all the customers invoices for a grand total that is located in
the
report footer.

Thank you for your attention
Curt Wedbush
Lynn Trapp said:
If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum
([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
:

What is the control source for [TotalHaulingCost] and
[TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
No. [CustTotalCost] is a calculated field in the footer of the
report.
(The
report is divided by Customer) However, in the report footer it
will
calculate TotalHaulingCost for all customer and TotalLaborCharge for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in
the
control
source of the new unbound box and it gives the total of the last
customer
only not a grand total. Did I do what you were saying correctly
or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report.
Open
the
report in Design view and see what the control source is for the
field
[CustTotalCost]. Place the same thing in the control source of
an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
I have created a report that prints out customer invoices and
totals
their
cost in a field called CustTotalCost. I am wanting to get
grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I can't
get
it
to
calculate a GrandTotal for all the customers. This would give
us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source
box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an
error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

No, if you have a HaulingCost field and a LaborCharge field in your query,
then you should be able to simply add the following to an unbound control in
your report footer:

=Sum([HaulingCost] + Sum([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
OK, let me go back to the starting point. The report I am working on is
based on a query. So in the query I must have a field that calculates the
HaulingCost and another one that calculates the LaborCharge. If I call
those
SumHaulingCost and SumLaborCharge, then I need another field in the query
that calculates the sum of each of these called TotalCost (or whatever I
what
to call it). If I do this, then I can put this new field [TotalCost] in
the
report footer and that would calculate everything? correct?

Thanks
Curt Wedbush

Lynn Trapp said:
Ok,
Let's go back to square one. The control source for a calculated value
in
any of the section footers, including the report footer, must be the
calculation of a field that is in the Record Source of the report.
Therefore, if you have a field called [LaborCharge] in the Record source
of
your report, to get the total of that in any of the footers you have to
put
=Sum([LaborCharge]) in the control source of the control that will
display
the sum. If you want the calculation of 2 fields in a footer (say
[LaborCharge] and [HaulingCost]), then you need to put
=Sum([LaborCharge]) +
Sum([HaulingCost]) in the control source of your control.

Do you have a field in the Record Source of your report called [Sum of
LaborCharge] and one called [Sum of HaulingCost]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of
HaulingCost]

But the CustTotalCost is the page footer and is a total of each
customer
(their monthly bill). That works fine. What I am trying to do is get
a
total of all the customers invoices for a grand total that is located
in
the
report footer.

Thank you for your attention
Curt Wedbush
:

If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum
([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message

The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and
it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
:

What is the control source for [TotalHaulingCost] and
[TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
No. [CustTotalCost] is a calculated field in the footer of the
report.
(The
report is divided by Customer) However, in the report footer it
will
calculate TotalHaulingCost for all customer and TotalLaborCharge
for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in
the
control
source of the new unbound box and it gives the total of the
last
customer
only not a grand total. Did I do what you were saying
correctly
or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report.
Open
the
report in Design view and see what the control source is for
the
field
[CustTotalCost]. Place the same thing in the control source
of
an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


in
message
I have created a report that prints out customer invoices
and
totals
their
cost in a field called CustTotalCost. I am wanting to get
grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I
can't
get
it
to
calculate a GrandTotal for all the customers. This would
give
us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source
box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an
error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
G

Guest

I did try that but it would just come up blank. I just now tried to build
the expression and opened the queries folder and used the fields from the
underlying query and added them together. It worked!!!
The control source looks like the following:

=Sum([Name of Query]![HaulingCost]+[Name of Query]![Labor Charge])

Thank you for all your help.
Curt Wedbush
Lynn Trapp said:
No, if you have a HaulingCost field and a LaborCharge field in your query,
then you should be able to simply add the following to an unbound control in
your report footer:

=Sum([HaulingCost] + Sum([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
OK, let me go back to the starting point. The report I am working on is
based on a query. So in the query I must have a field that calculates the
HaulingCost and another one that calculates the LaborCharge. If I call
those
SumHaulingCost and SumLaborCharge, then I need another field in the query
that calculates the sum of each of these called TotalCost (or whatever I
what
to call it). If I do this, then I can put this new field [TotalCost] in
the
report footer and that would calculate everything? correct?

Thanks
Curt Wedbush

Lynn Trapp said:
Ok,
Let's go back to square one. The control source for a calculated value
in
any of the section footers, including the report footer, must be the
calculation of a field that is in the Record Source of the report.
Therefore, if you have a field called [LaborCharge] in the Record source
of
your report, to get the total of that in any of the footers you have to
put
=Sum([LaborCharge]) in the control source of the control that will
display
the sum. If you want the calculation of 2 fields in a footer (say
[LaborCharge] and [HaulingCost]), then you need to put
=Sum([LaborCharge]) +
Sum([HaulingCost]) in the control source of your control.

Do you have a field in the Record Source of your report called [Sum of
LaborCharge] and one called [Sum of HaulingCost]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm



The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of
HaulingCost]

But the CustTotalCost is the page footer and is a total of each
customer
(their monthly bill). That works fine. What I am trying to do is get
a
total of all the customers invoices for a grand total that is located
in
the
report footer.

Thank you for your attention
Curt Wedbush
:

If I understand your situation correctly, the control source for your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum
([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message

The control source is Sum([HaulingCost]) and Sum([LaborCharge]) and
it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
:

What is the control source for [TotalHaulingCost] and
[TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
No. [CustTotalCost] is a calculated field in the footer of the
report.
(The
report is divided by Customer) However, in the report footer it
will
calculate TotalHaulingCost for all customer and TotalLaborCharge
for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that in
the
control
source of the new unbound box and it gives the total of the
last
customer
only not a grand total. Did I do what you were saying
correctly
or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a report.
Open
the
report in Design view and see what the control source is for
the
field
[CustTotalCost]. Place the same thing in the control source
of
an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


in
message
I have created a report that prints out customer invoices
and
totals
their
cost in a field called CustTotalCost. I am wanting to get
grand
totals
for
all customers on the last page.

The report currently displays grand totals for other fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I
can't
get
it
to
calculate a GrandTotal for all the customers. This would
give
us
the
total
monthly invoice amount.

I have tried creating a text box that in the control source
box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even an
error
message.
I
thought this would be simple straight forward thinking but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 
L

Lynn Trapp

Well, if the two fields are a part of the record source you shouldn't have
to do that, but I'm glad you found a way to get it working anyway.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
I did try that but it would just come up blank. I just now tried to build
the expression and opened the queries folder and used the fields from the
underlying query and added them together. It worked!!!
The control source looks like the following:

=Sum([Name of Query]![HaulingCost]+[Name of Query]![Labor Charge])

Thank you for all your help.
Curt Wedbush
Lynn Trapp said:
No, if you have a HaulingCost field and a LaborCharge field in your
query,
then you should be able to simply add the following to an unbound control
in
your report footer:

=Sum([HaulingCost] + Sum([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


Curt Wedbush said:
OK, let me go back to the starting point. The report I am working on
is
based on a query. So in the query I must have a field that calculates
the
HaulingCost and another one that calculates the LaborCharge. If I call
those
SumHaulingCost and SumLaborCharge, then I need another field in the
query
that calculates the sum of each of these called TotalCost (or whatever
I
what
to call it). If I do this, then I can put this new field [TotalCost]
in
the
report footer and that would calculate everything? correct?

Thanks
Curt Wedbush

:

Ok,
Let's go back to square one. The control source for a calculated
value
in
any of the section footers, including the report footer, must be the
calculation of a field that is in the Record Source of the report.
Therefore, if you have a field called [LaborCharge] in the Record
source
of
your report, to get the total of that in any of the footers you have
to
put
=Sum([LaborCharge]) in the control source of the control that will
display
the sum. If you want the calculation of 2 fields in a footer (say
[LaborCharge] and [HaulingCost]), then you need to put
=Sum([LaborCharge]) +
Sum([HaulingCost]) in the control source of your control.

Do you have a field in the Record Source of your report called [Sum of
LaborCharge] and one called [Sum of HaulingCost]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message

The CustTotalCost control source is =[Sum of LaborCharge]+[Sum of
HaulingCost]

But the CustTotalCost is the page footer and is a total of each
customer
(their monthly bill). That works fine. What I am trying to do is
get
a
total of all the customers invoices for a grand total that is
located
in
the
report footer.

Thank you for your attention
Curt Wedbush
:

If I understand your situation correctly, the control source for
your
CustTotalCost control needs to be =Sum([HaulingCost]) + Sum
([LaborCharge])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message

The control source is Sum([HaulingCost]) and Sum([LaborCharge])
and
it
works
in the report footer.
I am confused why it doesn't work for the CustTotalCost

Thanks
Curt Wedbush
:

What is the control source for [TotalHaulingCost] and
[TotalLaborCharge]?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


message
No. [CustTotalCost] is a calculated field in the footer of
the
report.
(The
report is divided by Customer) However, in the report footer
it
will
calculate TotalHaulingCost for all customer and
TotalLaborCharge
for
all
customers but I can't add those together.

Thanks for attention
Curt Wedbush

:

is [CustTotalCost] a field in the Record Source of your
report?

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


in
message
The control source for the monthly total for a customer is
[CustTotalCost].
I created a text box in the report footer and put only that
in
the
control
source of the new unbound box and it gives the total of the
last
customer
only not a grand total. Did I do what you were saying
correctly
or
am
I
missing something else?

Thanks
Curt

:

You can't use the control name in a Sum function on a
report.
Open
the
report in Design view and see what the control source is
for
the
field
[CustTotalCost]. Place the same thing in the control
source
of
an
unbound
control in the Report footer.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


"Curt Wedbush" <[email protected]>
wrote
in
message
I have created a report that prints out customer invoices
and
totals
their
cost in a field called CustTotalCost. I am wanting to
get
grand
totals
for
all customers on the last page.

The report currently displays grand totals for other
fields
(Hauling
Cost)
(Labor Cost) etc. on the last page of the report. But I
can't
get
it
to
calculate a GrandTotal for all the customers. This
would
give
us
the
total
monthly invoice amount.

I have tried creating a text box that in the control
source
box I
have
used
=Sum([CustTotalCost]) but it displays nothing - not even
an
error
message.
I
thought this would be simple straight forward thinking
but
obviously
not.

Any suggestions would be appreciated
Thanks
Curt
 

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