Schedul future dates in ms access append query

By grahame ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

There are a number of functions to help

by Tony Hopkinson In reply to Schedul future dates in m ...

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.

Related Discussions

Related Forums