I need to concatenate two memo fields to print in a report. I can easily do this with text and number fields but haven't been able to get it to work with memo files.
Any help is appreciated.
Novice
Windows 7 64bit 
Access 2002
I need to concatenate two memo fields to print in a report. I can easily do this with text and number fields but haven't been able to get it to work with memo files.
Any help is appreciated.
VIP
Windows Vista Access 2010 32bit
do this in the query (of the report):
combined: [field1] & " " & [field2]
VIP
Windows 10 Access 2010 32bit
"haven't been able to get it to work" means what - error message, wrong results, nothing happens? What have you tried?
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.
How to concatenate 3 fields?
Memo field corruption - best way to convert memo fields to text fields
Concatenate two fields
Concatenate Fields
Posting Permissions
Reply With Quote