Thanks Lynn! I do have a date table which serves as a calendar table and I've tried may join combinations and I still only get the two results opposed...