MS Query, command View-Query Properties
 

Hi there,

In View-Query Porperties you have options for:
- Unique Values
- Group Record

The first option reduces the result set to one row for field values a-b-c.
That's clear.

But what about Group Records? To me, it looks similar.

And how do these two options cooperate / interfere with the [Totals] button
which sets Sum, Avg etc. to the selected column.

Thanks for a reply.

Frans