General discussion

  • Creator
  • #2296803



    by blader4x4 ·

    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.

All Comments

  • Author
    • #2673231

      wrong forum

      by john_wills ·

      In reply to Access

      try Technical Q & A

Viewing 0 reply threads