Carriage return

[devcon]

I’ve one query with fields 'description' and 'comment'.



I need to concatenate the two fields in one 'details'.
Then look in the table 'List' with one field 'fWrap' and if the field 'Details' contain the one or more 'fWrap' to create a carriage return for each 'fWrap'.
Actually I use the following expression, but look only the 'comment' field and not the description.

Details: IIf(DCount("[fWrap]","List","[fWrap] Like '*" & Left([Comment],2) & "*'"),[Description] & Chr(13) & Chr(10) & [Comment],[Description] & " " & [Comment])

Any suggestion please?

Thank you in advance.

[June7]

This has been addressed in other threads.

https://www.accessforums.net/reports...lly-25480.html

https://www.accessforums.net/reports...ble-29972.html

DCount count records in a table, not how many times a string of characters is within another string.

[devcon]

I'm sorry I forgot your answer.
I solve the problem.
Thank you and I wish you Happy New Year.