Recurring Entries

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.

On Thu, 24 Jul 2008 17:00:15 -0700, Sandra P wrote:

> 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.

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail