Thanks Sergey. That did the trick. I had tried using outer joins before but the way I had my tables and links set up was causing it to fail the first time.