Results 1 to 2 of 2
  1. #1
    sidhu246 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2017
    Posts
    6

    get the overall total qty and get comma separate items for a single id


    Click image for larger version. 

Name:	customer.jpg 
Views:	10 
Size:	38.6 KB 
ID:	29926Click image for larger version. 

Name:	orders.jpg 
Views:	10 
Size:	89.7 KB 
ID:	29927
    I have 2 tables customer and orders and i want id,customer,item,qty to be displayed in a separate table how to do it. And for single Id and customer i need the items to be comma separated and with overall qty.
    for eg. for ID D00001 customer is ABC and items must display as 1234,5678 and qty must be 975. Can anyone help me out

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,820
    Creating the CSV string requires VBA procedure. Review http://allenbrowne.com/func-concat.html

    However, you don't want to duplicate ITEM codes. Modify the function to first check if the code is already in constructed string before concatenating. Call the function in a GROUP BY query or build a report and use its Sorting & Grouping features with aggregate calcs in textboxes and call the function in a textbox.
    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.

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

Similar Threads

  1. Replies: 4
    Last Post: 06-07-2014, 01:54 PM
  2. Replies: 8
    Last Post: 11-21-2013, 11:28 AM
  3. comma-separate for fee
    By msasan1367 in forum Access
    Replies: 1
    Last Post: 05-29-2013, 08:16 PM
  4. Replies: 1
    Last Post: 10-28-2009, 12:44 PM
  5. Replies: 1
    Last Post: 08-21-2009, 06:52 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
  •  
Other Forums: Microsoft Office Forums