Recurring Entries

[Sandra P]

I am designing a scheduling database for a transportation company. They have
clients who they transport on a recurring basis, like every Mon, Wed & Fri
for instance. Everything about the transport is the same each time with the
exception of the date. Is there any way to make an appointment recurring so
it doesn't have to be data entered each and every time? I am in the design
stages of the DB so I can pretty much do anything necessary to accomplish
this.

 

[fredg]

I am designing a scheduling database for a transportation company. They have
clients who they transport on a recurring basis, like every Mon, Wed & Fri
for instance. Everything about the transport is the same each time with the
exception of the date. Is there any way to make an appointment recurring so
it doesn't have to be data entered each and every time? I am in the design
stages of the DB so I can pretty much do anything necessary to accomplish
this.

Let's assume the appointment schedule is from 8/1/2008 to 12/31/2009.
More dates can be added later when needed.

Add a record to the appointment table for each date in the above time
frame. I'll assume this has already been done.

You can use the Weekday() function to determine the weekday number,
Sunday being day 1. (This can be changed within the function if a
different day is day 1.)

Then...
You can run an Update query (after you have the table and fields set
up with all of the dates, etc.).

Update YourTable Set YourTable.AppointmentWith = "ABC Delivery" Where
WeekDay(YourTable.DateField) In (2,4,6)

So, if the date is a Monday, Wednesday, or Friday, the AppointmentWith
field will show "ABC Delivery".

Save the query to re-use when additional dates are added.

Of course you could use VBA to fill the table with all the dates, and
at the same time also fill the AppointmentWith field. But that would
be a separate post.

 

[Allen Browne]

See:
Recurring events
at:
http://allenbrowne.com/AppRecur.html

The article includes a sample database that shows how to record one entry
and have the database calculate the recurrences. It also illustrates how to
handle particular instances of a recurring sequence differently (where an
instance is to be skipped or rescheduled.