How do I count and order by unique entries?
Try this

SELECT 
    tblClient.[Printed Name], 
    tblClient.[Address 1], 
    tblClient.[Address 2], 
    tblClient.City, 
    tblClient.State, 
    tblClient.Zip, 
    tblClient.Phone, 
    tblClient.[Email Address],
   (select count(*) 
    from tblCurrent 
    where tblCurrent.[Date Ordered]&gt;#6/27/2013# 
      and tblClient.[Client Code] = tblCurrent.Client
   ) AS Qty
FROM tblClient 
ORDER BY Qty desc;