AnsweredAssumed Answered

A schedule

Question asked by storywizard on Oct 26, 2009
Latest reply on Nov 5, 2009 by storywizard

Title

A schedule

Post

<!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:WordDocument&gt;   &lt;w:View&gt;Normal&lt;/w:View&gt;   &lt;w:Zoom&gt;0&lt;/w:Zoom&gt;   &lt;w:PunctuationKerning/&gt;   &lt;w:ValidateAgainstSchemas/&gt;   &lt;w:SaveIfXMLInvalid&gt;false&lt;/w:SaveIfXMLInvalid&gt;   &lt;w:IgnoreMixedContent&gt;false&lt;/w:IgnoreMixedContent&gt;   &lt;w:AlwaysShowPlaceholderText&gt;false&lt;/w:AlwaysShowPlaceholderText&gt;   &lt;w:Compatibility&gt;    &lt;w:BreakWrappedTables/&gt;    &lt;w:SnapToGridInCell/&gt;    &lt;w:WrapTextWithPunct/&gt;    &lt;w:UseAsianBreakRules/&gt;    &lt;w:DontGrowAutofit/&gt;   &lt;/w:Compatibility&gt;   &lt;w:BrowserLevel&gt;MicrosoftInternetExplorer4&lt;/w:BrowserLevel&gt; &lt;/w:WordDocument&gt; &lt;/xml&gt;&lt;![endif]  --><!--  [if gte mso 9]&gt;&lt;xml&gt; &lt;w:LatentStyles DefLockedState=&quot;false&quot; LatentStyleCount=&quot;156&quot;&gt; &lt;/w:LatentStyles&gt; &lt;/xml&gt;&lt;![endif]  --><!--  /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal      {mso-style-parent:&quot;&quot;;      margin:0in;      margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:12.0pt;      font-family:&quot;Times New Roman&quot;;      mso-fareast-font-family:&quot;Times New Roman&quot;;} @page Section1      {size:8.5in 11.0in;      margin:1.0in 1.25in 1.0in 1.25in;      mso-header-margin:.5in;      mso-footer-margin:.5in;      mso-paper-source:0;} div.Section1      {page:Section1;}   --><!--  [if gte mso 10]&gt; &lt;style&gt; /* Style Definitions */ table.MsoNormalTable      {mso-style-name:&quot;Table Normal&quot;;      mso-tstyle-rowband-size:0;      mso-tstyle-colband-size:0;      mso-style-noshow:yes;      mso-style-parent:&quot;&quot;;      mso-padding-alt:0in 5.4pt 0in 5.4pt;      mso-para-margin:0in;      mso-para-margin-bottom:.0001pt;      mso-pagination:widow-orphan;      font-size:10.0pt;      font-family:&quot;Times New Roman&quot;;      mso-ansi-language:#0400;      mso-fareast-language:#0400;      mso-bidi-language:#0400;} &lt;/style&gt; &lt;![endif]  -->

I need a schedule for volunteers.

 

The database I have built is for a production unit making audio recordings for blind and learning disabled students at a major university. The management want to have a better idea of how many hours per week each of the sound recording booths are being used and why and when volunteers do not show up. There is a personell table that has all of the volunteer information on it. This table is linked to a production schedule which lists in a portal all of the tasks that go into producing a text.Other tables have text title information and info about the students...

 

I can imagine a table with each booth as a field,  but then how would I then go about constructing the rest of the table to produce the information I need?

 

 

************************************************************************

 

We have eight sound booths

 

The hours of operation  are from 8:30 to 4:30 Monday to Friday

 

The volunteers work 2 hour shifts

 

They are inconsistant with start times, some start on the hour, some at the mid point.

 

We need to have a name field.

 

We need to show the shift that the volunteer has signed up for.

 

We need to show if they are on vacation.

 

We need to show if they do not show up for a shift and did not let us know.

 

We need to show when a prospective volunteer is doing an audition.

 

We need to show when a volunteer is doing a “drop-in” shift.

 

************************************************************************

 

I hope someone can help me here, lol…

 

Storywizard

Outcomes