[Koha] Extracting Marc Tag 245b for remainder of title in Access

[BRANNON, CHRISTOPHER]

That is awesome.  Didn't know about that.  Works like a charm.  Now I just need to figure out the equivalent of

HAVING items.holdingbranch=<<Branch filled at|branches>>

within Access and all will be well.  Thanks for the info!

Christopher Brannon
Coeur d'Alene Public Library

If you're using Access as an ODBC front-end to the MySQL database, it should be possible to define an "SQL pass-through query" [1] that would let you use the MySQL version of the query directly,
ExtractValue() and all.

[1] http://support.microsoft.com/kb/303968

Regards,

Galen
--
Galen Charlton
Manager of Implementation
Equinox Software, Inc. / The Open Source Experts
email:  gmc at esilibrary.com
direct: +1 770-709-5581
cell:   +1 404-984-4366
skype:  gmcharlt
web:    http://www.esilibrary.com/
Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org