Results 1 to 3 of 3
  1. #1
    Podder is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    22

    Showing Query results in a Report Textbox

    Hi,
    I am trying to show the results of a Query in a Report Textbox,
    I have 1 field only in the Query "Names"


    The result of the query shows the following: John, Bill, Sahra, Maggie, Shaun, Wendy
    I now want to show all the names in a Report Textbox.
    Please note I want to add to an existing Report where "Names" is a field in the report
    Is this possible?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    Review the concatrelated function
    http://allenbrowne.com/func-concat.html
    There are similar functions around but all broadly work on the same principle

  3. #3
    Podder is offline Novice
    Windows 10 Access 2016
    Join Date
    Sep 2018
    Posts
    22
    CJ_London
    Thats perfect, Thanks

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

Similar Threads

  1. report export problem - textbox not showing data
    By diegomarino in forum Access
    Replies: 25
    Last Post: 03-29-2021, 01:01 PM
  2. Replies: 2
    Last Post: 04-15-2017, 11:09 AM
  3. Replies: 1
    Last Post: 12-23-2014, 01:07 PM
  4. Replies: 1
    Last Post: 12-17-2014, 12:54 PM
  5. Replies: 1
    Last Post: 03-10-2012, 03:22 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