Thanks Drew, this is very helpful. Yes I should have been more clear. I am not grouping anything. It is a set of two tables connected through a union query....