Luis - Very sorry to update you, but your query worked great. The null issue was due to bad data which we fixed and had nothing to do with the query itself, once we fixed the bad data we were able to get the correct results. Once again, many thanks!