calculation

[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.

 

[Pat Hartman]

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.