Concatenate Related Records

[MilaK]

Hello,

I’m using Allen Browne’s ConcatRelated records function in Expr2: ConcatRelated("Exp","amplicons_failed_amps_with_depth","[sample_id] = """ & [sample_id] & """") to list records on a multi-page report. Each page pertains to a different record. The limit is 255 characters and the rest gets cut off. Is there another solution?

I’ve tried to populate a listbox and then loop through all the items and concatenate them but this does not work on the multi-page report.

Here is the query:
SELECT [tbl_failed_amplicons].[gene] & ' exon (' & [tbl_failed_amplicons].[Exon] & ') at depth ' & [tbl_failed_amplicons].[Depth] AS failed_amp, tbl_failed_amplicons.sample_id
FROM tbl_Samples INNER JOIN tbl_failed_amplicons ON tbl_Samples.sample_id = tbl_failed_amplicons.sample_id
WHERE (((tbl_failed_amplicons.sample_id)=[Reports]![rpt_Project_Report]![sample_id]));

Please suggest something,

Thank

 

[Uncle Gizmo]

I noticed your post has yet to receive an answer. Please explain the 255 character cut off. I'm not clear on what you mean?

 

[MilaK]

I've used Allen Browne's ConcatRelated function combine records with the same id from a table and to display them in a textbox on a report. This method has a 250 characters limit and cuts off some of the records. Is there another way to make this work? Thanks

 

[Uncle Gizmo]

The 255 character limit isn't making sense to me. Text boxes can hold more than 255 characters. My guess is that the text box is bound to a text field in a table. The solution is to change the table field to memo.

Sent from my SM-G925F using Tapatalk

 

[sxschech]

http://allenbrowne.com/ser-63.html on Allen's site mentions the issue of truncation (255 char limit issue) and that can be caused by several things such as the type of query. There are a few suggestions there, hopefully that can sort it out, but I have had situations where I still couldn't get it to display over 255.

 

[MilaK]

I found a solution how to overcome this issue.

 

[sxschech]

and the solution was...?

 

[MilaK]

https://bytes.com/topic/access/answ...unction-query-struggling-character-limitation
This solution is not simple but it works.