Search results for query: *

There is no union but there is a join between two subqueries. Just to clarify, the list works if the unique identifier is included. If I were to remove it from the list report it would also only display the unique rows. It is behaving something like Impromptu with its Eliminate Duplicate Rows...

I have built a query listing attendance, seats available by educational institute. I would like to display the results in a crosstab. When I use the same query in a list report, I get a different result than if I summarize in a crosstab. I have noticed that any records that have the same...

This is a bit late and you probably have it fixed but here is what I would try. I am guessing that you have removed the calculated columns from the report display but they are still in the query. Go into Report/Query/Data and remove the calculated fields a b and c. They will still be used in...