query sort on date

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

Todd

Thanks for the info. It did work for the first part of my question and I
then figured out the second part? Again Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top