Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    138

    Unanswered: Grouping Question

    I have a database that has 16 fields that can be either "effective" or Opportunity".

    If the field is marked "Opportunity", the user has to comment about that specific field in a comment section.

    The comment section has a drop down box that allows the user to choose which of the 16 fields they are commenting on.

    The user has three separate comment fields in which he/she can discuss the reason they feel there is an "Opportunity".

    Works great - now I'm working on the report, and I need to group all like fields which have been commented on from the three comment fields.

    I can get it to group all of comment 1's "like" fields, i.e.

    1.1 Is Fair and Consistent
    then it lists the comment, behavior, impact, etc. (which accompany that comment section.

    My problem: I want Comment 1, Comment 2, and Comment 3 to list all of the 1.1's at one time. etc. regardless of whether or not the comment was listed in Comment 1, 2, or 3. Instead it's giving me all of Comment 1's 1.1s, and then Comment 1's 1.2, 1.3, etc., then Comment 2's 1.1s, then 1.2, 1.3, etc. and then Comment 3's 1.1, 1.2, 1.3, etc.

    Any suggestions?

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I think you might have a table design problem there... but I am far from certain.

    Can you post your relationships diagram? Or at least some sample data that you have in the tables.

    Why are there 3 comment fields ? O-o
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •