How do I concatenate a row in a query and put in a text box in a form? I have a Query returning up to 10 dates the row is called [Date] I need to put them all together with a space and a comma between them and place that in a text box on a form.
Advanced Beginner
Windows 7 32bit 
Access 2010 32bit
How do I concatenate a row in a query and put in a text box in a form? I have a Query returning up to 10 dates the row is called [Date] I need to put them all together with a space and a comma between them and place that in a text box on a form.
VIP
Windows XP Access 2010 32bit
Do you mean the field is called [Date]? Date is a reserved word and should not use reserved words as names.
Do you want to concatenate multiple records into a single row? VBA code is required. 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.
Master of Nothing
Windows XP Access 2000
Maybe this page from Allen Browne will help you:
http://allenbrowne.com/func-concat.html
Concatenate Query Results
Concatenate two fields (text & number) for key field
Posting Permissions
Reply With Quote