calculation

  • Thread starter Thread starter Donna
  • Start date Start date
D

Donna

I have a graduate student database that tracks courses and requirements. A
foreign language requirement needs to be fulfilled 2 years after they start
their graduate program. Start dates are tracked as follows:
200701 = Fall, 2007
200702 = Winter, 2008
200703 = Spring 2008
200704 = Summer 2008
200801 = Fall 2008, etc. etc.
How can I get a text box to automatically calculate the due date for the
language requirement? I.e. if they started their program in 200701, their
language needs to be fulfilled by 200901.
 
This would be trivial if the columns were atomic. You would just add 1 to
the year field. To work with the mushed fields, you need to extract the
year part and then concatenate the results:

cstr(cInt(Left(SchoolQtr,4)) + 1) & Right(SchoolQtr,2)

Consider separating schoolyear from semester so that they are each in their
own column.
 
Back
Top