title: Filtering duplicates from query using complex (NOT MAX) criteria
body: <p>I have a database with multiple records for some customers, where their address changes the database adds a new record, same customer ID number, but new 'ADDCDE' with a higher index number.</p>
  
  <p>e.g. </p>
  
  <pre><code>NAME         UNIQUEID     ADDCDE  ADDRESS
  
  Customer A   ID123        Z1      Address1 Town1 City1
  Customer A   ID123        Z2      Address2 Town2 City2
  Customer A   ID123        Z3      Address3 Town3 City3
  Customer B   ID1234       Z1      Address1 Town1 City1
  Customer C   ID12345      Z1      Address1 Town1 City1
  Customer C   ID12345      Z2      Address2 Town2 City2
  </code></pre>
  
  <p>I've been able to identify all the duplicate records using query wizard,
  but what I would really like to do is remove ALL BUT the "Max" record of ADDCDE, so in this instance removing from the above records to leave the following.</p>
  
  <pre><code>NAME         UNIQUEID     ADDCDE  ADDRESS
  
  Customer A   ID123        Z3      Address3 Town3 City3
  Customer B   ID1234       Z1      Address1 Town1 City1
  Customer C   ID12345      Z2      Address2 Town2 City2
  </code></pre>
  
  <p>I'm a newbie to SQL, am mostly using the Access Query design builder but if anyone can answer this query somehow (because I need to do this often), I will figure out how and where to put it and make it work!</p>