I have an aggregate query in access. When viewing the query in datasheet view, it does not group by a specific column (which does not even appear). Rather, I have two separate calculated fields that contain iifs based on that field, and show the sum of that value. However, in my continuous form that is based on that query, I get two lines, one for each possible value of my field. Why is that, and how can I fix it?