Standard Jet DBnb` Ugr@?~1y0̝cßFN`7/ߜ(a-`&{6߱oC43Fy[.|*"|Kg0Pf_Љ$g'DeFx -bT4.0J)#Bdv#x?{}~ Y'S 99 Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OYsS8Y Y Y  Y 2ACMFInheritableObjectIdSID  AtYObjectId YBSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -YSY Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship   YYYszObject$szReferencedObjectszRelationshipYv1b N  : k & W  C t/  P@@8@8@@  f@@@ @@@ ifm+Q`f^dvQQ+J^^+kWYSmk+fQi+OJv5`dO`JYb$OJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^QkiQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^mJL^Qk+m`fM^f>:6@88+m`fM^f>:8>B8!+m`fM^f>D>FF8+m`fM^f@HHFF8`kvkJMMQkkdL[QMmk`kvkJMMQkku`^`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhiv+Q`f^dvQQ+J^^+kWYSmk+fQi+OJv"hiv+Q`f^dvQQ+^YkmYbUk3hiv+Q`f^dvQQ+mdmJ^+Wdoik+fQi+OJvhiv+Q`f^dvQQ+mdmJ^+sQQ\^v+Wdoik-hivUQmOJY^vkWYSmOoiJmYdbkhivUQmOJY^vkWYSmk&hivsQQ\^vWdoimdmJ^kLvQ`f^dvQQmvfQ.mL^OQfJim`QbmkmL^Q`f^dvQQmL^Q`f^dvQQOQfJim`QbmmL^kMWQOo^QMiQJmYdbmL^kWYSmkmL^kWYSmmvfQkm`fOJmQ*JMMQkk^Jvdom`kvkOLko``JivYbSd okQiOQSYbQO ko``JivYbSd okQiOQSYbQO   @ @ @ @ @      ! " $&-.35 "().1GNm*  @ @ @ @ @ @ @ @ @ @ @ @ @ @ !"#$%&'()*+,-./0123 3 3 3 3 3 3 3 3 33333.3/303132333@3A3B3C3D3E3F3G3HZ[\  456789 : ; <"I"J"K(R(3(3)@)A)B.C.D.E1F1G1HGOGPGQN3N3N3m3%m3&m3'      Y @ @ @ @ @ @ @ @ @ @ @ @ @                Q T R S W  U  V ~HCEF>?@ABDGn   nl'~z{|} l(גg^`aXYZ[\]_b c d e fד  i2#$%&'()* + , - . /01jjj   }6d _ Z 7 T  _ e  ɣ>6\ńń~~11ĬììSSSò  € r@ r@qry_Employee r@ r@rpt_Employee_All_Shifts_Per_Dayw@K^lll```````^ @u~r@6xr@qry_Employee_Listingswp  @`@LpddXLLLLLLJ ` gI}r@sqnr@qryWeeklyHourTotalsByEmployeeTypew0R@I`@ ||pddddddb `o;)}r@!qr@qry_Employee_Total_Weekly_Hourswߧ$@ ^`@ xxl``````^ `m ^|r@كr@tmpDatew+@<<<0000000. @ur@كr@qryGetDailyShiftsw߫Bۋ@`@h\\PDDDDDDB ` jur@jur@modMainw0000000000.  br@Pr@qry_Employee_All_Shifts_Per_DaywH@D`@xll```````^ @ KLbr@Obr@~TMPCLP421461w@|@^THH<<<<<<<: @N`+q@: q@tblScheduleCreationw@VTTTHHHHHHHF @(Yp@* p@tblDepartmentswߴ@JJJJ>>>>>>>< @GWp@2p@tblEmployeeDepartmentw;@)JXXXLLLLLLLJ @"X|8n@#Qq@~TMPCLP599881wq@LHHH<<<<<<<: @ 9 ^n@aңr@AccessLayoutw4MR2KeepLocal T"@8zz:::::::8 @1[]n@!q@~TMPCLP474881w@LHHH<<<<<<<: @.\C]n@P瞅q@~TMPCLP420511wK@EHHH<<<<<<<: @)o]n@xq@tblShiftTypesw@CHHH<<<<<<<: @ @[ ]n@Lq@tblShiftsw @?@@@44444442 @l23\n@l23\n@MSysAccessXMLw4MR2KeepLocal  T|||<<<<<<<: @b/\n@&=q@tblEmployeewv@DDDD88888886 @ć\n@ć\n@DataAccessPagesw@@@@@@@@@@> ć\n@ć\n@SysRelw.........., ć\n@ć\n@Modulesw0000000000. ć\n@ć\n@Scriptsw0000000000. ć\n@ć\n@Reportsw0000000000. ć\n@ć\n@Formsw,,,,,,,,,,*  ć\n@ć\n@UserDefinedwA@DDD88888886 @ ć\n@ć\n@SummaryInfowb@DDD88888886 @e\n@`\n@MSysAccessObjectswDDDDDDDDDDB <\n@<\n@MSysRelationshipsvDDDDDDDDDDB <\n@<\n@MSysQueriesv88888888886 <\n@<\n@MSysACEsv22222222220 <\n@<\n@MSysObjectsv88888888886 <\n@<\n@MSysDbw@(:::......., @<\n@<\n@Relationshipsv<<<<<<<<<<: <\n@<\n@Databasesv44444444442 <\n@<\n@Tablesv.........., J^{hUB/A S @ ,  |  B /   l Y 2 o\I"r_K8%taaaaN'v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v (w Gv Gu Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p Gw "v "u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p "w 1v 1u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p 1w .v .u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p .w )v )u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p )w  v  u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p  w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v v v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p Tu Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p Tu Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p v w w w v w v w w w w  LVALsО]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]]σ΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃΃MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormMR2ValidationRuleValidationTextOrientation FilterOrdMR2ValidationRuleValidationTextOrientMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTags  b Z Uz~`E2Jo[]n@p9tblEmployeeShiftsfTəG+fS!z~`E2JoEmployeeNumberz~`E2JoSundayTimeInz~`E2JoSundayTimeOutz~`E2JoMondayTimeInz~`E2JoMondMR2GUID@"EmployeeNumber QS`gkAe8FiscalYear \7g:%DtMR2GUID@"EmployeeNumber QS`gkAe8FiscalYear \7g:%DtD& NumberOfSickDays ֔ZHr DVKMR2&ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatCaptionSmartTagsInputMaskDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompression=    Ur{IK2GMR2MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultView:  <   MR2ANSI Query Mode(Themed Form ControlsAccessVersion BuildProjVerN    08.50  #MR2( ReplicateProject MR20 Title AuthorCompany. db1    Y NY Y DzDataIDDD`pȲYAOIndexv1@,   @ @F  \ b h g_K["TwXccessObjectswDDDDDDDDDDB K[ࡱ>  Root Entry@@[fw2PropData Forms @Q\@Q\Reports!@Q\@Q\  %6*,$<8&().+-a/213457#EFHIJM^_0Root Entry@@[fw2PropData Forms @Q\@Q\Reports!@Q\@Q\ % 6*,$<8&().+-a/213457#EFHIJM^_0DirDataCopy&' DataAccessPages @Q\@Q\Databases @Q\cOO\0 @Q\&\Blob b_ResultsZT  G  eld Ctl1_10_2009_Label1/10/2009_Labeld CtBrpt_Employee_All_Shifts_Per_DayDqry_Employee_All_Shifts_PerdmmdeK[fgjmnopd ddd 0CB0 1CB01/16/20093 :D55_Day1At4.1/17/2009hqClouBqry_Employee_All_Shifts_Per_DayDqry_Employee_All_Shifts_Per_Day1pd dddd 0CB0 1CB0fmmmmmmmmmmfͬdb"2F0PageHeaderSectionuModules@Q\@Q\Scripts@Q\@Q\VBA@Q\cwCmdbars@Q\@Q\BlobDeltaPropData PropDataPropDataCopyCustomGroups @Q\@Q\DirDataVBAProjectP\cwAcessVBAData6 BlobDeltaPropDataPropDataPropDataCopy7  !"#$%&()*+,-./023498:;<=>?@ABCDEFGHIJKLMNOPSTUVWXYZ[\]^_`abcdefshjklmnopqrtvQwxyz{|}~RA@ 1B B,*K!)+BBReport_rpt_Ctstabam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBAK[6\VBE6.D 0CB0iftsodMain=22, 29, 950, 472, Report_qry_Crosstab_Results=44, 58, 90#fdwIhdwDirData (HBlob %'TypeInfo"$VBAPX\cwPROJECTwmRPROJECT_VBA_PROJECT1ijMSysDbmodMain-2EE1-4F6A-8811-0D6D55B4C233}" Name="db1" HelpConID="{25458778-2EE1-4F6A-8811-0D6D55B4C233}" Module=modMain Name="db1" HelpContextID="0" VersionCompatible32="393222000" CMG="6A68D9714775477547754775" DPB="D4D667E3BB4CBC4CBC4C" GC="3E3C8D859D8506860686F9" [Host Extender Info] &H00000001={3832D6b_ResultsZT  G  eld Ctl1_10_2009_Label1/10/2009_Labeld CtBrpt_Employee_All_Shifts_Per_DayDqry_Employee_All_Shifts_Permmdefgjmnopd dddu40-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] mrU employeeNumber shiftDatekh%^*\G{000204K*mrU~~~~~~~~~g p>G: ٚ  a Y172, 501, Report_qry_Crosstab_Results=44, 58, 972, 501, LL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLB#Microsoft Access 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}Yesalid = YesmodMainmodMainport_rpt_Crosstab_ResultsReportf YrN'Y  Y dY Y& Y  Y Y Y Y Y Y Y Y  Y Y Y $Y ,Y 4Y <Y  DY! LY" TY# \Y$ dY% lEmployeeNumberEmployeeName ActiveFullTimeDayOffMondayDayOffTuesdayDayOffWednesdayDayOffThursdayDayOffFridayDayOffSaturdayDayOffSunday(ShiftStartTimeMonday$ShiftEndTimeMonday*ShiftStartTimeTuesday&ShiftEndTimeTuesday.ShiftStartTimeWednesday*ShiftEndTimeWednesday,ShiftStartTimeThursday(ShiftEndTimeThursday(ShiftStartTimeFriday$ShiftEndTimeFriday,ShiftStartTimeSaturday(ShiftEndTimeSaturday(ShiftStartTimeSunday$ShiftEndTimeSunday|||YPrimaryKeyv1@@  @ @666 6 6 6  6  6 6 6 6666666S Y+aNY l Y DY @ Y  Y 1 Y 1aId LValueObjectGuidObjectNameProperty Valuea1a11a܉a1a11a܁a1a11a܁YYYId$ObjectGuidProperty$ObjectNamePropertyHv1b@     YN !!Y Y  Y Y Y  Y (Y ShiftDateEmployeeNumberShiftStartTimeShiftEndTimeShiftTypeNumberShiftIDShiftValid&4&4!A4&YShiftIDPrimaryKeyShiftIDvvvvv1 )YlN##Y Y Y Y  EmployeeNumberFiscalYear(NumberOfVacationDays NumberOfSickDays%#%4#&YY NumberOfSickDays(NumberOfVacationDaysv1@ , d0`, \ ( X $ T P  L  |HxDt@ p<l8h4d0`s@ =B> eeq@ UUUUUU??]f9B eeq@UUUUUU??X}Sf9B eeq@??Wf9B q@UUUUUU??Q}Sf9B eeq@?UUUUUU?'*9B eeq@UUUUUU??e*9B eeq@UUUUUU??d*9B eeq@UUUUUU??c*9B eeq@UUUUUU??b*9B eeq@*9B eeq@UUUUUU??`*9B eeq@UUUUUU??_*9B eeq@UUUUUU??^*9B eeq@ UUUUUU??]*9B eeq@ *9B eeq@ *9B eeq@ *9B eeq@ *9B eeq@UUUUUU??X*9B eeq@*9B q@UUUUUU??Q*9B eeq@8B eeq@?UUUUUU?"8B eeq@UUUUUU??d8B eeq@8B eeq@UUUUUU??b8B eeq@UUUUUU??a8B eeq@UUUUUU??`8B eeq@UUUUUU??_8B q@UUUUUU??^8B eeq@ 8B eeq@ UUUUUU??\8B eeq@ UUUUUU??[8B eeq@ 8B eeq@ 8B eeq@8B eeq@UUUUUU??W8B q@UUUUUU??Q8B ee`q@?UUUUUU?>8B ee`q@t8B ee`q@UUUUUU??d8B ee`q@??>8B ee`q@UUUUUU??b8B ee`q@UUUUUU??a8B ee`q@UUUUUU??`8B ee`q@t8B ee`q@t8B ee`q@ UUUUUU??]8B ee`q@ t8B ee`q@ UUUUUU??[8B ee`q@ t8B ee`q@ UUUUUU??Ĉ8B `q@UUUUUU??X8B `q@UUUUUU??W8B `q@UUUUUU??Q8B @q@UUUUUU??gUw8B @q@?UUUUUU?tw8B @q@UUUUUU??dUw8B @q@$w8B @q@UUUUUU??bUw8B @q@UUUUUU??aUw8B @q@$w8B @q@UUUUUU??_Uw8B @q@UUUUUU??^Uw8B @q@ UUUUUU??]Uw8B @q@ UUUUUU??\Uw8B @q@ UUUUUU??[Uw8B @q@ $w8B @q@ $w8B @q@UUUUUU??XUw8B @q@UUUUUU??WUw8B @q@$w8B " "   x@ ' tblemployee'''  tblemployee'''  tblshiftstblemploy tblshiftstblemployeef tblshiftstblemployee tblshiftstblemployee tblshiftstblemployeef@E9#     %Y N++ Y  Y d DepartmentNumberDepartmentNamerM+9SIYPrimaryKeyPrimaryKey/Y  N** Y  Y dShiftTypeNumber(ShiftTypeDescriptionA*,YPrimaryKeyPrimaryKeyvv1 @ @vv1<< ) @--------- ) _,Nd; Vacation Day"   Berevment Leave(  > Sick Day Not Paid,   Add Day To Bank(   Sick Day Not Paid,   Sick Day Paid$   Additional Day Off With Pay@   Regular Day Off(   Regular Shift$  aY = wszN//Y Y Y  Y dShiftDateStoreOpenStoreClose Notes/0ЉYPrimaryKeyv1 .KY N22Y Y EmployeeNumberRegularDayOffdvKvcO<) ͌͟͟    x e eeeeeR ˵ > +  ʎʎʎʎʎʎʎʎʎʎʎ{  g T A ȷv w u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w mv mu Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p mw v u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p w  w  u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p  v  v  u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p  w  v  u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p  w Nv Nu Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p Nw (v (u Ȋf4rYy%3wN\+5iҰ7IXC#>.ի ]Ǜ}tg@KWoO)gŒ-p@+sڄ_p  LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightR  <    (=cCń  UlY"FݗUكr@||tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDateUL@}Bm V r{IK2GEmployeeNumber   E Shifts      ??MpxЯm r@Oϋe;Ϯ!  v [ C *  |^'UUUUUU???UUUUUU??UUUUUU?janice~~~~v ?'UUUUUU??UUUUUU??UUUUUU??UUUUUU??UUUUUU????vvvvv ?'?UUUUUU??UUUUUU?UUUUUU??????amanda~~~~v @'UUUUUU??UUUUUU??UUUUUU??UUUUUU??UUUUUU??chris kv '??UUUUUU????chris hv ?'UUUUUU??UUUUUU??UUUUUU??UUUUUU??UUUUUU????carol}}}}v 'UUUUUU??UUUUUU??UUUUUU??UUUUUU????dean||||v 'UUUUUU??UUUUUU??UUUUUU??UUUUUU????ted{{{{v 'UUUUUU??UUUUUU??UUUUUU??UUUUUU????rob{{{{v @'UUUUUU??UUUUUU??UUUUUU??UUUUUU????bob{{{{v @' UUUUUU??UUUUUU??UUUUUU??UUUUUU????derm||||v ' UUUUUU??UUUUUU????Jamie}}}}v @ ?' UUUUUU??UUUUUU??UUUUUU??????Krisjanv ' ??brian}}}}v ` ?& UUUUUU??UUUUUU????brad||||v ?'UUUUUU??UUUUUU??UUUUUU??UUUUUU????jeff||||v 'UUUUUU??UUUUUU??UUUUUU??????greg||||v Krisjan23 Bob40 @jeff32greg23rick01; LVALMR2JODBCTimeoutMaxRecordsRecordLocksRecordsetTypeOrientationNameMapDefaultViewGUIDDOLRowHeightColumnOrder FilterOrderByOrderByOnColumnWidthColumnHidden <     x[EAt4.6 . U(=cCńكr@P܎qryGetDailyShifts ??MpxЯ(=cCńShiftsl81Hz d(=cCńEmployeeNamef1MN3Kkg(=cCńShiftDate   :  8& qry.EmployeeName  W1/10/2009     &z;Mr`W1/11/2009     7J>aCU1/5/2009     woCX6U1/6/2009     P]Q1H\~ok,U1/7/2009     Y:*MJrBU1/8/2009     ~+eN/cFU1/9/2009     'NbݞLNW0U߉TB<qryGetDailyShifts.EmployeeName  61/12/2009 IW@AH)Lp61/13/2009 cMƸ<61/14/2009 1 ߗAЯ& 61/15/2009 EG7!61/16/2009 9-McqoG61/17/2009 3 :D55/61/18/2009 hqClouLVALʾtmpDateyee in Design view qryGetDailyShiftDurationsyeeTypeCreate form in Design viewCreate report in Design viewCreate data access page in Design viewmodMainU? ( @:::::::::( OOOmS=MEC Manager Print = < ; Rentals PA Guitar (Drums (Keys (Band )Ǐ Remove Day From Bank2  LVALMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredIMEModeIMESentenceModeSmartTagsDecimalPlacesDisplayControl}    Uw҂:Fka\q@tblShiftsf1MN3Kkgw҂:FkaShiftDate6 -NI2\w҂:FkaEmployeeNumber)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTime6lCgGaQHaw҂:FkaShiftTypeNumberR_&ObI8 Olw҂:FkaShiftIDok>nH=`sw҂:FkaShiftValid  w҂:Fka. &tblShifts.ShiftDateShiftDate          f1MN3Kkg mm/dd/yyyy"EmployeeNumber         0  m 6 -NI2\|"ShiftStartTime          )qEN"~xShiftEndTime          ؚUpM%_^k։$ShiftTypeNumber         0  m 6lCgGaQHaShiftValid       Yes/No  j ok>nH=`sShiftID  @     shiftid is composed of the date + starttime + employee number so 10/10/08 at 930 am with employee number 1 would be 10100809301   0  m R_&ObI8 Ol LVALMR2JODBCTimeoutMaxRecordsRecordLocksRecordsetTypeOrientationNameMapDefaultViewGUIDDOLRowHeightColumnOrder FilterOrderByOrderByOnColumnWidthColumnHidden <     x[EAt4.6 . U(=cCńكr@.qryGetDailyShifts ??MpxЯ(=cCńShiftsl81Hz d(=cCńEmployeeNamef1MN3Kkg(=cCńShiftDate   :  8& qry.EmployeeName  W1/10/2009     &z;Mr`W1/11/2009     7J>aCU1/5/2009     woCX6U1/6/2009     P]Q1H\~ok,U1/7/2009     Y:*MJrBU1/8/2009     ~+eN/cFU1/9/2009     'NbݞLNW0U߉TB<qryGetDailyShifts.EmployeeName  61/12/2009 IW@AH)Lp61/13/2009 cMƸ<61/14/2009 1 ߗAЯ& 61/15/2009 EG7!61/16/2009 9-McqoG61/17/2009 3 :D55/61/18/2009 hqClou  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @8w$$K8w$$N8w$$O8w$$U8w$$X8wUW$L8wUX$M8wU[$P8wU\$Q8wU]$R8wU^$S8wU_$T8wUa$V8wUb$W8wUd$Y8wUg$[8wt$Z8t$`8t$b8t$d8t$e8t$k8Q$\8W$]8X$^8[$a8]$c8`$f8a$g8b$h8d$j8>$i8>$l8ĩ$_8$o8$p8$q8$t8$z8$}8Q$m8W$n8[$r8\$s8^$u8_$v8`$w8a$x8b$y8d${8"$|9*$9*$9*$9*$9*$9*$9*Q$~9*X$9*]$9*^$9*_$9*`$9*b$9*c$9*d$9*e$9*'$9fEL9fEL9fEL9fEL 9fEL 9fS}Q$9fS}X$9fS}]9fS}^9fS}_9fS}`9fS}a9fS}b9fS}d 9fW$9fW 9f]$999! 9'9(9)9*9+9,9-9.9/909192959f9z9z9z 9z!9z"9z#9z$9z%9z&9z'9z(9z)9z*9z+9z,9z-9z.:/:2:3:9:<:#W0:#X1:#[4:#\5:#]6:#^7:#_8:#a::#b;:#d=:#g?:'>:TtD:TtF:TtH:TtI:TtP:TQ@:TWA:TXB:T[E:T]G:T`J:TaP:TbP:TdP:TP:TP:TJC:K>P:K>P :K>P :K>P :K>P:K>P:YoQP:YoWP:Yo[P :Yo\P :Yo^P:Yo_P:Yo`P:YoaP:YobP:YodP:]P:P:P:P:P:P:P":9QP:9XP:9]P:9^P:9_P :9`P!:9bP#:9cP$:9dP%:9eP&:a'P';ҊP,;ҌP.;ғP5;җP8;QP(;XP*;]P/;^P0;_P1;`P2;aP3;bP4;dP6;"P);" P-;"P7;<P+;CPG;CPI;C)X!P9;C)X'P:;C)X(P;;C)X)P<;C)X*P=;C)X+P>;C)X,P?;C)X-P@;C)X.PA;C)X/PB;C)X0PC;C)X1PD;C)X2PE;C)X5PH;C-PF;~fPJ;~fQ;~fQ;~fQ;~fQ;~fQ;~fQ;~fQ;~fQ;~fQ;~fQ ;~fQ ;~fQ ;~fQ ;~fQ ;~fQ;~fQf>;fD;+Qf5;+Wf6;+Xf7;+[f:;+]f<;+`f?;+af@;+bfA;+dfC;JfB;Щf8<1ĈfG<1ĉfH<1ĊfI<1č$<1ē$<1QfE<1WfF<1[fJ<1\$<1^$<1_$<1`$<1a$<1b$<1d$<1e$ aCU1/5/2009     woCX6U1/6/2009     P]Q1H\~ok,U1/7/2009     Y:*MJrBU1/8/2009     ~+eN/cFU1/9/2009     'NbݞLNW0U߉TB<qryGetDailyShifts.EmployeeName  61/12/2009 IW@AH)Lp61/13/2009 cMƸ<61/14/2009 1 ߗAЯ& 61/15/2009 EG7!61/16/2009 9-McqoG61/17/2009 3 :D55/61/18/2009 hqClou LVAL MR2&ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredIMEModeIMESentenceModeSmartTagsAllowZeroLengthDisplayControl$UnicodeCompression  d \ UTY{HIcj]n@tblStoreHoursw_/@4*FʷTY{HIcShiftDateJwcD#pHTY{HIcStoreOpenԳIܝIou²TY{HIcStoreClose_+1#Lx TY{HIcNotes   TY{HIcZShiftDate         ZStoreOpen         \StoreClose         n Notes         m   K[ 0CB0 1CB01/16/20093 :D55_Day1At4.1/17/2009hqClouBqry_Employee_All_Shifts_Per_DayDqry_Employee_All_Shifts_Per_Day1pd dddd 0CB0 1CB0fmmmmmmmmmmfͬdb"2F0PageHeaderSectionDirDataDirDataCopyPropData BPPSVB_XLIHOEEOCQYSWKGWFXBRE:Dk__SRP_2i__SRP_3gy__SRP_0 j __SRP_1 mdir'i0v2vPropData5PropDataCopy Yesqm.1m. ShiftStartTimeSm.Qm. -> ShiftEndTime  , C:\Documents and Settings\greg\Desktop\current vb programs\Scheduler Program\DB1.mdbm.!m.  2e0* pHddb1@= d  /J( J< rstdole>2stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\WINDOWS\sys@tem32\e2.tlb#OLE AutomatXion`DAO>JDAjOA A5(E01A5AProgram Files\CommonMicrosoft Shared\;\dao360.dll# 3.6 Object LibraryHADODB> ADZDB\\\10-8AA006D2EtA41N.S\@ado\ms@21T+ActiveX Data-s 2.1K.B*modMai0nG@dMainBPPSVB_XLIHOEEOCQYSWKGWFXBREH28AP@SV@_XLIHDEE@CQYS@WKG@F@Bb_ResultsZT  G  eld Ctl1_10_2009_Label1/10/2009_Labeld CtBqry_Employee_All_Shifts_Per_DayDqry_Employee_All_Shifts_Perdmmdefgjmnopd dddb_ResultsZT  G EYNHHY Y EmployeeNumber DepartmentNumberdv9LVALIxrr #"@# $x#0$#@$#P$# d@#x## #ALVALL LLLLLLLLLLLLIDColumnWidthColumnOrderColumnHiddenDescription FormaMR2RecordLocksODBMR2RecordLocksODBMR2RecordLocksODBCTiMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLbMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    2jO:=JrH @ Uw҂:FkaLq@hMtblshiftsMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLbMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    2jO:=JrH @ Uw҂:FkaLq@hMtblshiftsMR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsY    UnHJILRIpp@D~tblEmployeeDepartmentM&(DcCo5EnHJILREmployeeNumber$;ܙH4b^nHJILRDepartmentNumber   nHJILR"EmployeeNumber         0  m VcIiK'& DepartmentNumber  0       0  m X(K.MR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTagsAllowZeroLengthIMEModeIMESentenceMode$UnicodeCompressionK     UBvONψ܏% wp@tblDepartmentsR.]HaLg"BvONψ܏%DepartmentNumbereWa1DXR$yBvONψ܏%DepartmentName   BvONψ܏%& DepartmentNumber         0  m +jNJH$Rv"DepartmentName         m    1B@FXvA%i'G%ϾϳϨϝϒχ|qf[PE:/$ti       \LVAL ̘ƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘƘODBCTimeoutMaxRecords FilterOrderBMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightR  <    (=cCń Uw҂:FkaLq@tblShifts6 -NI2\w҂:FkaEmployeeNumberf1MN3Kkgw҂:FkaShiftDate   - Shifts    MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightR  <    (=cCń Uw҂:FkaLq@tblShifts6 -NI2\w҂:FkaEmployeeNumberf1MN3Kkgw҂:FkaShiftDate   - Shifts    MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatDecimalPlacesInputMaskCaptionDefaultValueRequiredDisplayControlSmartTags    U{ nX9G?;(ڤn@D~tblEmployeeDays>TH*c-{ nX9G?;(EmployeeNumber͜!&E({ nX9G?;(FiscalYear'L}{ nX9G?;(NumberOfVacationDays0K:B T `r@?UUUUUU? ]:B O `r@UUUUUU?? doY:B K `r@ >K:B H `r@UUUUUU?? boY:B F `r@UUUUUU?? aoY:B B `r@UUUUUU?? `oY:B > `r@UUUUUU?? _oY:B : `r@UUUUUU?? ^oY:B 7 `r@  >K:B `1 `r@ UUUUUU?? \oY:B 0. `r@ UUUUUU?? [oY:B `+ `r@ >K:B `$ `r@  >K:B P! `r@ >K:B  `r@UUUUUU?? WoY:B  `r@UUUUUU?? QoY:B  @r@?UUUUUU? T:B 0 @r@ tT:B  @r@UUUUUU?? dT:B @r@?? T:B ~ @r@UUUUUU?? bT:B z @r@UUUUUU?? aT:B d0`, \ ( @N r@ f~;B H r@ f~;B 0D r@ f~;B `A r@ f~;B P= r@ f~;B : r@ f~;B 7 r@ f~;B 1 r@ f~;B , r@ f~;B `) r@  f~;B `( r@  f~;B p% r@  f~;B " r@  f~;B ` r@  f~;B ` r@ f~;B  r@ f~;BLVALa<D,h;0,0 m?h; p+h;H+h;h;h;  <$h;h;h;@h;h;h;h;@h;h;h;    d.StartDate tmpDateNumberOfShifts)FullTimeShiftDuration)PartTimeShiftDurationh;h;@h;Xh;ph;sqnr@<h;h;6X6h;h;X6ph;h;6Xh;8$3h;8$Xh;8$X6X@h;8$6dh;h;h;ph;كr@tblShiftsh;h;h;ph;Lq@tblEmployee h; h; h;ph;&=q@AqryWeeklyHourTotalsByEmployeeType h;h;h; h;h; h;h; h;h; @h;h;h;h;h;@h;h;8$tmpDate h;h;h;tblShiftstblEmployee h; ,h;,h;$ph;8h;Hh;Xh;hh;xh;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;h;v h;h;h;v h;Xh;(h;h;v Ph;@h; 0h;8h;@ ph;h;!h;h;+h;h;x !h;!h;ph;Ph;x%h; h;h;P(h; h;(h;+h;(h;8h;`"h;!h;"h;!h; "h;!h; h;h;8h;X!h;h;h;h;tblShiftsxrh;h;xrh;h;xrh;h;xrh;h;xrh;h;h;h;h;Ph;h;h;h;h;(h;Lh;Xh;h;\h; h;ShiftValid h;h;Hh;`h;8h;h;h;h;tblEmployeePrimaryKeyxrh; h;xrh; h;&h;h;h;h;h; h;h; h;h;h;"PrimaryKey(h;h; h; h;h;h;h;PrimaryKey tmpDatexrh;8h;Ph;h;h;h;h;h; h;ShiftDateh;h;( h;h; Ph;StartDate , h;$P h; T h;` h; h;d h; 4` DateAdd h; h; h; h;"d" h; h;!h; h;7!h; !h; $!h; Ph;StartDate\!h;h;h;h;h;h!h;(!h;x!h;( h;@xrh;h;xrh;h;xrh;h;xrh;h;xrh;h;!h;!h;("h;#h;,#h;%8#h;<#h;%H#h; L#h;X#h;%h;-\#h; h#h;$h;l#h;x#h;$h;|#h;$#h; #h;#h;#h;#h; 4`datediff #h;#h;($h;#h;"n" ,$h;8$h;x$h; <$h; Ph;ShiftStartTime|$h;$h; $h; h;ShiftEndTime $h;< $h; %h;(%h;`%h; ,%h; h;ShiftValidd%h;p%h; t%h;.%h;(#h;0%h;#h;$h;%h; LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <   D < Uw҂:FkaLq@|tblShiftsr{IK2G&=q@itblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9Oֽ LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <   D < Uw҂:FkaLq@|tblShiftsr{IK2G&=q@itblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9Oֽ LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <   D < Uw҂:FkaLq@|tblShiftsr{IK2G&=q@itblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9Oֽ LVAL MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLZ  <    2jO:=Jr  Uw҂:FkaLq@tblshiftsr{IMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    2jO:=JrR J Uw҂:FkaLq@<tblShiftsnHJILR2p@i3tblEmployeeDepartment6 -NI2\w҂:FkaEmployeeNumberVcIiK'nHJILREmployeeNumber MR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOL  <    2jO:=JrR J Uw҂:FkaLq@<tblShiftsnHJILR2p@i3tblEmployeeDepartment6 -NI2\w҂:FkaEmployeeNumberVcIiK'nHJILREmployeeNumber MR2ValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatInputMaskCaptionDefaultValueRequiredIMEModeIMESentenceModeSmartTagsu  6 . Uv .G@D7[m-q@tblScheduleCreationvc㚷0M9Ckv .G@D7[ScheduleDateX^@FIub|v .G@D7[CreatedDateGPJ AٯCd2v .G@D7[ID   v .G@D7[`ScheduleDate         ^CreatedDate          LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <   D < Uw҂:FkaLq@|tblShiftsr{IK2G&=q@itblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9Oֽ LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <   D < Uw҂:FkaLq@|tblShiftsr{IK2G&=q@itblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9Oֽ LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHiddenRowHeightReplicable  <     UlY"FݗUكr@|tmpDatew҂:FkaLq@iЗtblShiftsr{IK2G&=q@iЗtblEmployee6 -NI2\w҂:FkaEmployeeNumberl81Hz dr{IK2GEmployeeNamef1MN3Kkgw҂:FkaShiftDateJU|tlY"FݗUStartDate)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeUL@}Bm V r{IK2GEmployeeNumber   w ~\8D݋[>6startdate YѦIIhfǸ> ShiftDuration 7 AT9OֽLVALr [<D`,X6$`,0 P?X6 +X6(X6X6 X6  " + ShiftEndTimeDaturd(ShiftStartTimeSaturday + "->" + ShiftEndTimeDaturday(ShiftStartTimeSaturday + "->" + ShiftEndTimeDaturday )(S(ShiftStartTimeSaturday + "->" + ShiftEndTimeDaturday )(ShiftStartTimeSaturday + "->" + ShiftEndTimeDaturd(ShiftStartTimeSaturday + "->" + ShiftEndTimeDaturday )[qryGetDailyShiftDurations].EmployeeName[qryGetD[qryGetDailyShiftDurations].EmployeeName[qryGetDail[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].Employe[qryGetDailyShiftDurations].EmployeeName[qryGetDa[qryGetDailyShiftDurations].EmployeeName[qryGetDail[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].Employe[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].Empl[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].E[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].[qryGetDailyShiftDurations].EmployeeName[qryGetDail[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].Employe[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurati[qryGetDailyShiftDurations].EmployeeName[qryGetDa[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShift[qryGetDailyShiftDurations].EmployeeName[qryGetDail[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].EmployeeNameFirst([qryGetDaily[qryGetDailyShiftDurations].EmployeeName[qryGetD[qryGetDailyShiftDurations].EmployeeName[qryGetDailyShiftDurations].EmployeeName LVALLЄ ̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́̈́ά/ &xqryά/ ά/ ά(h/ ά(h ά/ ά/&xtblShiftsK[ $Ne8  l,d$h8loyeeNumber = en% FROM tblShifts WHERE ShiftDate = #shftdt# AND EmployeeNumber = empnnum . WHERE ShiftValid = YesReport_qry_Crosstab_ResultsC SELECT ShiftStartTi (0 kme, ShiftEndTime,ShiftDate,EmployeeNumber FROM tblShifts WHERE ShiftDate = #shftdt# AND EmployeeNumber = empnnum empnnum shftdt zSELECT ShiftStartTime, ShiftEndTime,ShiftDate,EmployeeNModule1db1modMainF@C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLLVBA  !0J_N?4C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLBAccess  A@0FC:\WINDOWS\system32\stdole2.tlbstdole )QP^F=C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dllDAO 1`m.4C:\Program Files\Common Files\system\ado\msado21.tlbADODB !Ip ConcatShifts & SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERployeeNumber, s,ze) Dim db A&srsRecordsetcSet*= Open|("C:\Document@s and 'tings\greg\Deskto@p\curr" vb programs\Scheduler P\DB1.mdbF"LMsqlDSdtr) S@ELECT  2 SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERE ShiftDate = #sd# AND EmployeeNumber = en en sdVBE6.DLL    0 ORDER BNC@q@@q@q@ LVAL @$h;%h;x#h;!h;%h;% %h;%h;%&h; &h;&h;&h;&h; &h;X&h;$&h; h;FullTime \&h; &h;&h;(h;&h;&h;'h;&h;$&h; &h;&h;'h;&h; 4`datediff 'h; 'h;P'h;$'h;"n" T'h;`'h;'h; d'h; Ph;ShiftStartTime'h;'h; 'h; h;ShiftEndTime 'h;<(h;((h; ,(h;1T(h;%h;'h;%h;h'h;`(h;(&h;p(h;&h;%h;(h;%(h;(h;%(h; (h;(h;8)h;(h;(h;)h;(h; h;FullTime )h; <)h;H)h;*h;L)h;X)h;*h;\)h;$)h; )h;)h;)h;)h; 4`datediff )h;)h;*h;)h;"n" *h;*h;X*h; *h; Ph;ShiftStartTime\*h;h*h; l*h; h;ShiftEndTime *h;<*h;*h; *h;4 +h;(h;p*h;(h; *h;+h;(h;(+h; X)h;(h;`"h;8+h;"h;P+h;"h;`+h;|Ph;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;+h;h;}Ph; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h; ,h;h;!h;`"h;"h;"h;K[ &shftdt $Z'&@ =SELECT ShiftStartTime, ShiftEndTime,ShiftDate,EmployeeNumber '& &G FROM tblShifts WHERE ShiftDate = #shftdt# AND EmployeeNumber = empnnum'&  & AND ShiftValid = Yes'&  & ORDER BY ShiftStartTime'&x. ." 4ShiftStartTime "%<HH:nn$-> ShiftEndTime "%<HH:nn$ @'4Attribute VB_Name = "modMain" Option Compare xr&I7|A;if1J ŲɄSb0Accessand As=Dim@DoGEndYFunction_IfyloopNotnothingPublicthenWhileVBAWin16~Win32MacVBA6#db1stdole`DAOADODBsModule1b _Evaluate_B_var_FunctionO ConcatShiftsemployee9 shiftDate+employeeNumber^db\rs_ Recordsetsql" OpenRecordset|BOFyEdit+EOF _B_var_IfP MoveFirstNsShiftsstirng?Mstrint7 _B_var_DoFields7ItemzvbCrLfMoveNextL!Module2cmodMainValueKdbvʂ OpenDatabase`appt _B_var_app1ap\aXsq%_ _B_var_sqReplacefFROM~  tblShifts WHERE֍ _B_var_FormatmdReport_qry_Crosstab_ResultsfReport$ ReportHeaderŃLabel16FPageHeaderSectionwEmployeeName_Label ICtl1_5_2009_Label4uCtl1_6_2009_Label Ctl1_7_2009_Label fCtl1_8_2009_LabelCtl1_9_2009_Label WCtl1_10_2009_LabelbCtl1_11_2009_Label_Line19?Detail2 EmployeeName Ctl1_5_2009 Ctl1_6_2009] Ctl1_7_2009' Ctl1_8_2009= Ctl1_9_2009T Ctl1_10_2009< Ctl1_11_2009RPageFooterSectionText17rText18rLine20[ ReportFooterR. Report_OpendCancel Report_CloseYQuit9Report_rpt_Crosstab_ResultsZ`G   $*\R3*#2e*\R3*#28*\R3*#2a*\R3*#1b*\R3*#24*\R3*#2e*\R3*#28*\R3*#2a  B  d+ (FV $ (& X,8,X (0 FB429A0}P(%L`p ae8 %f %L00T   "( " 8x0ohoXA@H-Attribute VB_Name = "Report_rpt_Crosstab_Results" Basd0{AF04CFB9-F35D-41D7-B3C8-D6663FB429A0} |@GlobalwSpacIFalsBe dCrealTru Pre de  LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾> 6 Uw҂:FkaLq@|tblShiftsr{IK2G&=q@i =tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾> 6 Uw҂:FkaLq@|tblShiftsr{IK2G&=q@i =tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #  K[Ip ConcatShifts & SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERE ShiftValid =ployeeNumber, s,ze) Dim db A&srsRecordsetcSet*= Open|("C:\Document@s and 'tings\greg\Deskto@p\curr" vb programs\Scheduler P\DB1.mdbF"LMsqlDSdtr) S@ELECT SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERE ShiftDate = #sd# AND EmployeeNumber = en en sdVBE6.DLL    0 ORDER BY ShiftStartTiDatabase Public FuncFncatShifts(employeeNumber, s,ze) Dim db A&srsRecordsetcSet*= Open|("C:\Document@s and 'tings\greg\Deskto@p\curr" vb programs\Scheduler P\DB1.mdbF"LMsqlDSdtr) S@ELECT oStartTime,Endrt,E #& " FROM tbls WH8ERE%#shftdt# AHND &= n8num+)Valid#YesORDER BY72 Replace(*, ",tK3= e-"K| rw=@s.rFyAG^CE_If Not (rs.BOF And EOF) Then  @MoveFirsADo While %s= E& @FormatFields(" GG)BHH:nn") @p->" T ă" vbCrLf!D-Nex-@Loop  I M=1h¢QDC Co@|4 OpenRecordset|BOFyEdit+EOF _B_var_IfP MoveFirstNsShiftsstirng?Mstrint7 _B_var_DoFields7ItemzvbCrLfMoveNextL!Module2c modMainValueKdbvʂ OpenDatabase`appt _B_var_app1ap\aXsq%_ _B_var_sqReplacefFROM~  tblShifts WHERE֍ _B_var_FormatmdrU ,`a//nrU~| y Y 1    )Y 9q0  k1, l,*1, l,*1,,T(l, 1,/(,T(l, 1,/((0'4%'D%'T%l,h l0=d0#"d k" d 4k  d "d 4k"l$FD :T%0d 0 0 D :4:%T  G umber * AND ShiftValid = Yes,qry_Crosstab_ResultsxY ShiftStartTime#? SELECT ShiftStartTime, ShiftEndTime,ShiftDate,EmployeeNumber FROM tblShifts WHERE ShiftDate = #sd# AND Empd  0 D:`1$)06 d  c=h c=d l$FTloStartTime,Endrt,E #& " FROM tbls WH8ERE%#shftdt# AHND &= n8num+)Valid#YesORDER BY72 Replace(*, ",tK3= e-"K| rw=@s.rFyAG^CE_If Not (rs.BOF And EOF) Then  @MoveFirsADo While s= E&Fields("BE) l->"/ }"vbpCrLf K[claId"Expose_TemplateDerivCustomiz abD$Option Comp@ DT P&* Sub ClC() Quit EndOpeModule1db1modMainF@C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6.DLLVBA  !0J_N?4C:\Program Files\Microsoft Office\OFFICE11\MSACC.OLBAccess  A@0FC:\WINDOWS\system32\stdole2.tlbstdole )QP^F=C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dllDAO 1`m.4C:\Program Files\Common Files\system\ado\msado21.tlbADODB !Ip ConcatShifts & SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERployeeNumber, s,ze) Dim db A&srsRecordsetcSet*= Open|("C:\Document@s and 'tings\greg\Deskto@p\curr" vb programs\Scheduler P\DB1.mdbF"LMsqlDSdtr) S@ELECT  2 SELECT ShiftStartTime, ShiftEndTime FROM tblShifts WHERE ShiftDate = #sd# AND EmployeeNumber = en en sdVBE6.DLL    0 ORDER BY ShiftStartTimeReport_rpt_Crosstab_Results? SELECT ShiftStartTime, ShiftEndTime,ShiftDate,EmployeeNumber FROM tblShifts WHERE ShiftDad  0 D:`1$)06 d  c=h c=d l$FTloStartTime,Endrt,E #& " FROM tbls WH8ERE%#shftdt# AHND &= n8num+)Valid#YesORDER BY72 Replace(*, ",tK3= e-"K| rw=@s.rFyAG^CE_If Not (rs.BOF And EOF) Then  @MoveFirsADo While s= E&Fields("BE) l->"/ }"vbpCrLf $Ne8  l,d$h8te = #sd# AND EmployeeNumber = en% FROM tblShifts WHERE ShiftDate = #shftdt# AND EmployeeNumber = empnnum . WHERE ShiftValid = YesReport_qry_Crosstab_ResultsC S (0 kELECT ShiftStartTime, ShiftEndTime,ShiftDate,EmployeeNumber FROM tblShifts WHERE ShiftDate = #shftdt# AND EmployeeNumber = empnnum empnnum shftdt zSELECT ShiftStartTime, ShiftEndTime,S 1,/((0'4%'D%'T%l,h l0=d0#"d k" d 4k  d "d 4k"l$FD :T%0d 0 0 D :4:%T  G hiftDate,EmployeeNumber * AND,rpt_Crosstab_ResultsxP^F=C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dllDAO 1`m.4C:\Program Files\Common Files\system\ado\msado21.tlbADODB !  LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #    o FullTime'  o FullTime' g o FullTime' g o FullTime' g o FullTime' g oEmpl o FullTime' g  o FullTime' g o o FullTime' g oEm o oNumberOfShiftsoNumberOfShiftsoNumberOfShiftssum(iif(ShiftValid=Yes,1,0))W-- o @p] ' @p] '  @p] 'tblShi @p] 'tblShiftstblE @p] 'tblShiftstblE @p] 'tblShiftstbl @p] ' @a] @a] ' @a] ' @a] ' @a] ' tblShiftstbl @a] '    GnYNooY StartDate @ ] '@ ] '@ ] '@ ] 'tblSh@ ] 'tblShiftstbl@ ] '     G       G@     G   G "  G   G   G   G   Gdv LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #  LVAL@DwMR2BValidationRuleValidationTextOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescription FormatCaptionSmartTagsInputMaskDefaultValueRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlaces     Ur{IK2GIsq@atblEmployeeUL@}Bm V r{IK2GEmployeeNumberl81Hz dr{IK2GEmployeeNameê "Ikq=r{IK2GActive^MN0Dw+[r{IK2GDayOffMonday{ K (r{IK2GDayOffTuesday@ RAO%?r{IK2GDayOffWednesdayVJ8D }r{IK2GDayOffThursday k2A)4r{IK2GDayOffFriday$բێxM<"r{IK2GDayOffSaturday"Nm`]B4,~3Zr{IK2GDayOffSundayo\s&Bl;rr{IK2GShiftStartTimeMonday6Un9Ekr{IK2GShiftEndTimeMondayY*XFODunH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #    ockD" ockD"  ~@ ~@ ~@ ~@ ' t ~@ ' tblEmploy  qry.EmployeeName/ qry.EmployeeName/ qry.EmployeeName/  qry.EmployeeName/ qry.EmployeeName/  qry.EmployeeName/ g qry.EmployeeName/ g  qry.Employe   qry.E qry.EmployeeName/ g qry.EmployeeName/ g LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾v n UlY"FݗUكr@|tmpDatew҂:FkaLq@i`tblShiftsr{IK2G&=q@i`tblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumber K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #   LVALMR2RecordLocksODBCTimeoutMaxRecords FilterOrderByOrderByOnOrientationDefaultViewGUIDDOLColumnWidthColumnHidden  <    -HC-N߾ֲ  UlY"FݗUكr@|tmpDatew҂:FkaLq@itblShiftsr{IK2G&=q@itblEmployee)qEN"~w҂:FkaShiftStartTimeؚUpM%_^kw҂:FkaShiftEndTimeok>nH=`sw҂:FkaShiftValidȨ9@^HG 4ɪqr{IK2GFullTime6 -NI2\w҂:FkaEmployeeNumberUL@}Bm V r{IK2GEmployeeNumberJU|tlY"FݗUstartdate K0*FullTimeShiftDuration    K0*PartTimeShiftDuration  #  LVAL@~<D*n*z 0?@n @*n&nxnnnn T$ <nhnnnnnPnnnn 8nnn nhnn  d    /tblShifts.EmployeeNumbertblShifts/tblEmployee.EmployeeNametblEmployee%tblShifts.ShiftDatetblShiftsStartDateShiftDurationhn`nn(nnmi~r@)XnpnHou@nXnjusn% hn% n%n%(.n% tblShiftsnnnnLq@tblEmployeex nP n` nn&=q@1qryGetDailyShiftDurationspnXnnpn hnxn nn nn nnnhnnnnn%(drn%dtblShifts n@ n nH nnnhn%tblEmployee hnnhnnpnnn@nHnhsnhsnhsnStartDaten n$n nnnn 4` DateAdd nnHnn"d" LnXnn \n1,\nnn nStartDatennnnnnnn nn nStartDateLnnnn@nXn nnP*n$n8nPnhnnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnxnnnHnnv `nHnnv !n n"n 00T$nnqnnnnnnnnnnnnnnnnnnnnnnnnnnnnnP(n xn(n'n \'n0H$nn@ pnn#nn&nnx "n#npnn d8!n`n $n(&nnn0$n#n nP n!ntblShiftsxrnnxrnnxrnnxrnnxrnn`nhnnxnnnnn@nn,nnHnnn nn @nShiftValid $nLnXnn\n `nShiftDatennnn nStartDate n n nnnn`n nn nn0 nnn ntblEmployeePrimaryKeyxrnnrnn !n@ n8!np!nn n"n ("n0"nD"n"PrimaryKey(n\"n !n"nX"n`"n!nPrimaryKey@ d@ @ @ xrnnxrnn xrnnxrnn xrnnxrnn l$n @ LVAL np$n"n$nh$n#n$nP#n$n#n$n#n$n#n$n%n%n`&n%n$8%n <%nH%n%nL%n 4`datediff %n%n%n%n"n" %n%n&n %n nShiftStartTime&n &n $&n nShiftEndTime d&n<,\&n%n(&n$n%n&n %nn0$n&n|Pn&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&n&nn}Pn\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'n\'nn#n dP#n#n(n0$n@ d@ @ @ @(n n(n&n(n(nxrnnrnn xrnnr nn xrnn(n(n )n*nX)n*n)n *n)n0*n(n d )nX)n)n)n_o