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
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.
#1
André Arnaud de Cal...
291,711
Super User 2024 Season 2
#2
Martin Dráb
230,458
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
