Hi, On Thu, May 30, 2013 at 3:23 PM, BRANNON, CHRISTOPHER <cbran...@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: g...@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 _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
