Results 1 to 4 of 4
  1. #1
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107

    Dsum for text fields

    Hi,
    I have a table where each Item has many Barcodes
    I want to return all Barcodes for a specific item as one string (all concatenated together, separated by a dash)


    If I use DSUM, it will sum the barcodes as numbers, not as strings.
    Any idea how to do it?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    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
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,860
    TheDBguy also has a similar function.
    http://www.accessmvp.com/thedbguy/co...itle=simplecsv

    However DSum() is not meant for concatenation anyway?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  4. #4
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Thank you guys.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-27-2017, 08:59 PM
  2. Summing calculated fields with DSum in a report
    By Carbontrader in forum Reports
    Replies: 3
    Last Post: 01-13-2017, 04:47 PM
  3. Replies: 2
    Last Post: 09-09-2015, 09:45 PM
  4. Replies: 1
    Last Post: 03-27-2014, 06:42 AM
  5. DSUM Text Box Stuck in a loop
    By Jademonkey2k in forum Access
    Replies: 7
    Last Post: 11-23-2010, 07:15 PM

Tags for this Thread

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