A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Combine lines in a Report?



 
 
Thread Tools Display Modes
  #1  
Old December 19th, 2009, 01:50 PM posted to microsoft.public.access.reports
LeoComputer
external usenet poster
 
Posts: 3
Default 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  
Old December 19th, 2009, 02:18 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old December 19th, 2009, 05:18 PM posted to microsoft.public.access.reports
LeoComputer
external usenet poster
 
Posts: 3
Default 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  
Old December 20th, 2009, 05:26 PM posted to microsoft.public.access.reports
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old December 21st, 2009, 01:18 PM posted to microsoft.public.access.reports
LeoComputer
external usenet poster
 
Posts: 3
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.