View Single Post
  #1  
Old December 19th, 2009, 12: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?