Question:
How can I group the records returned by a query whose values were repeated in all the fields of that row?
How can I group the records returned by a query whose values were repeated in all the fields of that row?
Solution:
To do so, you need to use SQL’s GROUP BY clause in all the fields to be grouped. This can be done also by checking Group By option (for all the fields) on the Query’s Fields tab.
