Bill ,

Thanks for the post. The field names you provided actually worked perfectly. The only issue is this is returning all of the records in ICSUPL01.DBF (Inventory Supplier) table and I only need the record that corresponds to the last receipt of the item (LRECDTE). So ideally the resulting record set would only have one record for each inventory item.

TIA

Jeff