T
Todd
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!
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!