Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2009

    Unanswered: Combining cell values


    I have a small Access DB where users can add their own subjects and then add grades to those subjects. Each entry is for itself so when I want to display stats, it shows duplicate subjects. How can I combine cell values?

    MATH: 5
    ENGLISH: 3
    PHYSICS: 4
    MATH 3
    MATH 2

    I want it to be:
    MATH: 5, 3, 2
    ENGLISH: 3
    PHYSICS: 4

    How can I achieve this?

  2. #2
    Join Date
    May 2005
    Me.Geek = True

  3. #3
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Before looking at that, I would suggest checking out this:

    Fundamentals of Relational Database Design --
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  4. #4
    Join Date
    Nov 2007
    Adelaide, South Australia
    Agreed with Teddy.

    Concatenating fields sure won't help. It would if the grades were in different fields of the same table. Here, you'd have to loop through the records and build a string.
    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