From: aahz@pythoncraft.com   
      
   In article ,   
   Trevor Guy  wrote:   
   >   
   >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.   
      
   Ditto, but I can help you (hopefully) based on my SQL...   
      
   >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.   
      
   In SQL terms, what you want is max(DateSold), but I have no clue how to   
   execute this with Paradox.   
   --   
   Aahz (aahz@pythoncraft.com)           <*>         http://www.pythoncraft.com/   
      
   [on old computer technologies and programmers]  "Fancy tail fins on a   
   brand new '59 Cadillac didn't mean throwing out a whole generation of   
   mechanics who started with model As."  --Andrew Dalke   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)