We use access areas to track attendance to individual exhibitions within our museum. We had three new displays open on Saturday and all three access areas were missing the applicable price types so none of them scanned. And of course this happened on a weekend when I wasn't around to fix it in the moment. I have a custom utility to mark tickets attended in bulk, but does anyone have some SQL code to fix these missing access area scans? It doesn't matter which tickets they apply to -- we don't track individuals so much as just general trends so we just need the numbers in there. We used clickers in the galleries, so I have the counts. I know there isn't an out-of-the-box way to do this, which is why I'm hoping someone else has run into this and written some code for it. (And I'm trying to avoid a consulting request!).
Thanks!
Anne
The Historic New Orleans Collection