Check out

Knowledge Base Article Number:  Q711843

HTH,

Mark Owens

Thank you very much, Adam.  Using your ideas here is the statement that works for me:

Select * from IV10200 b where b.daterecd = (select max(a.daterecd) from IV10200 a

where a.itemnmbr...