Subtotal for each vessel

[Mavis]

Hi,

I will like to have a subtotal for the claim by vessesl and voyage as shown
below in a report:

Vessel Voyage Claim (USD)
Eve 12 100
Eve 12 200
Subtotal: 300

Eve 11 100
Subtotal: 100

Sun 13 200
Subtotal: 200

Sun 14 200
Subtotal: 200

Moon 15 300
Subtotal: 300

What is the code i should input?

 

[John Spencer MVP]

IN report design view use the sorting and grouping dialog and Group By Vessel
-- Select View: Sorting and Grouping from the menu
-- in field/expression put the name of the field for Vessel
-- Select Yes for Group footer
-- Close sorting and grouping

In the new Group section of your report add a control
-- set its control source to
=Sum(Claim)
-- Edit associated label's caption to read
Subtotal:


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Mavis]

Hi,

I am able to add the grouping but the problem is that the grouping is only
for Vessel. I will like to have the grouping for both the vessel and voyage.
How can i do so? And also, the subtotal of the grouping appear ontop the of
detail. How can i move the subtotal to bottom of each line?

Thanks so much.

 

[John Spencer]

It sounds as if you put the data in the group HEADER and not in the
group FOOTER. If you want to group on vessel and voyage then add
another group level for voyage.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[Mavis]

Hi,

Thanks! i got it.

It sounds as if you put the data in the group HEADER and not in the
group FOOTER. If you want to group on vessel and voyage then add
another group level for voyage.


'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================