Combine lines in a Report?

  • Thread starter Thread starter LeoComputer
  • Start date Start date
L

LeoComputer

Charity sending tools and equipment to the 3rd world.
Table of Projects linked to ProjectDetails table holding all Items being
sent with their quantities, weight etc. (Many different types of items)
Projects are also linked to a Container table.

One Report produces a 'Gift Certificate' for each Project, listing each item
for that project and all details - no problem.

A one-page Consolidated report is also required for all projects in a
container, listing all items with their combined details.
If the same type of item is sent to say 3 Projects, how can I combine the
entries rather than the 3 lines in the report I have at present?
 
Leo,
Could you give us a few lines of data?
Ex: "This is what I show now... and this is what I'd like to see."

Sounds like just a "grouping" issue, but need a bit more detail...
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Hi Al,
thanks for the quick reply. I tried to simplify the details a bit. The main
report has some fixed items , the problem part is a sub-report.

Used Knitting machine table 1 1 (box) 9 (kg)
Used Knitting machine table 1 1 8
Used Knitting machine table 2 3 18
Used Wood Lathe 1 4 120

Should be:
Used Knitting machine table 4 5 35
Used Wood Lathe 1 4 120

Leo
 
Leo,
Please don't delete the previous replies. Just let the thread grow, so
we can see the flow of the problem. Okay to delete non essential stuff, but
not the importatmt parts of the posts.

You did not indicate the names of the fields, so I'll use my own
example names... Using the first record, I'll also assume that
1 = Qty 1 = NoOfBoxes and 9 = Weight

If "Used Knitting Machine Table" and "Used Wood Lathe"
are examples of [Equipment], you should be grouping your report
on the [Equipment] field. And the Equipment Footer would display
the totals for that Equipment "group".
(=Sum(Qty) or =Sum(Weight) ..etc)

Detail---------- Qty Box Weight
Used Knitting machine table 1 1 9
Used Knitting machine table 1 1 8
Used Knitting machine table 2 3 18
--------------
Equipment Footer-------
Used Knitting Machine table 4 5 35
Detail----------
Used Wood Lathe 1 4 120
--------------
Equipment Footer
Used Wood Lathe 1 4 120

I find it easier to build a summary report with the Detail showing, and
when the totals are all OK, just delete the Detail Section... to get...

Used Knitting Machine table 4 5 35
Used Wood Lathe 1 4 120
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top