I've got a table where applicant data is entered (via a form) everytime an
application is submitted.  Each time a person submits an application it is
enteed as a new submission, thus I can have duplicate records on a person,
except for the submission date and maybe the address if it changed but it is
still a new record.  

My questions are how can I query the table data to only show the most recent
applications without having duplicate records on a person?  Another field in
the table is the SSN.  

The other question pertaining to the same query is say that an application
was submitted on 2/28/06 and they were due resubmittal in 2 years (which all
would be).  How can I have the same query also sort to show from one year out
of the resubmittal date.  EX: on 2/28/07 this persons record will keep
showing up until a new application was submitted and entered in with a new
submission date.  

FYI:  I didn't create this dbase but was asked to help out.  I probably
would have had the structure a little different.

Any help is appreciated!