Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Date Diff in Access problem

Options
  • 22-03-2009 8:47pm
    #1
    Registered Users Posts: 2,777 ✭✭✭


    Have this question and don't know what to do with it.

    '' ·[FONT=&quot] [/FONT]send a renewal notice via mail merge, and if necessary a further reminder two months later. [Hint: Rather than just recording if somebody has paid their membership in a Yes/No field, use a Date field to track the expiry date. Note that some persons may have honorary membership for life, in which case you can set the expiry date as Dec 31, 2999. See the on-line help on the DateDiff() and Now() functions in Microsoft Access]. ''


Advertisement