Re: set a payment date of 2nd of month
- From: "Ken Snell [MVP]" <kthsneisllis9@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 14 Jun 2009 21:30:46 -0400
I have a function that can be used for such recurring dates. Put the
function in a regular module, and call it from your update query.
DateForFixedDayOfMonthYear
http://www.accessmvp.com/KDSnell/VBA_Functions.htm#FixedDayMthYr
--
Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/
"Sarah" <Sarah@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AC14FC89-8A69-46EA-B5B5-2A3ABCB60FE2@xxxxxxxxxxxxxxxx
I am trying to use an update query to mark all purchase invoices received
in
one month to be paid on the 2nd of the following month. I can't work out
how
to fix the payment date as the 2nd of that month when the date of the
invoices varies. Can anyone help please?
.
- References:
- set a payment date of 2nd of month
- From: Sarah
- set a payment date of 2nd of month
- Prev by Date: Re: Problem with multiple selection query
- Next by Date: Re: Update access table to sql table
- Previous by thread: Re: set a payment date of 2nd of month
- Next by thread: One query for report and Excel
- Index(es):
