Concatenate results from NL("rows",<table>,<field> ...)

(0) Share

Report

Posted on by Community Member

Newbie question here. Is it possible to have something like NL("rows",<table>,<field> ...) and instead of getting rows just return the concatenated (text) of all the found <field> ?

I have a situation where I need to look up and return a text that is the combination of all the comment-lines in a table?

Can this be done in Jet?

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Greg Enns 1,106 on at

Like (0)

Report

RE: Concatenate results from NL("rows",<table>,<field> ...)

In order to get all the comments, you'll have to do an NL("rows". To concatenate them, add a column which concatenates the cell above with the comment on its' own line. The last row resulted from the NL(rows should then have a cell with the full concatenated text you're looking for.

Last I checked, the Jet Portal doesn't allow you to use INDIRECT, but if you're not using the Portal, it can be a pretty handy function for complicated situations like this.

Was this reply helpful? Yes No