Calendar report

[Ngan Bui]

Anyone have a function that creates a calendar template in
the report? The calendar would be based on the date range
the user chooses and include a few fields from a table per
day.

 

[Guest]

Actually, I found Duane's website with samples of the
reports. Thanks, Duane!

I do have another question in regards to the calendar
report:

I posted this question last week to two other newsgroups
but got no reply.

I want to set up an appt module for our health
contractors. Each contractor has 2 session per day and
can take up to 24 appts per sessions. Within 48 hrs of a
day, that day is closed off from receiving any more appts,
regardess of if they have any openings.

customer service has to fill up the earliest day before
the next day is open for appts. Customer service puts in
the person's info like name, address, pick up address and
time.

Is this better to be done in Access or Outlook?

I would like to allow user's to view closed
contractors/days on a month calendar or week calendar.

Thanks.
Ngan

 

[kip]

-----Original Message-----
Anyone have a function that creates a calendar template in
the report? The calendar would be based on the date range
the user chooses and include a few fields from a table per
day.
.

my approach would be to massage the data, not fiddle with
the report. Design the report with a generic 5 week
calendar, number the boxes from 1 to 35 and their fields
as box1line1 box1line2 etc or some similar scheme. Then
create a table with matching design, and a process to
fill in the fields by calculating the box position from
the date (using the dayofweek and day number), and fill
in the fields for each day (by computing the various
field names: newtable("box"&daynum&"line"&linenum) =
appropriatevalue). Use this table for the report

Calculate the position of the first of the month, and
then you can just add the date difference to compute the
positition of subsequent days (index of 3/5/2003 = index
of 3/1/2003 + (3/5/2003 - 3/1/2003).


kip

 

[Duane Hookom]

I don't think Outlook can handle the logic/business rules as well as Access
could.