I have created a database in Access 2013 and am working on a report. I have been attempting to figure out how to do multi-line concatenation but have run into some issues.
My expression right now reads:
=[CovType1] & " - " +[Results1] & " - " +[Details1] & ".
" +[CovType2] & " - " +[Results2] & " - " +[Details2] & ".
" +[CovType3] & " - " +[Results3] & " - " +[Details3] & ".
" +[CovType4] & " - " +[Results4] & " - " +[Details4] & ".
" +[CovType5] & " - " +[Results5] & " - " +[Details5] & "."
I have put this into an expression under Control Source.
Users will fill out a form and will fill out up to 5 categories of results. They will not always fill all categories (i.e., sometimes, a user may only have 2 categories; other times a user may have all 5; etc). If there is no data in the category, then I want the data not to appear and to treat it as null. I followed directions from Harfang's article (http://www.experts-exchange.com/articles/2040/Concatenation-in-Access-Reports-and-Forms.html
) on a shortcut way to do that.
When I run the report, I get #Type! instead of the results I'm supposed to see for this field.
Any suggestions on how to make this work? Thanks in advance!