If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combine lines in a Report?
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? |
#2
|
|||
|
|||
Combine lines in a Report?
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." "LeoComputer" wrote in message ... 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? |
#3
|
|||
|
|||
Combine lines in a Report?
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 |
#4
|
|||
|
|||
Combine lines in a Report?
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." "LeoComputer" wrote in message ... 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 |
#5
|
|||
|
|||
Combine lines in a Report?
Hello Al,
Works perfectly. Didn't occur to me to use the Group totals and delete the detail - and I've only been working with computers since 1959 ! (See www.leo-computers.org.uk , and FYI the charity is www.workaid.org) Many thanks 'Leocomputer' |
Thread Tools | |
Display Modes | |
|
|