Results 1 to 5 of 5
  1. #1
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670

    Grouping On Report

    I have a report that displays A Sales Persons name, the stores they sell to and what was sold to the specific store. There is a one to many relationship between Sales Person -> Store and Sales Person -> Item



    My issue is that on my report I have the Sales Person Name in the SalesPerson Header, and I have a group by on this.

    In the Detail Section, I have the itemName, and itemQty - but the report shows double store info instead of just one

    Meaning I get this on the report

    Sales Person A

    Store # 1
    Baseball 4

    Store # 1
    Cap 5

    Instead of showing
    Sales Person A

    Store # 1
    Baseball 4
    Cap 5

    I am sure this is something small that I am missing but I can't seem to figure it out.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    make 2 groups (with headers and/or footers):

    PERSON
    STORE
    detail....

  3. #3
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    That is what I have...:headscratching

    I have a group by on
    Person with A on top
    Group by on
    Store

    And in the Detail section I have the fields that I want to display.

    Am I missing something?

  4. #4
    jo15765's Avatar
    jo15765 is offline Expert
    Windows 10 Access 2016
    Join Date
    Nov 2010
    Location
    6 Feet Under
    Posts
    670
    Quote Originally Posted by ranman256 View Post
    make 2 groups (with headers and/or footers):

    PERSON
    STORE
    detail....
    hah stupid me mistake. I see it now.

    How can I force a new page each time the sales person changes?

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Try the section's ForceNewPage property.
    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. Report Grouping
    By f15e in forum Reports
    Replies: 3
    Last Post: 01-18-2017, 08:40 AM
  2. Report Grouping
    By mountaindo in forum Reports
    Replies: 7
    Last Post: 04-08-2014, 03:19 PM
  3. Grouping in Report
    By New.Dimension6267 in forum Reports
    Replies: 1
    Last Post: 10-11-2013, 10:03 PM
  4. Grouping in a report
    By YStein142 in forum Reports
    Replies: 3
    Last Post: 06-28-2012, 05:22 PM
  5. Grouping a report
    By JAJansenJr in forum Reports
    Replies: 0
    Last Post: 03-01-2011, 11:05 PM

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