Search results

Bloody wonderful. Works like a charm. Thank you all!

Okay. I'm using the Concatenate function that Beetle posted. Here is the (greatly simplified) SQL for the query: SELECT ConcatRelated("RMSTRXNOTE","TestTable","RMSFILENUM = left(SEQUENCE,6)","SEQUENCE","") AS Expr1 FROM TestTable; TestTable.xls is the entry data. the column of SEQUENCE is an...

They probably do, but I can't figure out how to alter them to do it. I keep getting the same result, one combined comment field repeated for every account.

Well, I knew it was too good to be true. The table I'm working with has multiple accounts in it, each with multiple comment lines. The function will concatenate the comment fields, sure, but it only does it for the first one and puts that result in the field for each account, and not just the...

Hey, it worked pretty good! Thanks! One other thing, though: for comment series where there is 10 or more, the code tries to put 10 immediately after 1. I know this is a basic Access issue and not a problem of the function, but might someone know how to make the thing properly order the numbers?

Hi all, I'm not sure if this part of the forums is the place for this question, but here goes anyway. I am trying to concatenate a series of sequentially numbered comment fields contained in a single table. It looks like this: 71478 1 I want to 71478 2 combine all 71478 3 of these lines...

Hi all, I'm Sean, working for a large bank in the US. Access is an integral part of my reporting duties, and I'm always up for learning how to do more.