I have an ODBC link into a work data base that has the following information
Table Name: Item Remarks
Table Fields: Remark_ID, Remark_Line_Num ber, Remark_text
in the source database there is a limit of 40 characters in the remark text, basically everytime there is a carriage return it creates another remark_line_num ber with the remark_text.
What I am wanting to do is concatenate all of the Remark_text into 1 line in access for reporting reasons. some of these may have 1 line or 40 lines.
any help would be greatly appreciated.
Table Name: Item Remarks
Table Fields: Remark_ID, Remark_Line_Num ber, Remark_text
in the source database there is a limit of 40 characters in the remark text, basically everytime there is a carriage return it creates another remark_line_num ber with the remark_text.
What I am wanting to do is concatenate all of the Remark_text into 1 line in access for reporting reasons. some of these may have 1 line or 40 lines.
any help would be greatly appreciated.
Comment