Cetin,

This works. However, if you remember I have a one to many relationship. My report lists the main EDR number and the the specific number of submittals for each EDR. So I have

12345

1
2
3
I either need a way to check the last submittal in the report. O better yet a SQL statement the produces a report of the EDR numbers with the last sumittal listed only. Can You Help with an SQL statement.

God Bless,
S. Dyke