R
Rgomez1999
Guest
Working on a database an I'm almost done with one exception:
Here's how my project looks in a database format.
[Fields]
ID Number:
Last Name:
First Name:
Counselor:
Enrollment Date in Program:
First Evaluation Date:
Next Evaluation Due Date:
Last Evaluation Date was due on:
From the enrollment date in program I added the following statement to inform me when the client is due for their first evaluation:
FirstEvaluationDate = DateAdd("m", 3, [EnrollmentDateInProgram])
Which works just fine let's me know 90 days upon admission when the first evaluation report is due.
Now the problem: I would like the person who's seeing these records be allowed to see when the Next Evaluation Due Date. Now I could simply repeat the above function, however, I want to make sure that the Next Evaluation Due Date get's updated every 90 days from the original First Evaluation Date. This is how the database needs to look like to human eyes.
Enrollment Date in Program: 04/10/2000
First Evaluation Date: 07/10/2000
Next Evaluation Due Date: 10/10/2000 (the next would be 1/10/2001; 4/10/2001 and so on)
Last Evaluation Date was due on: 07/10/2000
How do I tell access when the last evaluation date was done from either the First Evaluation Date and since 90 days have gone by from the first evaluation date to now take the next evaluation date and add the date to the Last Evaluation Date?
Any clues on how to add this to the form. I was told I could do it in a query but don't remember the exact functions. Afterwards I will create a command button that runs a query based on the field's dates for the counselor to have a hard copy.
Here's how my project looks in a database format.
[Fields]
ID Number:
Last Name:
First Name:
Counselor:
Enrollment Date in Program:
First Evaluation Date:
Next Evaluation Due Date:
Last Evaluation Date was due on:
From the enrollment date in program I added the following statement to inform me when the client is due for their first evaluation:
FirstEvaluationDate = DateAdd("m", 3, [EnrollmentDateInProgram])
Which works just fine let's me know 90 days upon admission when the first evaluation report is due.
Now the problem: I would like the person who's seeing these records be allowed to see when the Next Evaluation Due Date. Now I could simply repeat the above function, however, I want to make sure that the Next Evaluation Due Date get's updated every 90 days from the original First Evaluation Date. This is how the database needs to look like to human eyes.
Enrollment Date in Program: 04/10/2000
First Evaluation Date: 07/10/2000
Next Evaluation Due Date: 10/10/2000 (the next would be 1/10/2001; 4/10/2001 and so on)
Last Evaluation Date was due on: 07/10/2000
How do I tell access when the last evaluation date was done from either the First Evaluation Date and since 90 days have gone by from the first evaluation date to now take the next evaluation date and add the date to the Last Evaluation Date?
Any clues on how to add this to the form. I was told I could do it in a query but don't remember the exact functions. Afterwards I will create a command button that runs a query based on the field's dates for the counselor to have a hard copy.
