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