Sum of non-detail records

  • Thread starter Thread starter kellie jones
  • Start date Start date
K

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!
 
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.
 
woohoo!
that did the trick.
Thank you Allen.
Allen Browne said:
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.

kellie jones said:
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?
Click to expand...
Click to expand...
 
Back
Top