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"