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: 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
