Results 1 to 4 of 4
  1. #1
    garywin is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2

    Is this even possible?


    Hi everybody,

    I hope you are all well today. I have a bit of a complicated situation and I am thinking that it will require multiple steps, but I am looking to condense all transactions into as few queries and tables as possible. Here is the situation:

    I am looking to draw data from two different tables and use a query to populate a 3rd table.

    In the first table I have 3 fields of importance - Name, Course Abbreviation, and Course Number.

    In the second table I have the additional fields - Name, Employee ID, Rank, email

    For the third table I would like to group the data from the two tables by Employee and look something like this

    Employee ID:Name:Email:Courses (this would be a combination of the Course Abbreviation and Course Number field. Also Employees have multiple courses over several records, so I'm looking to condense this).

    For the rank field I am just pulling employees of a certain rank.

    I have played with several styles and have been able to get my queries to pull the data I need, just not in the format I need. For example, I want all courses associated with one employee on one record. Is this possible?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,619
    VBA code can be used to concatenate rows into one field. This might be convenient for display in a report but do not recommend saving data in this structure.

    Google: access vba concatenate rows

    Will get a lot of hits on this topic.
    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.

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Here's one:

    Return a concatenated list of sub-record values

    I don't see another table, just a single query and a function.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    garywin is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2011
    Posts
    2
    Thanks for the tips. I'll see what I'm able to concoct with the new resources

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

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