Results 1 to 3 of 3
  1. 04-18-2019, 12:07 PM #1
    julpari432
    julpari432 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    2

    Merge or Concatenate the Records in same table

    Hello Everyone i am beginner to MS acces. My problem is I have a product table with different no. of purchase in different states like
    Product States No.of Sales
    Apple UK 3
    Orange US 5


    Apple US 6
    Apple PK 5

    I want to design a query with results like
    Product State No. of Sales
    Apple UK,US,PK 13
    Orange US 5


    Please Help
    Reply With Quote Reply With Quote
  2. 04-18-2019, 12:34 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Review http://allenbrowne.com/func-concat.html
    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.
    Reply With Quote Reply With Quote
  3. 04-19-2019, 06:13 AM #3
    julpari432
    julpari432 is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2019
    Posts
    2
    Quote Originally Posted by June7 View Post
    Review http://allenbrowne.com/func-concat.html
    Thank You, it solved my problem
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Concatenate Records
    By Siiig in forum Queries
    Replies: 4
    Last Post: 02-19-2013, 08:17 AM
  2. Merge fields (not concatenate)
    By sberti in forum Access
    Replies: 2
    Last Post: 11-30-2012, 12:53 AM
  3. Concatenate records in Query
    By cleon in forum Queries
    Replies: 3
    Last Post: 04-08-2012, 11:14 AM
  4. merge or concatenate two rows in one
    By vojinb in forum Queries
    Replies: 7
    Last Post: 08-03-2011, 09:15 AM
  5. Need Code to Concatenate All Records
    By menntu in forum Programming
    Replies: 4
    Last Post: 06-05-2009, 09:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums