Table with 5 fields
Members can be in this table more than once with multiple ChangeCodes.
They can be in the table with the same codes and/or different codes.
Some members are only in the table once.
I have made a table of only members where the ChangeCode = "D"
Based on this table, I need each member to appear only once. If they are in this table multiple times, I only want the most recent EndDate record for that member. If the member has 3 "D" records all with the same EndDate, then any one of the records is OK.