Question Locked

Schedul future dates in ms access append query

0 helpful

2 replies

by grahame Apr 4, 2009 last reply Apr 5, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi can anyone help, I am trying to write a query where I can schedule future dates for visits to be carried out on spacific days of the week.

2 replies

Clarifications

DateAdd and DatePart would be a good start.
How you knock it up depends on how complex your schedule system is.

First Wednesday of the following month for instance, is going to be easier to do in a VB macro than SQL.

This discussion is closed to new replies.