Brilliant!
That accomplished exactly what it needed to. It even had the additional benefit of identifying Projects missing a Keyword. The concatenation displayed nothing for that Project making it extremely easy to identify.
Thanks again.
Purpose is to generate a report showing each Facility on a single line with the total Cost of only the Funded projects and a block of the Keywords associated with only the Funded projects. The Keyword block should only contain a single occurrence of each Keyword.
Each Facility has multiple...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.