That did work! Running the query in studio manager returned exactly what it was supposed to. Unfortunately, I now have an issue with Crystal Reports passing that query and returning the correct data. But that will be another issue entirely. This issue on the other hand looks to be right now. Thanks again for the help!