Entering data on a form with a new year

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with applicant information. My users are able to search for an
applicant and keep the current information by just replacing the date. I
would like to some how keep track of the records for 2005. I have produced
reports by year, however, if the date on the form is changed the record is
removed from the report for 2005. Help, please!
 
Sounds like you need to rename your current data field to something like
[CreationDate] and then add a field like [VerifiedDate]
 
We would need to see the structure of your data to help you here. I would
probably have multiple tables here. One that contains the applicant data
(name address, etc.) and another related table that contains a separate
record for every visit/contact with that applicant. This table might
include the job applying for (which would pull from yet another table), the
person making the contact or conducting the interview( pulls from yet
another table), the date of the contact. They type of contact (interview,
phone call, meeting, letter sent, etc.) and comments about the contact.

This sounds like a classic one-to-many relationship of you have an applicant
that could have multiple visits.
 
Back
Top