Don't know if this'll work but give it a try:
SELECT DISTINCT pricelist.ITEM,pricelist.REPL, pricelist.price, ;
MAX(pricelist.DATE) AS DATE ;
FROM price!pricelist ;
ORDER BY pricelist.DATE DESC ;
GROUP BY pricelist.ITEM ;
INTO TABLE temp.DBF
Ronald Suen
Epic Information Solutions Inc.
Ph: (780) 488-4418
Fax: (780) 488-0402