Results 1 to 2 of 2
  1. #1
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2013
    Posts
    93

    cannot sort report by product

    I have a problem that I thought was working but is not.
    When I run a report, it lists multiple products ordered, with the ordered quantity.
    What I want the report to do is summarize the same product types, and total the amount reserved for that particular product.
    In report design, when I crate a grouping, it does not give me the option to group by product name, even though product name field is in the related query, and in the report.
    How do I create this sort? Thank you!


    Some screenshots are attached.
    Attached Thumbnails Attached Thumbnails strato query.JPG   strato report design view.JPG   strato report.JPG  

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    There should be a way to add a new grouping and/or sort which will allow you to choose the product to group on.

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

Similar Threads

  1. Replies: 6
    Last Post: 02-28-2015, 11:57 AM
  2. Replies: 3
    Last Post: 01-18-2015, 06:05 PM
  3. Replies: 2
    Last Post: 08-14-2014, 11:49 AM
  4. Replies: 3
    Last Post: 02-26-2013, 05:07 AM
  5. Adding a product to a report
    By abarin in forum Reports
    Replies: 2
    Last Post: 05-31-2011, 09:01 PM

Tags for this Thread

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