Discussion Locked
Access
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Code required for calculating a payment due date in a field that relies on two other fields, payment schedule and last payment date.
Payment schedule is:
'M'(Monthly), 'Q'(Quarterly) , 'S'(Semi Annually)or 'A'(Annually).
If payment selected is 'Q' and last payment date is 11/1/2003, when is next payment due ???
I need the next payment due field to be populated automatically based on the two other fields.
Don't forget the leap year issue.