Database Query Help

I have a query thats required asap, however I am running into trouble and need assistance. Part of the problem is the size of the data, the database is about 7meg zipped, 40 meg as an mdb, and its taking me forever to run and test queries. database is at [login to view URL] and Ill give the username and password to the winning bidder [login to view URL] is what goes over what im looking for. It references table/field names [login to view URL] is some query work i have already done, more specifically the iif conditions that are difficult to explain. If the query has to be run in multiple steps thats fine. Whatever way you can get it to work at this point. Im looking for someone whos familar with access/databases/writing queries, etc and is going to be VERY available for about the next week to get this working and make any adjustments the end client needs to it. Id prefer working over IM. Offering 250$ on completion.