Results 1 to 7 of 7
  1. #1
    DavidMack is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    3

    Field displayed as a record

    Using a querry, I want to display a field as a record.

    Table A has an ID Field, Company Field and Name Field.



    Let say 3 people are assigned to the Chocolate company. I want my querry to display the ID, the company and then the next column Bob, the next column tina, the next column Sue.

    I've tried using a total's querry and it works using Max and Min for the Name field...but doesn't due me much good if there are more than 3 names.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    DavidMack is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    3
    Well if I understood it correctly the result would return one string from multiple fields...I only have one field that i really need to be modified.

    I used the code but unfortunatly it did not work for me...

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Well, it returns one string from a field in multiple records. The only difference that I see between your request and that method is that it returns a single, comma delimited field instead of multiple columns.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Have you looked at a Crosstab query? There is a wizard to help create it.

  6. #6
    DavidMack is offline Novice
    Windows Vista Access 2007
    Join Date
    Jul 2012
    Posts
    3
    Yes...and if i only had 2 name i could use the min / max options....but i have more than 2 name so in most occasions im missing data..

  7. #7
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I haven't done it, but I read somewhere, someone ( yeah, right!!) used the crosstab query wizard to create the SQL, then edited the SQL to include more fields. I'm just saying......possible???

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

Similar Threads

  1. Replies: 6
    Last Post: 04-17-2012, 10:32 AM
  2. Replies: 1
    Last Post: 10-13-2010, 12:40 PM
  3. New JPGs Not Displayed
    By DJMoore in forum Access
    Replies: 1
    Last Post: 11-15-2009, 05:30 AM
  4. Record Numbers Displayed on Form
    By symfony925 in forum Forms
    Replies: 3
    Last Post: 10-13-2009, 11:06 AM
  5. JPEG isn't displayed in forms
    By GeorgeILPS in forum Access
    Replies: 0
    Last Post: 01-14-2008, 12:21 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