I was wondering if anyone had a way to generate report output like "D/2, 4, 6; E/2, 4, 6" in a single field for seating locations and the like. I would like to be able to report on this data without having a separate row for each seat/SLI.
So far I think this would probably be easiest with an aggregate function and GROUP BY clause, but it appears you can't actually define your own aggregate functions without CLR, and that's getting to be pretty far outside my area of expertise.
Any ideas?
Hi Nick
We use a couple of local functions to deliver seat strings (different variations for different purposes)
They deliver seat strings like "Stalls M41-42,R39-41" - which obviously doesn't work if your venue does that odd thing of having even numbers on one side and odd numbers on the other side, instead of sequential numbering - which it looks like yours does? But something like ours would probably work, with a bit of modification.
I've posted a couple of variations of ours, plus a supporting function, in my Files here, if you want to have a look.
Ken