form total does not appear in report total

  • Thread starter Thread starter Mark S Doherty
  • Start date Start date
M

Mark S Doherty

Ok , heres the deal.
I have a form with an aggregate total of cargo tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to take the
form total?
 
It sounds like you have calculations on your form that
determine the total. If the form is open you can reference
the form field on the report. Add an unbound text box with
the following in the Control Source....

=Forms![FormName]![FieldName]
 
-----Original Message-----
Ok , heres the deal.
I have a form with an aggregate total of cargo tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to take the
form total?
.
Thanks, that does give a total but its the same total
for each record depending on which record is open in the
form.

I need a report that gives the individual total for each
vessels cargo tonnage.

How can I do this?
 
I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?
 
That doesn't look like an "Aggregate" total since aggregates usually involve
more than a single record. Are these fields in a table? Is the table part of
the recordsource of the report? Where are you using this in the report
(which section)?

What do you mean by "When I check the table the total also gives zero"?

Are some of the field values possibly null?

Is there a reason you have repeating fields (un-normalized) rather than
separate records for tonnage?

--
Duane Hookom
MS Access MVP
--

Mark S Doherty said:
I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?
-----Original Message-----
How does the form calculate the total?

--
Duane Hookom
MS Access MVP





.
 
Hello Duane,

I will try to make my point more clearly as I feel I may
be confusing the issue.

I have a maritime database of all vessels arriving and
departing Derry Port.

I have three tables Vessel (Vessel Details) Shipping
(Movements etc) and Cranes (Cranes per vessel)

The shipping table has cargo tonnage 1 through to 6 and a
cargo total. I can't find a way of getting the cargo
total to calculate the tonnages 1 to 6 on the table.

I have made a shipping form which includes the vessel
details and the shipping movements and tonnages which
arrive at the quay.

A vessel usually has one cargo but sometimes has 3 or 4
different cargoes. eg Gas Oil, Derv, Kero
I have made an aggregate calculation of the tonnages in
the cargo Total field on the form.

My problem is that the table picks up the individual
cargo tonnages from the form but not the cargo total on
the form. eg CargoTonnage1, 50. CargoTonnage2, 100.
CargoTonnage3, 100. The cargo total on the form
calculates 250, The Cargo Total on the table reads 0.

The Report takes the calculations from the table, not the
form, so I am having problems trying to get a total cargo
tonnage for each vessel.

Ideally, I would like a monthly vessel report and the
total cargo for that vessel.

Should I make a calculation on the report that adds up
the individual cargoes or should I make a query and use
the calculation from that?

Please help.

Regards

Mark S
-----Original Message-----
That doesn't look like an "Aggregate" total since aggregates usually involve
more than a single record. Are these fields in a table? Is the table part of
the recordsource of the report? Where are you using this in the report
(which section)?

What do you mean by "When I check the table the total also gives zero"?

Are some of the field values possibly null?

Is there a reason you have repeating fields (un- normalized) rather than
separate records for tonnage?

--
Duane Hookom
MS Access MVP
--

I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?
-----Original Message-----
How does the form calculate the total?

--
Duane Hookom
MS Access MVP


Ok , heres the deal.
I have a form with an aggregate total of cargo tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to take the
form total?


.


.
 
First off, I would not have fields tonnage 1-6. I would normalize the table
so each tonnage value created a new record in a related table.

However, in your report (or query) you can use the expression
Report control:
=Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz(Tonnage3,0) + Nz(Tonnage4,0) +
Nz(Tonnage5,0) + Nz(Tonnage6,0)
Query column expression
TotalTonnage: Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz(Tonnage3,0) +
Nz(Tonnage4,0) + Nz(Tonnage5,0) + Nz(Tonnage6,0)

--
Duane Hookom
MS Access MVP
--

Mark S Doherty said:
Hello Duane,

I will try to make my point more clearly as I feel I may
be confusing the issue.

I have a maritime database of all vessels arriving and
departing Derry Port.

I have three tables Vessel (Vessel Details) Shipping
(Movements etc) and Cranes (Cranes per vessel)

The shipping table has cargo tonnage 1 through to 6 and a
cargo total. I can't find a way of getting the cargo
total to calculate the tonnages 1 to 6 on the table.

