From: trevor@ewh.co.uk   
      
   Hi,   
      
      
      
   It ages since I did anything with Paradox and I have what I think is silly   
   problem that I just can't get my head around.   
      
      
      
   I have a 60k record table with two fields, ProductCode and DateSold; there   
   are many entries for each ProductCode with the corresponding date of sale.   
   I want to query the table to produce a results table giving the ProductCode   
   and the most recent DateSold for each product.   
      
      
      
   I'm sure this should be easy but I'm damned if I can see how to do it, can   
   any help?   
      
      
      
   Regards,   
      
   Trevor   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)