Results 1 to 3 of 3
  1. #1
    waqas is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2011
    Posts
    117

    Cool Access Query Result in One Row

    Hi Experts,

    I want to see query result with id numbers, Count of id numbers and in third column count detail.

    records are as below in table.

    1234 T1
    1234 T2
    1234 T3

    Result of query should be.

    1234 count = 3 , in detail column T1,T2,T3



    How can I get result in one row?

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Using VBA it should be possible.

  3. #3
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Suggest look at using a crosstab query or perhaps allen Browne's concatrelated function - http://allenbrowne.com/func-concat.html

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

Similar Threads

  1. Replies: 9
    Last Post: 02-11-2019, 05:50 PM
  2. Replies: 1
    Last Post: 09-14-2017, 10:19 AM
  3. Replies: 3
    Last Post: 03-25-2013, 02:01 PM
  4. Access giving wrong result using sql query
    By amlanroy in forum Access
    Replies: 3
    Last Post: 05-10-2012, 10:11 AM
  5. Access query result in excel format
    By Tha-G in forum Queries
    Replies: 1
    Last Post: 01-06-2012, 01:41 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