Parade State or Scheduling Database Design

[Guest]

I have been asked to convert an Excel spreadsheet used to track employees
daily disposition (i.e. Parade State). Currently the spreadsheet lists all
employees on the left and a column for each day of the week. That way when
the managers want to know who is in for the week, on course, on a business
trip, on holidays, etc they can just scan the list.

An example might look like this:

ID Name Dept 1 Feb 06 2 Feb 06 3 Feb 06 4 Feb 06 5
Feb 06…
02 Bloggins Act Course Course Vancouver
Vancouver
03 Smith Prj Holiday Holiday Holiday
Holiday

I am attempting to convert this into an Access 2000 database, but I am have
problems trying to figure out the viewing of the records for a daily/weekly
report. I envision a table for tombstone data (employee ID, name,
department, etc) and a sub-table to record their daily disposition/event with
only two date fields (a start date and end date) for the event, vice a date
for every day of the year which would be a nightmare to administer. Plus two
fields for the type and sub-type of disposition event and a comments field.

A problem that I can foresee is when an event can span multiple days
(holidays, courses, business trips), and how to get a query/report to view
the entry similar to Excel (a column representing each day). Not sure if I
am explaining this right, but essentially a scheduling type of database would
be close.

Not sure of the best way to tackle this. If someone has an example of
something similar that they can share, or point out a best course of action
to take, I would greatly appreciate it.

Thank you

 

[PC Datasheet]

Rod,

I have a 7-Day Calendar module that would do this for you. I could implement
it for you for a very reasonable fee. As the name implies, there is a 7-Day
calendar form that looks like a typical calendar. A pop-up calendar first
appears, you select day 1 and the form appears with seven days starting with
the day 1 you pick. In the menu at the top of the screen you can advance the
week by 1 day or 7 days and go back 1 day or 7 days. I will set it up so you
can select the Parade State in a drop down list in the menu and then each
day of the calendar will fill with the names of employees matching the
selected Parade State for that day. If an employee in a Parade State spans
multiple days, the employee's name will appear in multiple days on the
calendar. I have implemented this calendar module for numerous customers.

You are probably going to see one or more libelous responses to my response
to you. Ignore them and contact me if you would like my help. You will be
well satisfied working with me.

 

[John Marshall, MVP]

You are probably going to see one or more libelous responses to my
response to you. Ignore them and contact me if you would like my help. You
will be well satisfied working with me.

PC Datasheet

Cute stevie! These newsgroups are for free support not for you to try to
seperate users from their money.

To the OP: PCD has a long history of not being completely honest, use
extreme caution when accepting hs help. It is not for free.

John... Visio MVP

 

[StopThisAdvertising]

You are probably going to see one or more libelous responses to my response
to you. Ignore them and contact me if you would like my help. You will be
well satisfied working with me.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1100 users have come to me from the newsgroups requesting help
(e-mail address removed)

--
To Steve:
Over 350 users from the newsgroups have visited the website to read what kind of a 'resource' you are...

To the original poster:

Most people here have a common belief that the newsgroups are for *free exchange of information*.
But Steve is a notorious job hunter in these groups, always trying to sell his services.

Before you intend to do business with him look at:
http://home.tiscali.nl/arracom/whoissteve.html (updated)

Arno R