Desktop·25,154 discussions

Access

Locked

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.

Topic

wrong forum

In reply to Access

try Technical Q & A

[Author]

Replies