L
Legacy 15162
Guest
I have a table which I append 3 times a week which contains weekly schedules for employees. Sometimes a schedule may change for the same week between append periods. Is there a way to only select the most current data? It would look something like this.
Store Year Period Week Report Date
111111 2004 3 2 02/17/2004
111111 2004 3 2 02/18/2004
Store Year Period Week Report Date
111111 2004 3 2 02/17/2004
111111 2004 3 2 02/18/2004