I have made a shipping form which includes the vessel
details and the shipping movements and tonnages which
arrive at the quay.

A vessel usually has one cargo but sometimes has 3 or 4
different cargoes. eg Gas Oil, Derv, Kero
I have made an aggregate calculation of the tonnages in
the cargo Total field on the form.

My problem is that the table picks up the individual
cargo tonnages from the form but not the cargo total on
the form. eg CargoTonnage1, 50. CargoTonnage2, 100.
CargoTonnage3, 100. The cargo total on the form
calculates 250, The Cargo Total on the table reads 0.

The Report takes the calculations from the table, not the
form, so I am having problems trying to get a total cargo
tonnage for each vessel.

Ideally, I would like a monthly vessel report and the
total cargo for that vessel.

Should I make a calculation on the report that adds up
the individual cargoes or should I make a query and use
the calculation from that?

Please help.

Regards

Mark S
-----Original Message-----
That doesn't look like an "Aggregate" total since aggregates usually involve
more than a single record. Are these fields in a table? Is the table part of
the recordsource of the report? Where are you using this in the report
(which section)?

What do you mean by "When I check the table the total also gives zero"?

Are some of the field values possibly null?

Is there a reason you have repeating fields (un- normalized) rather than
separate records for tonnage?

--
Duane Hookom
MS Access MVP
--

I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?

-----Original Message-----
How does the form calculate the total?

--
Duane Hookom
MS Access MVP


"Mark S Doherty" <[email protected]>
wrote in message
Ok , heres the deal.
I have a form with an aggregate total of cargo tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to take the
form total?


.


.
 
Hi Duane
Not sure about Normalisation of table. I'm a newbie to
all this stuff and I want to crawl b4 I walk. Would I be
right in saying that Normalising would stop repeating
entries, but in Shipping I have many repeating entries.
Maybe, when I learn more I will attempt this!

Anyway, Thank you for your input on the report/query as
this has worked a treat. Databases are so complicated and
time consuming that I have spent an eternity looking for
information trying to complete this one. I'm sure that I
am far from finished but you have been a great help.

An Irish toast will be had for You tonight. Solid days
and Whiskey nights. Thank you Duane.

Regards

Mark S
-----Original Message-----
First off, I would not have fields tonnage 1-6. I would normalize the table
so each tonnage value created a new record in a related table.

However, in your report (or query) you can use the expression
Report control:
=Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz(Tonnage3,0) + Nz (Tonnage4,0) +
Nz(Tonnage5,0) + Nz(Tonnage6,0)
Query column expression
TotalTonnage: Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz (Tonnage3,0) +
Nz(Tonnage4,0) + Nz(Tonnage5,0) + Nz(Tonnage6,0)

--
Duane Hookom
MS Access MVP
--

Hello Duane,

I will try to make my point more clearly as I feel I may
be confusing the issue.

I have a maritime database of all vessels arriving and
departing Derry Port.

I have three tables Vessel (Vessel Details) Shipping
(Movements etc) and Cranes (Cranes per vessel)

The shipping table has cargo tonnage 1 through to 6 and a
cargo total. I can't find a way of getting the cargo
total to calculate the tonnages 1 to 6 on the table.

I have made a shipping form which includes the vessel
details and the shipping movements and tonnages which
arrive at the quay.

A vessel usually has one cargo but sometimes has 3 or 4
different cargoes. eg Gas Oil, Derv, Kero
I have made an aggregate calculation of the tonnages in
the cargo Total field on the form.

My problem is that the table picks up the individual
cargo tonnages from the form but not the cargo total on
the form. eg CargoTonnage1, 50. CargoTonnage2, 100.
CargoTonnage3, 100. The cargo total on the form
calculates 250, The Cargo Total on the table reads 0.

The Report takes the calculations from the table, not the
form, so I am having problems trying to get a total cargo
tonnage for each vessel.

Ideally, I would like a monthly vessel report and the
total cargo for that vessel.

Should I make a calculation on the report that adds up
the individual cargoes or should I make a query and use
the calculation from that?

Please help.

Regards

Mark S
-----Original Message-----
That doesn't look like an "Aggregate" total since aggregates usually involve
more than a single record. Are these fields in a
table?
Is the table part of
the recordsource of the report? Where are you using
this
in the report
(which section)?

