Both tables are far to large as this is a running system to give a copy, I am just trying to create a query for a report.
That's why you're asked only for sample data;-). You did posted sample data but Laurie had to code the DDL and the INSERTs to recreate it.
As we're all volunteers, we ask you to provide us with the data in this format so we can concentrate in your problem.:-)
Read the article linked in my signature for a better explanation.