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

[Galen Charlton]

Hi,

On Thu, May 30, 2013 at 3:23 PM, BRANNON, CHRISTOPHER
<CBRANNON at cdalibrary.org> wrote:
> Hey folks.  I'm trying to build a report in Access (don't ask me why).  I
> know in Koha, I can use ExtractValue(bi.marcxml,
> '//datafield[@tag="245"]/subfield[@code="b"]') to get the remainder of the
> title in the Marc record.  However, ExtractValue isn't a function in Microsoft
> Access.  Anyone know of an equivalent method for retrieving this piece of>
> information in an Access report?

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