Results 1 to 2 of 2
  1. #1
    Russellh is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Apr 2014
    Posts
    68

    How to get just a summary?

    So I have created a report from a query and it groups by Date then Service Order Type and so I have it gives me a subtotal for each service order type and then a total for the date. The problem is that I don't need all the records of the actual service orders in between. I just need it to group buy Date then give the subtotal for each type and then total service orders for that day then proceed to the next day.



    What is the best way to do that?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Maybe set the Detail section not visible.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Summary query
    By dsk96m in forum Queries
    Replies: 3
    Last Post: 02-29-2012, 01:40 PM
  2. Yearly Summary
    By GordonCopestake in forum Queries
    Replies: 2
    Last Post: 05-05-2011, 01:29 AM
  3. age range summary
    By maintt in forum Reports
    Replies: 10
    Last Post: 07-19-2010, 02:24 AM
  4. Summary Query - How to?
    By ritch in forum Access
    Replies: 16
    Last Post: 02-17-2010, 03:18 PM
  5. Summary Report Help Please?
    By solitaire in forum Reports
    Replies: 3
    Last Post: 03-03-2006, 08:10 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums