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

    Unanswered: Combining cell values

    Hi,

    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?

    Currently:
    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
    Posts
    1,191
    Me.Geek = True

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

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

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

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    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
  •