I have a table that contains address information for customer orders. When the address is changed for whatever reason, the system adds a new record to the table {oep45.seqn45} with a different sequence number (order number 12345 sequence 1, order number 12345 sequence 2, etc). There will be a new record added to the file each time the delivery address on the order is changed.

I need help creating a formula that will print only the latest record in the address file for a particular order. I can't specify which sequence to select because the table can have any number of records for a particular order depending on how many times the delivery address was changed in the system.

Any idea how I can do this? 

Thanks,

Karen

Thanks for the reply.

I know that I can sort out and suppress the records that I don't want, but I'm having a problem with the value of the suppressed rows being calculated into the order total.

Any suggestions for that?

Okay. I think I got it. Grouping based on sequence and then the totals are correct.

Thanks!