What do you mean by "When I check the table the total also gives zero"?

Are some of the field values possibly null?

Is there a reason you have repeating fields (un- normalized) rather than
separate records for tonnage?

--
Duane Hookom
MS Access MVP
--

I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?

-----Original Message-----
How does the form calculate the total?

--
Duane Hookom
MS Access MVP


"Mark S Doherty"
wrote in message
Ok , heres the deal.
I have a form with an aggregate total of cargo tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to
take
the
form total?


.



.


.
 
Normalizing suggests you don't have repeating columns with similar values
such as Child1, Child2, Child3,...

--
Duane Hookom
MS Access MVP
--

Mark S Doherty said:
Hi Duane
Not sure about Normalisation of table. I'm a newbie to
all this stuff and I want to crawl b4 I walk. Would I be
right in saying that Normalising would stop repeating
entries, but in Shipping I have many repeating entries.
Maybe, when I learn more I will attempt this!

Anyway, Thank you for your input on the report/query as
this has worked a treat. Databases are so complicated and
time consuming that I have spent an eternity looking for
information trying to complete this one. I'm sure that I
am far from finished but you have been a great help.

An Irish toast will be had for You tonight. Solid days
and Whiskey nights. Thank you Duane.

Regards

Mark S
-----Original Message-----
First off, I would not have fields tonnage 1-6. I would normalize the table
so each tonnage value created a new record in a related table.

However, in your report (or query) you can use the expression
Report control:
=Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz(Tonnage3,0) + Nz (Tonnage4,0) +
Nz(Tonnage5,0) + Nz(Tonnage6,0)
Query column expression
TotalTonnage: Nz(Tonnage1,0) + Nz(Tonnage2,0) + Nz (Tonnage3,0) +
Nz(Tonnage4,0) + Nz(Tonnage5,0) + Nz(Tonnage6,0)

--
Duane Hookom
MS Access MVP
--

Hello Duane,

I will try to make my point more clearly as I feel I may
be confusing the issue.

I have a maritime database of all vessels arriving and
departing Derry Port.

I have three tables Vessel (Vessel Details) Shipping
(Movements etc) and Cranes (Cranes per vessel)

The shipping table has cargo tonnage 1 through to 6 and a
cargo total. I can't find a way of getting the cargo
total to calculate the tonnages 1 to 6 on the table.

I have made a shipping form which includes the vessel
details and the shipping movements and tonnages which
arrive at the quay.

A vessel usually has one cargo but sometimes has 3 or 4
different cargoes. eg Gas Oil, Derv, Kero
I have made an aggregate calculation of the tonnages in
the cargo Total field on the form.

My problem is that the table picks up the individual
cargo tonnages from the form but not the cargo total on
the form. eg CargoTonnage1, 50. CargoTonnage2, 100.
CargoTonnage3, 100. The cargo total on the form
calculates 250, The Cargo Total on the table reads 0.

The Report takes the calculations from the table, not the
form, so I am having problems trying to get a total cargo
tonnage for each vessel.

Ideally, I would like a monthly vessel report and the
total cargo for that vessel.

Should I make a calculation on the report that adds up
the individual cargoes or should I make a query and use
the calculation from that?

Please help.

Regards

Mark S

-----Original Message-----
That doesn't look like an "Aggregate" total since
aggregates usually involve
more than a single record. Are these fields in a table?
Is the table part of
the recordsource of the report? Where are you using this
in the report
(which section)?

What do you mean by "When I check the table the total
also gives zero"?

Are some of the field values possibly null?

Is there a reason you have repeating fields (un-
normalized) rather than
separate records for tonnage?

--
Duane Hookom
MS Access MVP
--

"Mark S Doherty" <[email protected]>
wrote in message
I have a calculation ... =[ImportCargoTonnage1]+
[ImportCargoTonnage2]+[ImportCargoTonnage3]etc

Am I doing something wrong?

-----Original Message-----
How does the form calculate the total?

--
Duane Hookom
MS Access MVP


"Mark S Doherty"
wrote in message
Ok , heres the deal.
I have a form with an aggregate total of cargo
tonnage.

When I make a report the total is zero.

When I check the table the total also gives zero,
obviously taking the figure from the table.

How can this be? How can I force the report to take
the
form total?


.



.


.
 
Back
Top