title: MS Access Query : Consolidate rows with same data in Specific Field Columns
body: <p>i have ms access query with several fields and columns, some of the data in the tables that I query shows up multiple times. I would Like to eliminate duplicates based on 4 columns - if this 4 columns are identical in more rows I would like them to be displayed only one time. Is this possible?
  See attached example: <a href="https://i.stack.imgur.com/TRcVE.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/TRcVE.png" alt="enter image description here"></a><br>
  the first 2 entries should be consolidated into 1 entry.</p>
  
  <p>Br,</p>