Thanks, I agree using the solution to fill a sister table with the result and a task to keep it up to date makes the most efficient sense.
Sorry about posting to the wrong forum, I didn't notice that when I posted based on a previous post.
Thanks for your help.