Still believe that given your current layout of the db, that MS query is your easiest solution. Here is a note on how to make it work on a MAC

http://excelsemipro.com/2011/07/micr...mac-os-x-lion/