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

Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Date Diff in Access problem

dmcg90 · 2009-03-22 19:47:15

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…

22-03-2009 7:47pm

#1
dmcg90

Registered Users, Registered Users 2 Posts: 2,779 ✭✭✭

Join Date: October 2008

Posts: 2500
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]. ''

Tagged:

datediff date diff access

0