Sum of non-detail records

[kellie jones]

I hope I can explain this:

I have a packing slip table with part number & quantityshipped. This table
is linked to a table that includes comments for this record/line on the
packing slip. Because it is possible to have multiple comment lines for 1
shipment line, I report the quantity shipped & line info on in a header
section and the comments are in the detail section (if not the same part &
qty ship would print for each comment).

I need a total quantity shipped at the end of the report (which sounds
simple enough), but because the report sums by the detail - a shipment
record with 2 comments gets added to the total twice.

Is there any way to get around this?

Thanks!

 

[Allen Browne]

Place a text box in the group header section, and give it these properties:
Control Source =1
Running Sum Over All
Name txtCount
Format General Number
Visible No

Now in your Report Footer section, add a text box with these properties:
Control Source =[txtCount]
Format General Number

The first text box accumlates 1 each time the group header is printed, even
though it is hidden. The text box in the group footer reads and displays how
much it has accumlated.

 

[kellie jones]

woohoo!
that did the trick.
Thank you Allen.

Place a text box in the group header section, and give it these properties:
Control Source =1
Running Sum Over All
Name txtCount
Format General Number
Visible No

Now in your Report Footer section, add a text box with these properties:
Control Source =[txtCount]
Format General Number

The first text box accumlates 1 each time the group header is printed, even
though it is hidden. The text box in the group footer reads and displays how
much it has accumlated.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I hope I can explain this:

I have a packing slip table with part number & quantityshipped. This table
is linked to a table that includes comments for this record/line on the
packing slip. Because it is possible to have multiple comment lines for 1
shipment line, I report the quantity shipped & line info on in a header
section and the comments are in the detail section (if not the same part
&
qty ship would print for each comment).

I need a total quantity shipped at the end of the report (which sounds
simple enough), but because the report sums by the detail - a shipment
record with 2 comments gets added to the total twice.

Is there any way to get around this?