I have a question,

The record in the database is:
DPS RepYear DPS1 RepYear1 DPS2 RepYear2
1 2001 4 2004 3 2003

I need to create a form to show the data by RepYear and in Descending Order:

4 2004
3 2003
1 2001

First, whether we have a function to order according to the year?
Second, the difficulty is if I found RepYear1 is the most recent. How can I retrieve the DPS1. The DPS1 is the filed name.