Good Afternoon,
I am trying to get a Max Value for a series of records that is identified by an amendment number. Here is what I tried and didn�t get the results I desired. I can create a flat file with all the information and then do this calculation in access, however I want to elimante the access step. If you have any ideas please let me know

TABLE FILE CALR
PRINT ITEM_NBR
PO_NBR
COST1
EXP_DTE
AMD_NBR
BY ITEM_NBR NOPRINT
BY AMD_NBR
IF AMD_NBR.MAX
ON TABLE SAVE AS DOWNLOAD FORMAT LOTUS
END

I am using Focus version 7.2 for DB2 tables.

Example of the Data � The Amendment numbers I need have an * beside them:

Item NBR PO_NBR Cost1 EXP_DTE AMD_NBR
44444444 AE555 0.4555 1/1/2001 1
44444444 AE555 0.4556 1/1/2003 2
44444444 AE555 0.4585 1/1/2005 *3
44444455 GB545 3.2425 3/2/2001 1
44444455 GB545 3.2499 3/2/2002 2
44444455 GB545 3.2425 3/2/2003 3
44444455 GB545 3.2425 3/1/2004 4
44444455 GB545 3.2455 3/1/2005 5
44444455 GB545 3.2425 3/1/2006 *6

Use
BY HIGHEST 1 AMD_NBR

Thanks Jack. That did the trick.