Vacation schedule

  • Thread starter Thread starter desperate in MS
  • Start date Start date
D

desperate in MS

have a database in Access that I have entered vacation days in
A ID
B Name
C Craft
D Supervisor
Now get the though part...
E through say J have their chosen weeks for vacation
ie..E 3/23-26/2009....F 5/11-14-2009 and like that

Here I am lost...what I would like to do is have a report/form (something)
that I can display those folks and date for any givin Month. We are trying to
track how many folks we have out each week of each month. Maybe even a report
that will break out the months then weeks for the whole year? I could use ANY
suggestions out there.
 
have a database in Access that I have entered vacation days in
A ID
B Name
C Craft
D Supervisor
Now get the though part...
E through say J have their chosen weeks for vacation
ie..E 3/23-26/2009....F 5/11-14-2009 and like that
Click to expand...

It sounds like you're treating Access as if it were an Excel spreadsheet, with
columns A through J.

Excel is a spreadsheet, best of breed.
Access is a relational database.

THEY ARE DIFFERENT!
Here I am lost...what I would like to do is have a report/form (something)
that I can display those folks and date for any givin Month. We are trying to
track how many folks we have out each week of each month. Maybe even a report
that will break out the months then weeks for the whole year? I could use ANY
suggestions out there.
Click to expand...

Use Access as it was designed, with (at least) two tables:

Employees
EmployeeID <primary key>
LastName
FirstName
Craft <probably a link to a Crafts table>
... <other biographical details>

VacationSchedule
EmployeeID <link to Employees>
StartDate
EndDate
Comments

If a particular employee is planning to take two three-day and one eight-day
vacations, there'd be three records for her ID in the VacationSchedule table,
with the starting and ending dates of those periods.

You might want to look at some of the introductory material in:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials
 
Concur with John.

Additionally, since the values you have entered into the fields E->J don't
all have the year, and don't all contain the month, you have made this
extremely complicated. If I thought there was any consistency in the values
of these fields, I would recommend writing a function to parse the data into
Start and End dates, but from your example, I'm not certain there is a
consistent format.

For example, I assume the 3/23-26/2009 means 3/23/09 - 3/26/09
and 5/11-14-2009 means 5/11/09 - 5/14/09

This may have been a typo, but the latter example has a hyphen instead of a
"/" to separate the day and the year.

How are you entering the dates when they span a month 5/28-6/3/09?

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top