Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{N         KKDl RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOnpubwiz_Ratings ListV  <  % Ratings List_1;-1;<>KKD= RecordLocks ODBCTimeoutUseTransaction FailOnError1  <  KKDI RecordLocks ODBCTimeoutUseTransaction FailOnError Replicable1  <  KKD0 RecordLocks ODBCTimeoutUseTransaction(  < KKDW RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn1  <  KKDK RecordLocks ODBCTimeoutUseTransaction ColumnWidth ColumnHidden(  < & Event H KKDW RecordLocks ODBCTimeoutUseTransaction ColumnWidth ColumnHidden Replicable(  < & Event H KKDr ColumnWidth ColumnHidden RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn4[All Results].Event  7[All Results].Division  6[All Results].Section   4[All Results].Round T & White  - White School \ & Board p 1  <  KKD0 RecordLocks ODBCTimeoutUseTransaction(  < KKDTitleAuthorCompanyVC<S <<          2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni -P Id ParentIdName        ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  wnyVCS  ;   2  ObjectIdSIDACM FInheritablebc ObjectId             Schools.SchoolSchoolsPlayers.First NamePlayersPlayers.Last Name Players.GradePlayers.RatingP?v$?v4?v\?vC9T@?v?v d?vl?v ?v$ ?v$ 0?v$ D?v$ T?v$ PlayersX?v?v\?v,0.T@ Schools?v?v\?vQbT@Create Ratings List Table?vl?v0?v$T?v$ D?v$ T?v$Players?v$Schools?v?vv  ?v ?v?vv 8 ?v$ ?v?vK0$?vP?vPs?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?vP?v?v ?vt?v?v ?v?v ?v ?v Players ?v@?v  ?v@?v  ?v@?v ?v@?v?v@?v?v@?v  ?v $ ?v ?v T ?v ?v ?v, ?v ?v8 ?v4 ?vD ?v` ?vl ?v ?vp ?v| ?v ?v ?v  ?vPlayers.Active ?v%-H ?v  ?v` ?v ?v ?v ?v ?v, ?v ?v .` Val0 ?v8 ?v < ?v T ?v [Grade] d ?v HJ ?v\ ?v ?vP ?v @ ?v ?v ?v ?v@?v ?vSchoolsPrimaryKey?vH?v ?vH?v  8 ?v ?v h ?v ?v?vH?v$?v 0?v4VC?S             ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  ?v@?v PrimaryKey ?vP?v  ?vp?vL?vT?v ?vPrimaryKey h ?v  ?v $ ?v T ?v ?v h ?v @ @ @   ?vP?v  ?vP?v  ?vP?v  ?vP?v ?vP?v t?v|?v ?vd?v ?vp?v ?v|?v 4?v?v ?vP?v(d?v\?v,?v@?vT?vh?v|?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v?v?v t?v ?v ?v ?v4?vRatingsListVCS            szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationship%6 %6L%6 %6P%6%6%6%6%6ԥ 4)%6ԥv%6ԥSchools %6%6 %6%6 %6 %6 %6%6%6 %6 %6 %6 %6,%68%6D%6P%6\%6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6 %6%6%6%6%6 %6 %6d %6` %6d %6  %6d %6 |%6  %6%6 %6%6%6  %6l %6 4 %6x %6%6  %6 4 %64 %6 %6 %6%6 %64 %6 d %6Schools P %6 \ %6d %6p %6School CodeSchool PrimaryKeyID| %6%6v p%6\%6d%6%6 %6s %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6 %6%6 %6%6%6%6 %6SchoolsPrimaryKey {qg]SI?51o@@o{ @ @ @ @ @ @ @ @ @ @ 1      !"#$%&' ()+,-./012 3 ^ ^*^^^^^ ^^^ ^ ^ ^ ^^^^^^^^^ ^ ^^^ ^^^^^^"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"^1"o{mZG-rZ3~P"TA.üüüüüüüüüüüüüüüüüüü      2W   ƈ    s  ed  $    1  c  IdParentIdNameType DateCreate DateUpdateOwnerFlags"Players"Players"Players "Players"Players"Players "Players " "Players " "Players"Players"Players "Players " "Players "  G" "Players " "Players "  "Players"Players"Players"Players " Import.* gImport  GxTable RQ2 K O  SchoolsTeamsSchools.ID = Teams.School=  Teams.[Board 5]' g Teams.[Board 4]' gTeams.[Board 3]' gTeams.[Board 2]' gTeams.[Board 1]' g Teams.Rating$ g Teams.Section% gTeamCode Teams.Team* oSchools.School& gTeams.ID gTeams Schools  G G   Schools.School& ' Schools.*! gSchools  G G  @@@@    @  @@ @fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvpf{Zwihu`dfu`wjphv`gwfubi`phfhu`dfvpf{vbirrm}f`ubi`phfhu`dfvrxwbrofvsm`}fumjvw sm`}fuv srvwfdufvxmwv u`wjphvmjvw ufvxmwvmoWfmforbwXVV\ ufvxmwvmoWkuijhirbwXVV\ufvxmwvmoWsujorbwXVV\ufvxmwvmoXfmfoprzXVV\ufvxmwvmoXkuijhiprzXVV\ufvxmwvmoXsujoprzXVV\ufvxmwvwfosm`wfv`b`vbirm`vwjbu`wjphvvbirrmmjvwvbirrmvvfbwjrpvwf`omjvwwf`ov|w`amf`ssfpd|w`amfwfosm`wf`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 p4 4 4 4 4Sections PrimaryKey4 4 \ 4 4\ 44 4 4 4 4 44o{< u7 tlb)?u7u7 u7 $u7h <u7u7|u7u7u7u7  TeamList.Teams.IDTeamsTeamHu7Du7hu7,u7 u7G[T@u7u7 u7u7 \u7du7 u7ԥ u7ԥ TeamListu7  u7u7u7u7g/֛@ Schoolsu7u7u7(u7u7QbT@Teams,u7  u7$u7u7u7$CT@~sq_cPlayers~sq_cTeamu7 u7u7 u7u7u7u7u7u7 u7du7 u7ԥSchoolsTeamsTeamListu7du7 u7u7 u7Teams.IDSchoolsu7ԥTeams u7 u7u7 u74u7Hu7 u7,u74u7<u7Du7Lu7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7 u7u7tu7u7du7 u7u7` u7(u7  u7u7 |u7 u78u7u7u7,du7 u7|u7 `u7u7u7hu7@u7u7u7 u7u7 u70u7 u7 0u70u78u7u7 u7,u7u7u7u7u7u7u7  u7Schoolu7" " u7  u7 TeamCode4u7u7 u7<u7u7@u7(u7u7Schools u7 u7 @ @ @ @ @ @ @           !&*,   $ . 5:]diot(u7`Xu7 PrimaryKeyu7u7v u7u7u7v u7u7,u7 0hu74u74su74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u74u7hu7 u7u78u7 u7u7$u7Tu7Teamsu7$u7 u7$u7 u7$u7 u7Lu7 u7hu78u7tu7SchoolsPrimaryKeyu7,u7 u7,u7 u7,u7 u7u7 u70u7u7<u7u7,u7u7 u7u7u7 PrimaryKeyu7u7 Tu7u7u7u7Hu7PrimaryKey u7 u7u78u7 @ @  u74u7  u74u7 u74u7u74u7 u7 u7 u7hu7 u7tu7 8u7u7 u7u78u7u7(u7u7 {qg]SI? e9 tb)?Te9e9 e9 e9 e9e9e9(e98e9He9Xe9he9xe9e9e9e9e9 e9 e90e9@e9Pe9`e9pe9e9e9e9e9e9e9e9e9e9e9e9e19e9e9e9e9(e98e9He9Xe9he9xe9e9@   @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @  !"#$ % & ' ( ) * + , -            !"#$%&"#$ !"#  '!!!&&& * * * , ,, !   $$$. . . 5 5 5:::]]]dddiiiooot$t%t&'       nter Results 33aa1b9cb*D7 :Form_z Old Enter Results Form 1339f72a25*DAXs             !"#$%&' ( ) * +             ! " #$%'()*+,-./&02345671e9e9le9nfoVersion-Index1--- a d g h i k m n o p q r s! t" u# v$ w% x& z' {( ) * + ,                           ! " # $ % & ' ( ) * + ,                           #! $" '# ($ *% +& ,' 4( 7) 8* :+ ;, <- = > ? @ D E K M O P Q R S T X Z [ ` c d e g i p s t u y     ! " # $ % & ' ( ) * + , -                           ! " # $ % & ' ( ) * + , - .               $ ' ( ) * + , - . / 0 1 2 3 4 5! 6" 7# 8$ 9% :& ;' <( =) >* ?+ O, Q- R U X Z [ \ _ f g i j k l m n o p q r s t u v w y zmy of TucsonSiath2 Academy of TucsonRowling8 Academy of TucsonRamirez4Academy of TucsonPrince6 Academy of TucsonPetzer6Academy of TucsonPeterson7Academy of TucsonPeterson4 Academy of TucsonPasteur5 Academy of TucsonOliver3Academy of TucsonNason4Academy of TucsonMorrell7%Academy of TucsonMcLaughlin2! Academy of TucsonMcCauley7*Academy of TucsonLucas7)Academy of TucsonLucas6Academy of TucsonLazzeroni5 &Academy of TucsonKoester7#Academy of TucsonKimminau5Academy of TucsonKeyes6Academy of TucsonKelly7&Academy of TucsonKay7Academy of TucsonInsana5Academy of TucsonHughes6Academy of TucsonHughes2Academy of TucsonHerrera6-Academy of TucsonHellebrekers7#",Academy of TucsonHatchett7@5 PrimaryKey @@@8 #jKV#jKV#jKV#o   p pۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o p  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  k kۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o k ` ` `ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ? ?ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ?  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  5 5ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 5 . .ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o .    ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o > Q]u=E~@CLt(LHA@@s @Calc New Grades...........3ۍ@b@PAll-Star Data - Make@@MAA55555553 @@a@@All-Star Data - Append@@OCC77777775 @Ot@Ot@All Results,,,,,,,,,,* [ظ@3/@HAdd No-School Players\@@NBB66666664 @ V@@AdminP2&&&&&&&&&$ OВ@|8/@Publish Ratings^@<000000000. 76'/@%T@Utility((((((((((& 5_R@<_R@z Old Enter Results Form99999999997  c)5@_FP@z Create Results Table from CrosstableGGGGGGGGGGE  &\5@w_X@z Create New Tournament Results TableFFFFFFFFFFD  u 4@=V@Schools@LWF000)@RF44((((((&  @9"p @Players((((((((((& L٣ɚ@$Z@Enter Results..........,  c=@c=@UserDefined,,,,,,,,,,*  c=@c=@SummaryInfo[@888,,,,,,,* @Π@Π@SysRel''''''''''% Π@Π@Scripts((((((((((& Π@Π@Reports((((((((((& Π@Π@Modules((((((((((& Π@Π@Forms&&&&&&&&&&$ @@MSysRelationships22222222220 @@MSysQueries,,,,,,,,,,* @@MSysACEs))))))))))' @@MSysObjects,,,,,,,,,,* @c=@MSysDb@333'''''''% @@@Relationships.........., @@Databases**********( @@Tables''''''''''% 0,R[)qV<"uAt>{*_- [All Results].Round+ ' [All Results].Section- ' [All Results].Division. ' [All Results].Event+ 'Players_1Schools_1Players_1.School = Schools_1.IDI All ResultsPlayers_1"@,  PlayersSchoolsPlayers.School = Schools.IDA All ResultsPlayers [All Results].White = Players.IDJ All ResultsOutcomes"@+ All ResultsSections#@+  Black SchoolSchools_1.School4 o Black9@ oResultOutcomes.Outcome2/ oWhite SchoolSchools.School2 oWhite5@ oBoard[All Results].[Team Board]7 o[All Results].Round+ g[All Results].Section- g[All Results].Division. g[All Results].Event+ gSchoolsSchools_1 PlayersPlayers_1 Schools Players Outcomes Sections All Results  G G   Players.[First Name], ' Players.[Last Name]+ ' IsNull([Players].[School])2 '%@ 'RatingPlayers.Rating, wGrade Players.Grade* wLast NamePlayers.[Last Name]4 wFirst NamePlayers.[First Name]6 wPlayers  GRatingsList O  GLVAL#mJ(tR'X7U4 U#Q@ 6H P X %6#9@o@Add No-School Players44444444444  @@Admin$$$$$$$$$$$ @@Publish Ratings........... @@Utility&&&&&&&&&&& [Last Name] & ", " & [First Name][Schools].[School] & " " & [Teams].[Team][Last Name] & ", " & [First Name]Players.ID = [Calc New Grades].ID(((Players.Rating)<300) AND ((Players.Grade)="4"))(((Players.Active)=Yes) AND ((Val([Grade]))<10))(((Players.Grade)<>"" And (Players.Grade)<>"0"))((([Results LM 1 - Elementary].Section)<3))[Results LM 1 - Elementary].[Black Points][Results LM 1 - Elementary].[Black Rating][Results LM 1 - Elementary].Black[Results LM 1 - Elementary].[White Points][Results LM 1 - Elementary].[White Rating][Results LM 1 - Elementary].White[Results LM 1 - Elementary].Result[Results LM 1 - Elementary].[Team Board][Results LM 1 - Elementary].Section[Results LM 1 - Elementary].Round((([Results LM 1 - Junior High].Section)<3))[Results LM 1 - Junior High].[Black Points][Results LM 1 - Junior High].[Black Rating][Results LM 1 - Junior High].Black[Results LM 1 - Junior High].[White Points][Results LM 1 - Junior High].[White Rating][Results LM 1 - Junior High].White[Results LM 1 - Junior High].Result[Results LM 1 - Junior High].[Team Board][Results LM 1 - Junior High].Section[Results LM 1 - Junior High].Round[All Results].Black = Players_1.ID[All Results].Result = Outcomes.ID[All Results].Section = Sections.ID[Players_1].[Last Name] & ", " & [Players_1].[First Name][Players].[Last Name] & ", " & [Players].[First Name](((IsNull([Players].[School]))=True))VCtN                     !EventDivisionRoundSection Team BoardResultWhite White Rating White PointsBlack Black Rating Black Points?v@?v PrimaryKey ?vP?v  ?vp?vL?vT?v ?vPrimaryKey h ?v  ?v $ ?v T ?v ?v h ?v @ @ @   ?vP?v  ?vP?v  ?vP?v  ?vP?v ?vP?v t?v|?v ?vd?v ?vp?v ?v|?v 4?v?v ?vP?v(d?v\?v,?v@?vT?vh?v|?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v?v?v t?v ?v ?v ?v4?vRatingsList{ @fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdlQB/uDUlQB/uCUlQB/uC:\WIN95\SYSTEM\comctl32.ocx 1i GDESTo$@<o$@<GDEST GDESTGDEST}ܱ=ipQ}ܱ=ipQ}ܱ=ipQ#+%+'+&+ADC__SRP_1rU~~~~~~~~~~k     ( Q8 H Xp h Ix  9Canc8pCnI%U6#\=dE&xFq^@-Players.[First Name], gSchools.School& gSchools Players  GRatingsList O  0@ 'NewGradeVal("" & [Players].[Grade])+1= o Players.Grade% gPlayers.[First Name], gPlayers.[Last Name]+ g Players.ID" gPlayers  G G  +@ ' *@ g *@ g !@ g *@ g*@ g!@ g"@ g(@ g#@ g!@ gDivision"Elem"& oEvent"LM 1"# oResults LM 1 - Elementary%%%  GAll Results O  ,@ ' Black Points+@$ w Black Rating+@$ w Black"@  w White Points+@ $ wWhite Rating+@ $ wWhite"@  wResult#@  wTeam Board)@" wSection$@ wRound"@ wDivisionDivision"JH", EventEvent"LM 1"( Results LM 1 - Junior High&&&  GAll Results O   [All Results].[Team Board]2 '1g'plFl($E8C/~B:b^Aw   N@UpT@Update Play N@UpT@Update Player Ratings66666666664  @{n@t@AccessLayout*@@E99-------+ @gr@B(r@xTable Template@<<<0000000. @俆՛@$CT@Teams222&&&&&&&$ @l՛@g/֛@TeamList@@@A55)))))))' @_$@2.j,@Sectionsd@555)))))))' @t@2@QbT@Schools@444(((((((& @rผ@U@SACA Scholastic Ratings@ @PDD88888886 @oSՅ@.T@Results Template@===1111111/ @iT@1T@Results LM 2 Prim Nov 2006K@GGG;;;;;;;9 @] MT@9-QT@Results LM 2 Elem Nov 2006K@GGG;;;;;;;9 @:gh @j @Results LM 1 Prim Oct 2006K@GGG;;;;;;;9 @5\`o @ ko @Results LM 1 JrHigh Oct 2006K@III=======; @. N @V @Results LM 1 Elem Oct 2006K@GGG;;;;;;;9 @$u>@%u@RatingsList,,,,,,,,,,* 8n@,0.T@Players444(((((((& @xr@.wR@PlayerList%@@C77+++++++) @@3/$@Outcomes@555)))))))' @T@T@0New School Year - Change Gradesr@ @@XLL@@@@@@@> @,c=@c=@MSysModules2----------+ *c=@c=@MSysModules,,,,,,,,,,* &z @z @MSysIMEXSpecs.........., !z @z @MSysIMEXColumns0000000000. W@1W@Import''''''''''%  oڸ@C9T@PCreate Ratings List Table\@@@RFF:::::::8 @ 4u-|iVC0{a?v\D*X/K,Z$ @ @ RatingsList.School* 'RatingsList.Rating* gRatingsList.Grade) gRatingsList.[Last Name]/ gRatingsList.[First Name]0 gRatingsList.School* gRatingsList  G G   !@" 'PlayersSchoolsPlayers.School = Schools.IDA PlayersTeamsPlayers.Team = Teams.ID; Players.Section' g Players.Board% gPlayerTeam)@!" oPlayers.Rating& g Players.Grade% gSchools.School& gName!@  o Players.ID" gSchools Teams Players  G G  PlayersCalc New Grades!@." Players.Grade[Calc New Grades].[NewGrade]A wCalc New Grades Players  G G  2@ 'Players.Rating300) wPlayers  G G   Players.[First Name], ' Players.[Last Name]+ ' Schools.School& '0@ 'PlayersSchoolsPlayers.School = Schools.IDA Players.Rating& g Players.Grade% gPlayers.[Last Name]+ g @ @ @ @ @ @ @           !"#$%&' ( ) * +             ! " #$%'()*+,-./&02345671e9e9le9s @ @ @ @ @ @ @           ! " #$%'()*+,-./&0234567   1      !"#$%&' ()+,-./012 3 r r*rrrr$($VC|5N  55               /X    oTNMT_IDLASTFIRSTSCHOOLGRADERATINGRD1RD2RD3RD4RD5  PrimaryKey?v@?v PrimaryKey ?vP?v  ?vp?vL?vT?v ?vPrimaryKey h ?v  ?v $ ?v T ?v ?v h ?v @ @ @   ?vP?v  ?vP?v  ?vP?v  ?vP?v ?vP?v t?v|?v ?vd?v ?vp?v ?v|?v 4?v?v ?vP?v(d?v\?v,?v@?vT?vh?v|?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v ?v?v?v?v t?v ?v ?v ?v4?vRatingsLista{qg]SI?5 t0]Fx1\G}0[@@@ <@@Zhang KevinEspereW13W47W43W19W519630-*$ ;@@Temyanko SvetlanaEspereL10W36W15W29-H-?<9630*! :@@Reed MichaelEspereW30W33L8W20D479631.+% 9@@Pugazhendhi SangeethaEspereW9L32W37L21W7A?<964.$ 8@@Lin AndyEspereW17W44W21W8D22520-*'! 7@@Grandi PaulEspereW38L21L34W40L489630-*$ 6@ @Thakur AshuDoolenW7W50W16W32D24852/,*$ 5@@Jannuzi BriggDoolenW45W23L24W25L44;852/,&  4@ @Jacoby AlexDoolenW46L16W48L26-H-9630-*$ 3@ @Fan DavidDoolenW29W4W53L28L32630-+(" 2@ @Schrieber SteveCrossW34L8W50L44L29;8520-(" 1@@Province RyanCrossL24W14L47D37D52:741.+&! 0@ @Province KyleCrossW12W20L22W5L88641.+&! .@ @Christopherson CoryCrossL41W52L27W45L3?=:741,' ,@ @Thomas KapriceCardenL4L17L36W38W39;852/-' *@@Lawson LaurenCardenL28W40L44W36L50;852/,& (@ @Howell IanCardenL16W39L4L50W46741/,)# &@ @Heck JalissaCardenL3L30-B-L2L458530-+% $@@Enochs EricCardenW27L51W3L47W57520-*$ "@ @Bonzani JuliannaCardenL25L35L40-B-L36>;852/)  @"@Shevelev MishaBASISW31W18W26L24W16;852/,'! @@Sami AymanBASISL22L37W42W31L25741.+(# @ @Koester ElliotBASISW1W3L32L51W539630.,'  @@De Sa JacquelineBASISW42L43W45L16L10=:741.) @ @Campbell SeanBASISW14L19W12L43W29741.+&! @ @Weyker RyanAliceVW11L6L10W41W15852/-*$ @@Rose MichaelAliceVL53L34W38W11L49741.+% ?@Matheson LoganAliceVL6W46L29D30D41;852/-'!x5n(U ?g?n.;'FlA@Xp Reload0 Me.RecordSource = "Results " & Me!Tournament  F'g [Results "d]'dA@e Sub !'ss(b  'SU  ! J@@Vo DylanWilsonW2D41L19W34L642/,)'! J@@Streety JuleTownseL50L15W46W39D17:741.+%  I@@Parra AlexTortolW36W10W41W6L28742/,)# I@@Newman CaitlynStJoseW52L22L18W12W13<9630-' H@ @Ferrari RebeccaStJose-H--H-W30W35L43=:741.(  H@@Wibowo JosephStGregL32W42L20W33W23;852/,& G@@Sosnowski AlexanderStGregW40L28W17W10D26A>;852," G@ @Shenkarow HarrisonStGregL20L1L52W42L12?<9641+" F@@Reinthal DavidStGregL21W38L5L15W11;8530-'! F@@Brodkey SpencerStGregW37L24W13W18W21=:741.(  E@@Bass Beverly AnnStGregW35W5L28W4W49<9742/) E@@Velasquez RyanSierraL5L48L7L46-H-:742/-'" D@ @Silva PabloSierraW15D53L51L3D17530-*$ D@@Reyes MarioSierraL47L13W9L23L338520-*$ C@@Reyes Romo AlexSierraL33L12L31L52L14=:741.(# C@@Pablo ElijahSierraL23L45L2L14L319631.+% B@@Gillis CameronSierraL44W7L25D17D30;8520-' B@@Espitia VictorSierraL51L27W14L13W9;9630-'  A@ @Espitia PedroSierraL43W9W33L49-H-:741/,&  A@@Cota JoeySierraL18W2W23L53-H-630-+(" @@@Pae JohnPuschRW39L26L35L48W40630-*'! @@ @Alster EliOrangeW48W25W6L22W19741/,)# ?@ @Young JaredKhalsaL8L29W39L7W38742/,*$ >@ @Sjoquist MikeKhalsaL26W11L49D1D37:752/,&! =@"@Vo AndrewIronRiL19W31W1L27W18630.+("W @ @ @ @ @ @  "$ & ( * , .0123456789:;<=>?@@AABBC C D D E EFFGGHHIIJJV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  wnyVCN""    @ \     AttributesDataType FieldName IndexType SkipColumnSpecIDStartWidth"$8"% Index1 PrimaryKeycc c!c"c#c$ c% c& c' c( c) c* c+ c, c- g g g g g ggggg g g g g gggggggggggggggg g!g"g#g$g%g&jjjjjjj"j#j$m m mmmmmmmmmm m;    !!!!"" "!""jjjjjjjjjjjgggg'jj!j!j!j&j&j&j *j *j *j ,j ,j,j|m<|m=mmmjj j!mmm m m m.m .m .m 3m3m3@ ͬI1VMzDetailh UpdateRatingsoTournamentd Tournament_LabeleBox12eProgressLined ProgressPercenth CloseForm{qx $$@Hl $$@nl @p\ @L @\ $x0hPXx0hP$0$$@nl @p\ @L x H$$$`h0(P(X $@l @\  $$$@nl @p\ @L 0P$$$@l @\ X $$$`0h !zZ6qN. @@@@ @@fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd$@nl $8(@p\ *.N@L @H&l @\ %%P&0`)$Z^^@nl @p\ @L @H(l @\ @ School RatingH  Last Name. GradeB  First Name School RatingH   Last Name3 GradeG  First Name School RatingH   Last Name3 GradeG  First NameT!##3#G#H## #3#G#H### .# B# H# seConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni -P Id ParentIdName        ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  wny!  @gjuvwp`of#hu`df#m`vwp`of#u`wjph#vbirrm#gjuvwp`of#hu`df#m`vwp`of#u`wjph#vbirrm# gjuvwp`of# hu`df# m`vwp`of# u`wjph# vbirrm#om [Results "d] where Round =   and (White =   or Black =  )$%v.i '''$j'B B@ogr "  "'P with White'n "BHQ White wonwon'j@pHQ Black wonlost'jHQ They drewdrew'j@`ka "'P with Black'n "B@HQ White wonlost'jppHQ Black wonwon'jHQ They drewdrew'jkhh B@BD  B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@BD  "B@X* In case we have something like "O'Malley" '''$j' $ ^Z0 "B@<'F B@Vhh* In case we have something like "O'Malley" '''$j' '''$j'ZHQZ B@Play B@ [ "' ' ! ZZl  "Z  "' s "f'e "OZP '''$j'A@` '''$j'ect! ( B@Bif new "' dif "f'l?) "' "Z  "'re "'ity select * from Schools where [VCN ''        x  x  Y@       DateDelimDateFourDigitYearDateLeadingZeros DateOrder DecimalPointFieldSeparatorFileTypeSpecIDSpecNameSpecTypeStartRow TextDelim TimeDelimmn')  PrimaryKey#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  " ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o "  "ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o "  ! ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o !  !ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o !    ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   w wۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o w  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o a{qP$tHl@d8 \0T(xL p ,x  +,, *p , ), ( '2  & ;4, %,, $7, #,, ".m, !' T=  e, x X ((, %8w,         _, eVp 3 u  2 *_   eV =3 e,u  X  , ; w,,  7 ,  .mZ&j @@@@ @@fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vjof|brmxopvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdAҠ1:FRͬaW(\k[0=Jn~1M5>%:}!dDLpU=P!HJ!XJ$uWeL֞L+b9,x6F>/4î*ď6eC$*1aiJ.-^|:N+ $XgH͉Дd|ވgwOogr]ۡj1÷@/ ǹEDm'Dd>ڄdT"0`F~)\XmME=ay$9Ʃ5ȑV-/QQ=åp5pNpb@YV ҺH7M3IJ$o.شϺyu:6泛7 ͬI1VMzDetail /. Ratings Tab Delimited:'&&"!   /.,Ratings flat-ASCII:$##   /.,Ratings CSV":  &u`wjphvbvz(u`wjphvgm`w`vbjj(u`wjphvw`adfmjojwfd(ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  " ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o "  "ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o "  ! ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o !  !ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o !    ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jKwwf] O|A V#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   w wۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o w  ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o VCEN++ __A__O{O"w ,iTWilliamsonBrandon9('  ,iTWesleyTrevor8#" ,iTIdlerZachary8#" ,iTKrauseLisa7!  ,iTBluehdornJordan7&% /McMasterColten6%$ ,ybWarrenAlex8!  ,fOCarlsonJesse7#" `iTKathAllison5"! ,iTArnerAshtin7"! 9iTBenitezChristopher7)( iTHuntSamuel9!  iTKeintzAlexander9&% ,iTCruzJonathan8#" LiTPlecityD.J.9"! VoDylan8 ,,,MartinezBrandon5&% ,,,MartinezMichael6&% y ,VasquezAlbert9$# u ]~fTranKy8 t ~ThakurAshu9!  s qTemyankoSvetlana7'& p , StinelyPatrick7%$ i ,~fSmartMatthew8#" g ~SharpTrevor7"! e ,iTSenneJared8!  d ,iTScottTommy9!  c ,iTSclafaniSamantha8'& ` ,{gSainzFrankie6#" [ |hRomeroAlex9!  Z ,{gRomeroAlberto6$# X , RogersShana6"! T , RobbinsGrant6#" S , RiviniusBilly7$# R , HaungJasmine6#" Q =iTHarosSelso9!  P , HardyNathaniel5%$ O 22GrohJacob5  M <99GramlichTaylor7%$ K ZGrandiPaul8!  E B{gGarciaAnthony7$# D U}eFreehJoey9  @ 0FalbaumMason7#" ? ,FalbaumBarrett5%$ > >}eEydeBen8 = }eEspyTyler8 { @ @ @ @ @ @ @ @ @KKDL OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl DecimalPlaces DefaultValue RowSourceType RowSource BoundColumn ColumnCount ColumnHeadsListRows ListWidth LimitToList ColumnWidthsFormatFilterOrderByValidationRuleValidationText DescriptionCaption InputMask R Last Name      mS First Name      m/ID   X Rating      0  m Team      0  o Table/Query_ WSELECT ID, School & " " & TeamCode AS Team FROM TeamList ORDER BY School, TeamCode;         0twip  0;2880 Board      0  o Value List 1;2;3;4;5         0twip  Section )     0  o Table/Query( Select ID, Section from Sections       0;1440   0twip  School      0  o Table/Query SchoolList       0;2160   0twip _ Active    Yes/No  Yes  j Grade  VCeLN--            sFlagsFormModuleNameReplicationVersionTypeTypeInfoVersion-Index1---Colten6%$ ,ybWarrenAlex8!  ,fOCarlsonJesse7#" `iTKathAllison5"! ,iTArnerAshtin7"! 9iTBenitezChristopher7)( iTHuntSamuel9!  iTKeintzAlexander9&% ,iTCruzJonathan8#" LiTPlecityD.J.9"! VoDylan8 ,,,MartinezBrandon5&% ,,,MartinezMichael6&% y ,VasquezAlbert9$# u ]~fTranKy8 t ~ThakurAshu9!  s <TemyankoSvetlana7'& p , StinelyPatrick7%$ i ,~fSmartMatthew8#" g ~SharpTrevor7"! e ,iTSenneJared8!  d ,iTScottTommy9!  c ,iTSclafaniSamantha8'& ` ,{gSainzFrankie6#" [ |hRomeroAlex9!  Z ,{gRomeroAlberto6$# X , RogersShana6"! T , RobbinsGrant6#" S , RiviniusBilly7$# R , HaungJasmine6#" Q =iTHarosSelso9!  P , HardyNathaniel5%$ O 22GrohJacob5  M <99GramlichTaylor7%$ K ZGrandiPaul8!  E B{gGarciaAnthony7$# D U}eFreehJoey9  @ 0FalbaumMason7#" ? ,FalbaumBarrett5%$ > >}eEydeBen8 = }eEspyTyler8 {qg @ @ @ @ @ @ @ @ @KKDL OrderByOn ColumnWidth ColumnOrder ColumnHiddenRequiredAllowZeroLengthDisplayControl DecimalPlaces DefaultValue RowSourceType RowSource BoundColumn ColumnCount ColumnHeadsListRows ListWidth LimitToList ColumnWidthsFormatFilterOrderByValidationRuleValidationText DescriptionCaption InputMask R Last Name      mS First Name      m/ID   X Rating      0  m Team      0  o Table/Query_ WSELECT ID, School & " " & TeamCode AS Team FROM TeamList ORDER BY School, TeamCode;         0twip  0;2880 Board      0  o Value List 1;2;3;4;5         0twip  Section @@@8 9LVALE @@@@ @@fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd 1   Players.Grade[Calc New Grades].[NewGrade]A wͬ PMzDetailoWhited White_LabeloBlackk GameResultd $Tournament_Labelo#TournamentmWhitePointsm BlackPointsmWhiteRatingmBlackRatingd (Section_Labeld ,Board_Labelo+Boardh &CloseFormo'Sectd "Round_Labeld Players_Labeld Black_Labeld Rating_Labeld Change_Labeld Result_Labeld WhiteWon_Labeld BlackWon_Labeld TheyDrew_LabelioptWhiteWonioptBlackWonioptTheyDrewm!Roundh -DeleteRecordj.FilterToRoundd /FilterToRoundLabelLVAL 0i_VBA_MODULEDPMzCx CD 6:>BFJNRVZ^bpfrjvnrv~zz~h@[LS S(Lt>LLLLLLLLLL^6[[H  (``_`___H_]@ _r @_p _ _"0dX@x_l X@`h (@f @_d __@b (`_@p`P @@`L @`H @X`D @`@ @0 @, @`( @$ @` (a_&@a (@  _* LVAL =ba8bbad@ bx @Pbh @d @hbT @D @4 @0 Pc8c@x dX&(@,',`(p,(,x(gdePexggighd"^Z\@dT @fP @ e@ H@8e0 @e @@he @e @e @e X@e @e @f @(f @@f (@Xf @pfp @f` @fP @f@ @f0 @ @g @`g @g @0g @Hg @ @ @ @g gg@ p,gx(@g @h @(h @@h (k@Xh @ph @h @h @h @h @h @i @i| @0ix @Hit LVAL >@`ip @xil @ih df`b @id @i` @i\ @jX @T jj8kj@ kx @kh @X @PkT @D @@ 865m lhl8lmXmmpm8d@Plt @ld @l` @lP @lL 5@m< 4@8 @l( @l @(m p@ @@m @ @m mXmi@ wNmrl^@ @ onno`on8^T@nx @0oh @d @Ho` @P @@ @< @4 0pp@x 345.53H554@sq0qxqssu8rhd"^Z\@qT @(sP @HqLVAL ?@ @`q0 @q @q @q @q @q @r @ r @Pr @hr ssi@r @r @rp @r` @rP @r@ @s0 @ @Xs @s @t @ps @s @ @ t p@ @t @ @0t @Ht @`t @xt @t @t @t @t @t @u @ u @8u @Pu| @hux @ut @up @ul @uh pf`b @ud @v` @(v\ @@vX @T w(wpwv @Xwx @@wh @X @wT @D @@ wx^x @h (y(d (y` @P (@ LVAL @< @4 yx @h z(d @` @P (L @< l;F;^@^@ "H]ME ] (] "0] wH] "P] ;X] ,h] x]]S]] ] "]]]] ]] 6^"A8^ B`^ h^ L_ $`_,R_0q__ _ _ `@H(` h`  x` ` ` N` a3a(Ta @aHa Pa "  Xa `a "hapaxa "aNaa " aUaa " a a1aabb0b b (b " 0b8b#@b $)Hb pbNb b  b bIb bb )b c " cc c(c0c &8c `LVAL Ac pc cc c cc cc c c " c HdHdPdXd`dhdpdxddd Hd #d#d dXepe xe'e e e e e e e f  f 8f Hf Pf Xf hf f f f f f f f ggg g 0g >R8gFxg g >RgFg h  h(((h  @i Pi  Xihi pi xi "i i Bi i j 0j $Pj xj j j "Wj .j (k (@k hk xk kk kk k " k Hkkllll l(l0l8l H@l #Xl#`l hlm m (m'8m Hm Xm pm m m m m m m m n n n 0n @n Xn hn n n n nnn n n >RnF(o Ho LVAL B>RXoFo o  o((o  p q  qq  q  (q "0q 8q BXq q q q $r (r Hr hr Wpr .r (r (r s s  s(s 0s8s @s " HsPsXs " `shsps " xsss "sss s  ysss gt 3t(t 7@t&Xt 8tt 5ttt 3tt 7t&u 88uPu 4huxuu_u $fu?u Su uivi(v @vHvPv Xv`v hvpv xv " vv  v vv vvv v " vv vw (w0w 8w @w`w hw "pw 8]xw x(xx0l`lXZlHl80lh " rA@~  "N )Nd= 5_C@* Enumerate the specified Recordset object.X7LVAL C7`nXlP rB@B B@Bating Hello!A@`$ Xh$.  $select rating from Players where id= "$ X | %v.rhelloA@`hlZhNext` "$.to  $select rating from Players where id= "$ X | %v.r rA@~xamHello!A@`may rB@B as B@Bd ahmouseupA@`m B@B/ B@Blayer k End Ifl B@!Closeh  rA@~iabHello!A@` 2"f' B@Bhl* Find the record that matches the control.[ID] = " !*B@, !*!. (.l !*!. (.[ID] = " 2B@,l* Find the record that matches the control. 2B@B. B@BA@Me.4Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo12](Me.Bookmark = Me.RecordsetClone.Bookmark4Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo12] ",  select * from Players where id= "  %v.ect ra  select * from Players where id= "  %v.2  ElseZA@lHQlA@ B ahl If WhiteWon Then% r1 = Me.[White Rating Before]% r2 = Me.[Black Rating Before]' delta = 16 + Int(Abs(r1 - r2) / 10)' delta = 16 - Int(Abs(r1 - r2) / 10)A@ "th hig Higher rated player wonatZHQ White won   )( e?HQ They Drew   )on Higher rated player wonRah0 !  ("g Higher rated player wonahk  )@)   ')   )LVAL D    "$^'     '  )l  & "B@$(u  *!,A@`(X  F'g  F'g  F'g  F'g  F'g  F'g  F'g  ))   )   )  F'ga  F'g   ')   '  F'g  )  )@ha  ))  )@)  )  )>  )  )  )>kku8 0 u D B pZ !d(l Table/Query v"x"z(t EmployeeList v"x"z(|  (ox Ml uLeague Match 1 )de]; 8l A@X !d' l  ) l*to a single record in the Customers table,0cmboCompanyName combo box control. The combo boxng7is filled by an SQL statement that returns the customered$The CustomerID has a Text data type.Custom.ID (in the bound column) and the company name.typeSELECT * FROM Customers  WHERE CustomerID = ' "!R'''/The next example changes a form's record source -depending on the company name selected in the025PHu80(u u recs.CloseameDim ctl2 MsgBox ctl.Namen Me.ChFor Each ctl In Me.Controls FROM ") " )8 " )X End If "8$d "$dOW  HQNaHQHQ " )e, " )OM " t )BY " t )am " )X "B@BLVAL Eu *!,A@`lA@l "f (h " ( " ( B@0Get a list of the Results tables in the database  recs.AddNew B@Bcs!Mov " ) " ) f " ) HQ " ) "f )llA@HQh " ) " )8 %lZA@ ll Me!Board = recs!Boardu# Me!BlackPoints = -delta" Me!WhitePoints = deltaMsgBox Me!BoardEnd Sub/Q " )B recs.MoveFirst     "B@ECT *!,A@`ecl " )   )tA@l %4$d " ) " ):: "f ( Me.Section.Properties. Me.Board = recs!Board " ) B@BwlA@X " ) " ) " ) " ) "$d= recsh recs!White = Me!White(8paha     'hX  )a@  )  )h  )a  F'g  F'g  F'g  F'g  )  )     '  F'g  F'g  )     'ah  F'g  )  )h     '  F'g  F'g  )a@     '  F'g  F'g  )  LVAL F)h     'h     '     '  F'g  F'g  )   a     'h  F'g  F'g  )  )  )   F'g " " '  F'g  F'g  )  )   )   )   )  )HQ White Lost (Black Won))   )HQ White won   )  ))   )4get a list of all the results tables in the database1Insert all but "Results" into the Tournament list/Provide an option for creating a new TournamentlZh F "d(|Z F $%.!;'Fs " ) insert the table into the list " ): + 5 t tl F F;~ $  )db A better test is to make sure the table has the same structure as the Results (boilerplate) table< The following test is a poor check, but for now it will do.x $!.!: bles il " ) If Me!Sect = 1 Thenlol (!d ((Round = "h (h "8 ) " )8 " )h " )8 " )A@lA@lp recs!Round = Me!Round ReloadEnd Sub Me!WhiteRating = recs!Ratingay$ If Not IsNull(recs!Section) Then $%.!$ Results $%.!  %4 )&ratingm Play %4$d %4 LVAL G)8 "$^ 'tMe!Whi recs!Black = Me!Black recs.Update recs.Close)# Me!GameResult = recs!Result) Me!Black = recs!Black i Me!Black.RowSource = "SELECT DISTINCTROW " + "ID, [Last Name] &"", "" & [First Name] as Name, Grade, Rating, Team " + "FROM Players " + "ORDER BY [Last Name], [First Name];" recs!Section = Me!Sect Me!Round = recs!Round Me!Sect = recs!Section$ Me!Board = recs![Team Board] Me!White = recs!White, Me!WhiteRating = recs![White Rating], Me!WhitePoints = recs![White Points], Me!BlackRating = recs![Black Rating], Me!BlackPoints = recs![Black Points]Round = "h (dS( On Error GoTo Err_Store_Result_Click recs![Team Board] = Me!Boardun"3 Set recs = CurrentDb().OpenRecordset("Results") recs!Result = Me!GameResult( recs![White Rating] = Me!WhiteRating( recs![White Points] = Me!WhitePoints( recs![Black Rating] = Me!BlackRating( recs![Black Points] = Me!BlackPoints% recs.Bookmark = recs.LastModifiedExit_Store_Result_Click: Exit SubErr_Store_Result_Click: MsgBox Err.Description" Resume Exit_Store_Result_Click %4 )&rating %4 )8o  %4 )p %4 ) HQ White Lost (Black Won)ecHQ They DrewHQ White won Me!Sect = recs!Section Me!Board = recs!Board %4$d %4 )8 %4 )luHQ White Lost (Black Won)HQ They Drew " "  '" ( tablelh(  (x( "8LVAL H(Z0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do.b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results  insert the table into the list F $%.! $ ;'Fh'  F "d(| F F;~ $  )dA@XResults "d (Results "d (&l(+0+" +    "B@    "B@*u***l**l+lllA@ % !.'ug  (. enth+ (  (..FilZl+ ( Me.Bookmark = b Me.FilterOn = True l (Dim b !.'`(ll+l+llh++Zl, (l,A@aRound = "h ( Me.FilterOn = Falsed(A@End Sub Dim b As String Me.FilterOn = False b = Me.Bookmark% Me.Filter = "Round = " & Me!Round b = Me.Bookmark% Me.Filter = "Round = " & Me!Round Me.Bookmark = b Me.FilterOn = True  (.b (b = Me "h( "h(ilh+Z 'Z 'Round = "h (il (. (l*(,Z ( !.' "h "h( A@X (l%l * Me.Bookmark = b Me.FilterOn = True "h "h( "h "h(l)ZZ0Get a list of the Results tables in the database $!.!LVAL I: < The following test is a poor check, but for now it will do. b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results insert the table into the list F $%.! $ ;'Fh'  F "d(| F F;~ $  )dA@Xl'A@lp'h' %4 )&rating %4$d %4 )8 %4 )h&A@&u&&&l&&ZpDl F'8 %4$d %4 )8 %4 )h8&A@(&u &&&l&Results "d (l%h,l%l%l% If rst.NoMatch Then If rst.NoMatch Thenct$ End If "B@,hZ1 Set rst = CurrentDb().OpenRecordset("select")5 Set rst = CurrentDb().OpenRecordset("select") !.'s ! !B@    "B@%u`$X$ *!,A@`@$l8$"0$ !B@    "B@$#u#"# *!,A@`$#l#00*# !B@ "B@,.#u#*# *!,A@`.h#l`# B@  (  '  "B@arh h' DoCmd.FindRecord Whiteh" B@Round = "h ( ( ! B@  "B@ B@ ( h _ "B@,( ( ! B@  "B@ B@Z h'! "B@4hronTurning filter off... "B@4on "B@4g fiZZ 'Turning filter on... "B@4LVAL JZZh BZ'FBMake sure the selected player hasn't already played in this round. h'ZZ Bha ! 'B (b().Op !"Sel B@ [Resu  "B@rn h _ "B@,re Whi B@ Roundh "B@4$ If Not Me.NewRecord Then" DoCmd.FindRecord w Loop_ End If White.SetFocus# Do While Round <> r" DoCmd.FindNext& FilterToRound.SetFocus DoCmd.Echo True "B@X Wh "B@< Do'F  !6Fug f "B@<ts Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.; "  B@B "Z  "'L w "'PWhite'R B@B. "'P!Select * from Players where id = $%v.Black'Rh; "Z  "'L B@B!Select * from Players where id = P$%v. "Z  "'N B@BhX: B@V  $ * $ ^ L already played in this round! $ ^ (with  R against  N) $ ^ $ ^ Are you sure  L is the right player? Z \ f Are you sure?$` bh=ZZZZZZZZ  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.al B "  "'Pwon'jna= "'PBlack'Rhx=hp= B@BLVAL K B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X B@ & B@^ ! 'Blayed ! 'B $ ^l Me.UndoA@ End IfhxIncomplete recordA@`sure B@V i $d $d   ?l "B@<'F B@Vh0;h(;3l;BMake sure the selected player hasn't already played in this round.ZZZZZZZZ  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v. ! 'B B "  "'PWhite'Rax9 "'PBlack'RhP9hH9 B@B B!Select * from Players where id = $%v. "Z  "'L B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X  $ * $ ^ L already played in this round! $ ^ (with  R against  N) $ ^ $ ^ Are you sure  L is the right player? Z \ f Are you sure?$` b "B@<'F B@Vh7h74BMake sure the selected player hasn't already played in this round.ZZZZZZZZ  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.7 B "  "'PWhite'RkLVAL L "'PBlack'Rh05h(5 B@B B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X1 MsgBox "Can't insert - Incomplete record"" MsgBox "Incomplete record" Me.Undo Cancel = Truel` DoCmd.CancelEvent End If Cancel = Truee re "B@<'F B@Vh2h2l2Zk "BjHQ White wonkHQ White wonHQ Black wonHQ They drewlost to 'jlost to 'j won against 'j drew with 'j won against 'jHQ Black wonHQ They drew drew with 'j "BHQ White won won against 'jHQ Black wonlost to 'jHQ They drew drew with 'jk1HQ White wondrew'jh 'kHQ Black wonlost'j'jHQ They drew with Black'nkp0ah0 "'Plost'jn "BHQ White wonwon'j'jHQ Black won with White'nHQ They drew with White'nk/ "BHQ White won won against 'jHQ Black wonlost to 'jHQ They drew drew with 'ja/ "'PBlack'R "BHQ White wonlost to 'jHQ Black won won against 'jHQ They drew drew with 'jkH.h@.drew'j ' "B HQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'ja- "'P with Black'n "BHQ White wonLVAL Mlost'jHQ Black wonwon'jHQ They drewdrew'jk, with White'n "BHQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'jk@,a8, "'P with Black'n "BHQ White wonlost'jHQ Black wonwon'jHQ They drewdrew'jk+Z  + 1 $ ^ h already played in this round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b If M DoCmd.CancelEvent  + 1 $ ^ h already played in this round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b^ If IsNull(White) Or IsNull(Black) Or WhiteRating = 0 Or BlackRating Or GameResult = 0 Then^ If IsNull(White) Or IsNull(Black) Or WhiteRating = 0 Or BlackRating Or GameResult = 0 Then( MsgBox Err.DescriptionXUlxUpU(9lU B@H:lxU B@`Uh $%.!Results TemplateU 6hVhhl'0 Fh%z Create New Tournament Results Table  "B@`UVa0 F F;~ $  )dA@XV@ 6don't show the formhen exlVlVlVlV'0hV "B@B'0Z'0XVZW'FW F 6 Frg "B@BhWW "B@BhWW "B@B'0 End If LVAL N If Not AbortForm Then AbortForm = False DoCmd.CloseHThere doesn't appear to be a way to cancel the form on startup... *sigh*@WWhite.Column(2) is SchoolWhite.Column(3) is GradeluWhite.Column(4) is RatingWhite.Column(6) is BoardWhite.Column(7) is SectionWhite.Column(0) is ID) isWhite.Column(2) is School<White.Column(1) is Name (=[Last Name] & ", " & [First Name])White.Column(5) is PlayerTeam<White.Column(1) is Name (=[Last Name] & ", " & [First Name])White.Column(3) is GradeWhite.Column(4) is RatingWhite.Column(5) is PlayerTeamWhite.Column(6) is BoardWhite.Column(7) is SectionBlack.Column(0) is ID<Black.Column(1) is Name (=[Last Name] & ", " & [First Name])Black.Column(2) is SchoolBlack.Column(3) is GradeBlack.Column(4) is RatingBlack.Column(5) is PlayerTeamBlack.Column(6) is BoardBlack.Column(7) is Section %4 )ah H' H ' 8!R 8((U !R (h\ !R$^ (\]Z; B@Black.l\ 8!R 8( !R (a\ !R$^ (h\lx\8ZHZ Z 'F 60Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do. b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results insert the table into the list $%.!Results Template F $%.! $ ;'FhHZh@Z  F 6 Frg%z Create NeLVAL Ow Tournament Results Table  "B@ 6 Fdon't show the form'0HThere doesn't appear to be a way to cancel the form on startup... *sigh*a0Y F "d(| F F;~ $  )dA@XhXlXlXA@XlXResults "d (lX "h "h(l`X"  "h(A@a0XA@ "h(hXlX %Z 'Turning filter on... "B@4 (Round = "h ( ( ! B@  "B@ B@h@W "B@4l(W%ZHZP$ ' h'Turning filter off... "B@4 ( ! B@  "B@ h _ "B@,pV B@hXV "B@4l@V (BMake sure the selected player hasn't already played in this round.Z'Z`(Zx(Z(Z(,Z@,ZX,Zp,Z,  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v. ! 'B B B@ "  "'P with White'n "BHQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'jkSaS "'P with Black'n "BHQ White wonlost'jHQ Black wonwon'jHQ They drewdrew'jk(Sh ShS B@B B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@XLVAL P  + 1 $ ^ h already played in this round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b "B@<'F B@VhPhPlPP4White.Column(0) is ID<White.Column(1) is Name (=[Last Name] & ", " & [First Name])White.Column(2) is SchoolWhite.Column(3) is GradeWhite.Column(4) is RatingWhite.Column(5) is PlayerTeamWhite.Column(6) is BoardWhite.Column(7) is SectionxO %4 )&rating' If Not IsNull(White.Column(7)) Then! Me!Sect = White.Column(7)" Me!Board = White.Column(6) End IfA@NuNNNlN4BMake sure the selected player hasn't already played in this round.Z.Z3Z4Z4Z5Z5Z05ZH5Z5  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v. ! 'B B B@ "  "'P with White'n "BHQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'jk8La0L "'P with Black'n "BHQ White wonlost'jHQ Black wonwon'jHQ They drewdrew'jkxKhpKhhK B@B B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X  + 1 $ ^ h already played in thisLVAL Q round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b "B@<'F B@VhIhIlI(9Black.Column(0) is ID<Black.Column(1) is Name (=[Last Name] & ", " & [First Name])Black.Column(2) is SchoolBlack.Column(3) is GradeBlack.Column(4) is RatingBlack.Column(5) is PlayerTeamBlack.Column(6) is BoardBlack.Column(7) is SectionG %4 )' If Not IsNull(Black.Column(7)) Then! Me!Sect = Black.Column(7)" Me!Board = Black.Column(6) End IfA@GuGGFlFH:A@lF@A@lFAA@lFpDZ5Z6F " "  '  F'g  F'g " " "HQ White won  )HQ White Lost (Black Won)   )HQ They Drew  )kpEahE "HQ White won  )HQ White Lost (Black Won)   )HQ They Drew  )kDhD " ) "8$d "$d "8 "$^ 't t t " t ) " t )hChChCCuCCClC0FC "B@BCuCC *!,A@`hCl`CpFPC    "B@    "B@CuCB MsgBox Err.DescriptionBlBFlBBlwA@HlwA@H@HlhwA@Hhw B@wtestA@`wwwLVAL R . x?Attribute VB_Name = "Form_Enter Results"D Bas0{1A8FBF50-4D05-11D2-A37A-00A0C9D@C1E0E} |CreatablTrue ]Pre declaId"Expose!Fals @TemplateDeriv%Cust0omizD$Option Com2p@ DTv  8 AA@Left$, 8)("%"T&insert(in@!67  <> 凵 J& Mid9) & ";?P!ebEduNext i'" Or[>[q`| ExESGDoCmd.Openm "z  e New burnB@U0BX", %acDialo@lBdjnn 8'don't svhX5f`'=6 "' Xdoesappea \o] eway ?cancelB startup... *spigh* #Me!To .RowSc,GU#[@, In(1, >)A~D'Rel@ )5_Una(Cͤ V=_l!+Sub{eYMe.RecordV:W`0 vpRPd `Mmu?6FilrTo?@)Z)En![13qDis a-_p;i rwNpw(Whit > Echo , "T-aff 21DI On .`"L ;Not=. F#$b .Se#S Finddw3 4u7RE /:r?4rOQ/.ff?rK=/d/te/ / SPe 1q_LoopoHbq te_Be]eP#'M*selpy@͋2dl`dy RvdprIp.R1rSԦ pr"ӯm pcol[Mop_Qp 'Rg2sePu APlay01$b++.Old¼R%SSspuh.C< r 4= Op ("S * fro8m [dѓ]" _A& " xwheP*І@r a( " >pbR F)"b= n .MoveFi Pz!E p:a r!R #Qwitnh0C !({1 'e won  presultP = "|" Case 2 ' Blacklost3They drew  AEnd Sel ect ;ElDse Iopprst!Whit @pcolorr with g 42 yLVAL S# 21g16'ƨEAYIf;B.CuSIf AlreadyPlayeNYA(0Cancel 0s ca1AMoveaP@p<5a r!mAopJo5qo7 u?p_  o RkWB /))"4e1 1g@@ye3?7[ O O O O &\DEU\ BIRK  ŏ E qSoվFʹ & " against& o@ppname)"(Chr$(10) (_ Are you8 sul is the right play er?" , vbQuestion + YesNo DefaultButton2, " k?") <>/ Then DoCmd.Cancel`Event  @= TrueBlack.UndoEnd If "Sub Priva(te  )_AfterUpd () '4Co`lumn(IRD 1)N(=[La]̆"[Fir +2Schoo l -3Grad @K#4RatiTng 5PtT(eam6Bo(ard7Sec|PCOn Error GoTo_L Me!(qB.R4AAIf Not IsNull(7))'A&}M7E 6 6 CalcP ointsxit6:7E rr Resu nd 8͡X!TG@Xlt_TG)gDim delta As Int0egerc)!bonus./N 5 # = (Abs(A?WhiteN- A) / <10 Aa`O< 0"M= 0> 15+158{>"# Selk CaseLVAL T.Gb1 ' b woAeÃV ]16 -22Lo #l WLond 6 -(` +7c h"3 @y pDrewa .-B,BW" cEls@#&#ei##oa#-#e=9&]# Bm0Q-[ (T0D) A{_V% ?/$1%|+A:= &<(Val!7>= 1<= 41 + "p ( b\G` q_I` @0ub CloseForm_ClickTP5 Q! ;  _pM sgBox!.Descrip*o)D`@ZecordoDoMenuIt em acqBar,Edit`, 8, Vxer7]s6! rRr4_GotFocus5$R.Dropdow@ea.6(__SRP_4(rU  ;1i 1 1 Y " ]y A i )ي ! DyDDEA;Y aEEEE!FAFiFFF81y8I99iG:CY;; HHHIYIaIHqH ,)ي@6@:Qy@>1!@BIQqq@Fq@Jq@Nq@ Ra@ V9a@ZQ@ ^aLVAL U@bq1@f9ppp@jQrrrq@nQvvvQ@rIQ@vIQ@zIQ ~~~@~IQ)zzz@QI???__Px! x (x$ x0;hx! x Xh`#`d! d /`)xd5h,hx! x Xh(P]1@x5h\ #`x! x /`xShx! x Xh`#` :t4o4#<d! d 2`<)xd5hH$ $`<xdh@XCtxcpEAzfhl"$ l Dh kf)lhcb(,kzD0%@D"$ D D@ 0, 8HLkzDP%hl"$ l Dh 0L 8lHJl( #$ 22H($) lhLD@,RHLkzDP%hl"$ l Dh 0L 8lH ?/H)lhLqHLkzDP%hlLVAL V"$ l Dh 0L 8lt' lH #(*#$ *1t2H($)lhL5 zdbZlt?kxEH'%'%'%:P %l"$ `l `l6 xdp lt2^ 43ltF0%h:P%l l $h)lhTlt lt F%h:P%l l $h,)lh5( t< H($lhLD@,0   <  $ TN:D d:h%x x $daT4`#0 (/0)xd6T4LT$ 0xdT40   0 "  0 %  0 %  E0T! T X0@P! P 0@1 )PT60@\J#@T! T X@UpzT5@#@T! 8T L@UpbT5@'%'%'%:P:%T T $Pa@0: :kbD:kzDp:`PkzD@0: `# "$  Q\/)TP 6@0 pP0\ plpZkZ \ '@:%\ $@kzD]105@\T@:%\ $@Upj5@ Cl@:!%\ $@(]1\"CpL(]1\2#CpL(]1\L$Cp5@:%\ $@Upj5@%Cl@:!%\ $@(]1\#Cp(]1\"Cp(]1\$Cp5 \ kZRP' %'0%'@%&kz#*#T"$ T QP\2T6@0 F@:'%\ $@:(0 :)%\ $ `1t6@0 \ RP' %'0%'@%&kj#*#T"$ T QP\2T6@0 F@:'%LVAL W\ $@:(0 :)%\ $ `1d6@0 \ T"$ `T $T *1d *1` *1\ *1X *1T'' :,N00 >d#lt*#-*#>`#*#>\#*#.*#lp*#ll*#/*#ld*#*#>X#|*#x>T#t*#p0*#llt*#h1*F@^+W2&|xtplh6@0 T"$ `T (T T! T $T(@ (ldt\p)|xtplhd`\XTTP @0 pP0tKhWX'h%x! x ,X%@:D2%T T $@,)xT@6hX0 e@<t$ l xT@hXE0T! T X0@P! P 0@1 )PT60@\J#@T! T X@UpzT5@#@T! 8T L@UpbT5@'%'%'%:P:%T T $Pa@0: :kbD:kzDp:`PkzD@0: `# "$  Q\/)TP 6@0 pP0\ plpZkZ \ '@:%\ $@kzD]105@\T@:%\ $@Upj5@ Cl@:!%\ $@(]1\"CpL(]1\2#CpL(]1\L$Cp5@:%\ $@Upj5@%Cl@:!%\ $@(]1\#Cp(]1\"Cp(]1\$Cp5 \ kZRP' %'0%'@%&kz#*#T"$ T QP\2T6@0 F@:'%\ $@:(0 :)%\ $ `1t6@0 \ RP' %'0%'@%&kj#*#T"$ T QP\2T6@0 F@:'%\ $@:(0 :)%\ $ `1d6@0 \ T"$ `T $T LVAL X *1d *1` *1\ *1X *1T'' :,N00 >d#lt*#-*#>`#*#>\#*#.*#lp*#ll*#/*#ld*#*#>X#|*#x>T#t*#p0*#llt*#h1*F@^+W2&|xtplh6@0 T"$ `T (T T! T $T(@ (ldt\p)|xtplhd`\XTTP @0 pP0tKhWX'h%x! x ,X%@:D3%T T $@,)xT@6hX0 e<t$ l xT@hX0 H:  0 @  0 A  Ky8:<2%L L $8a(`:d3%t t $`aP( Upz)t`L86(P kzpz kzpzg8:<2%L L $8a(`:d3%t t $`aPr)t`L86(P\&3`:d4%t t $`aP)t`(d]1<\7kzD<%`:d5%t t $`,)t`(d]1<\8kzD<%`:d5%t t $`,)t`(d]1<\5kzD<%`:d5%t t $`,)t`5?3`:d4%t t $`aP)t`(d]1<\7kzD<%`:d5%t t $`,)t`:(d]1<\8kzD<%`:d5%t t $`,)t`:(d]1<\:4kzD<%`:d5%t t $`,)t`5_`:d5%t t $`aP(%8:<6%L L $8,)t`L85Pf`:d8%t t $Q`oP 78:<9%L L $Q8o( 7)tL6P(?`:d8%t t $`aP1LVAL=}O#oHwN#uK#wIoJ#|S* b ,iTFortnerDaniel8$# a ZiTStewartGalen8#" _ LiTWillieAdam9!  V d11BrerenRyan7!  U ,99(<]1()t`5P\~S`:d9%t t $`aPP`# :topx/)t`5Pkxkx|i`:d5%t t $`aPkxD<(%8:5%L L $8,)t`L86P(i`:d6%t t $`aPkxD<(%8:6%L L $8,)t`L86P( , 8 t`L8P(0 0F  0 pF  Px! x (x$ xnbbb:B>  j j n nZV^Rj7__SRP_5frU $`$$)` $i` (`8&$`$)`$i`$`$` $) `(i ` &$ `(  ` &$I ` $`$$`($ `,$I`0$`4 $`8 $ `<$pLVAL Z0=Babce gUhij<k[Event Procedure]{1@[Event Procedure][Event Procedure][Event Procedure]Arial8hLNEC Silentwriter LC 890g od,,` &hO[&XdCustom page 1BBCustom page 2BBCustom page 3BBL)WINSPOOLNEC Silentwriter LC 890LPT1:[Event Procedure]d2hgh MS Sans Serifi1ghj1ghk1m45o2`Detailo5W`bc dephq8"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"10";"0"WhiteWhite Table/Query PlayerList0;1872;1296;576;0;0;0;0[Event Procedure][Event Procedure][Event Procedure]+"PlayerList";"Players";"Teams";"Schools";""d5]`abc White_LabelWhiteo5W`bc depn8"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"10";"0"BlackBlack Table/Query PlayerList0;1872;1296;576;0;0;0;0[Event Procedure][Event Procedure][Event Procedure]+"PlayerList";"Players";"Teams";"Schools";""d5]`abc Black_LabelBlackm 7W;`abk WhiteRating White Ratingd5]7`abc Rating_LabelRatingm 7U;`abk BlackRating Black Ratingm 7W;`0abk WhitePoints White Pointsd5]7`$abc Change_LabelLVAL [Changem 7U;`0abk BlackPoints Black Pointsd5U` ab(cd Players_LabelPlayersk5U`apb.chi GameResultResult[Event Procedure]1d25U`ab(c Result_LabelResult:i2W3W`ta optWhiteWond5`dabHcWhiteWon_Label &White Woni2W3B` a optBlackWond5` abHcBlackWon_Label &Black Woni2W3D`a optTheyDrewd5`abHcTheyDrew_Label They &Drewm 7U`abhchi kRoundRound[Event Procedure]1d5U`,a,b@c Round_LabelRoundo 05Ubcd,eh n Tournament Value List1440[Event Procedure]d5U`ab|chd Tournament_Label Tournament:h 1U` a bi CloseForm Close Form[Event Procedure]H Close Formo 5W`bc,den"";"";"";"";"10";"10"SectSection Table/QueryISELECT DISTINCTROW [Sections].[ID], [Sections].[Section] FROM [Sections];0;744[Event Procedure]u"SELECT DISTINCTROW [Sections].[ID], [Sections].[Section] FROM [Sections];";"Sections";"";"ID";"Section";"PrimaryKey"d5]`,abc Section_LabelSectiono 05WbcdenBoard [Team Board] Value List 1;2;3;4;5492[Event Procedure]d5]`a bc Board_Label Team Boardh 1U`Pa| b@c@i DeleteRecord Command75[Event Procedure]D( ȤLVAL \LVALH$H$H$ H0 800"66666  $ $ $ $ 0 $ $6P6`h`Hh 6p"6 $ $ $@  $ $ $ $P"(9`@< Delete Recordj2U`ahbxcxi FilterToRound[Event Procedure]0d5U`Ta,b$cFilterToRoundLabelShow only this round_,T3y $N (`<@Q@ 6H P X %6# $iF ' $6H' $#%  $`tx '6%&D`(`D@  V(, `@ c`z %H$H$')D$6H)D$x)D$H$H$) $6) $* $H*H$6x*H$*H$6ԄMSysDbL#NForm_z Old Enter Results FormRNB>:sUtility$ sForm_z Create Results Table from Crosstable}`\PLHV:Form_z Create New Tournament Results Table~y_[OKG{jmForm_PlayerslaA=1-) k\_Form_Update Player Ratings^:OK?;7 Y/L/Form_Enter Results.GC73/*LVAL6<4*t4*8bh+?80*  k YH  @ `h p   + :      LVAL f  '0  @ HPX,`  hp   x     8.`  #   " (?  >  "   /  < H0xp0l`lP !ults r') Me.RecordSource = "Results - 97 RQ 2"ZZZ B@( B@b().Ex B@SERT I B@ ! !_ !b Z "2 "2 bQ 2] "2 "2 bM([Ra "2'' "2'FR\@  " '!GROU "2  B@te;'get a small recordsetGROU "2'\'h B@( 2{Set rst = dbs.OpenRecordset("SELECT Title, " & "Count([Title]) AS Tally " & "FROM Employees GROUP BY Title;");   Show old and new data.et!SELECT * FROM Players WHERE ID = $%v.ntX Old data:   X New data: 6 6 Update Player p's record B@eck A ( Restore original data because this is a)  demonstration.suC@ : : C@n B@ck; C@$scan thru next player in the b-tableCurren  " 't("SEL\\ $scan thru next player in the w-table2].[Bl "2' AS \p  " 'M [Res B@ 2] " "2' ! "2 ck;" ! "2 {|\  " LVAL g'oin B@ ! "2  R "2'h\  " '7 R B@ ! "2 in  " ' b-tab B@ B@ B@'scan b-table only   scan w-tabley "2'sc B@ ' B@ "2' "2'k  " 'p B@ ! "2 k h( the same record current.Z  " ' B@ ! "2  ! "2 Z "' ' B@ "2' " " ' :fh   scan b-table6Now we have the total point change, pts, for player p.C@59.WHERE criteria;4 Make changes to record and set the bookmark to keep " & !nUPDATE Players SET rating =  WHERE ID =  $B@ B@  " '97 RQ B@S Play$Determine the next player and pointsAS Poi  " 'lts 97 "' ' B@ RQ 2] "' ' B@ B@"GROUP "'")ayZ'P Z "f  ' "3 F,'g   F 'g "f 0 l  )BY [%Determine the potential rating changeP.Find the Player's record and update the rating"f  ZSELECT [Results 97 RQ 2].White AS Player, SUM([Results 97 RQ 2].[White Points]) AS Points FROM [Results 97 RQ 2] !GROUP BY [Results 97 RQ 2].White !ORDER BY [Results 97 RQ 2].White;$%v.  ZSELECT [Results 97 RQ 2].Black AS Player, SUM([Results 97 RQ 2].[Black Points]) AS Points FROM [Results 97 RQ 2] !GROUP BY [Results 97 RQ 2].Black !ORDER BY [Results 97 RQ 2].Black;$%v. ZZZ8ZXZpZLVAL hZZ   5SELECT White AS Player, SUM([White Points]) AS Points FROM   GROUP BY White  ORDER BY White;$%v.& " GRa w!Player = b!Player" ORZhl d Fd'g B@ B@   5SELECT Black AS Player, SUM([Black Points]) AS Points FROM   GROUP BY Black  ORDER BY Black;$%v. [Resu "(l0A@' R  d "( B@ B@ ! !_$Determine the next player and points ! "2' "' B@ !b "2' "' B@ "2 "2 b "2' "' B@ "2 "2 b "2' "' B@Z "2' " " ' B@ B@h.Find the Player's record and update the rating!SELECT * FROM Players WHERE ID = $%v. B@,' "f  '   F 'g4 Make changes to record and set the bookmark to keep the same record current. "f  C@ :fC@59.nphh` B@B B@B B@BZ'lFor Each ctl In Me.Controls MsgBox ctl.NameNext0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do.b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results  insert the table into the listZ  If p > 1A@H h  F "d(| F F;~ $  )LVAL idZ( F $%.! $ ;'FlA@Xp Reload0 Me.RecordSource = "Results " & Me!Tournament  F'g [Results "d]'dA@e Sub !'ss(b  'SU  ! 'AS Poi  '  'UP  '  'e;d  A@7  F'g "!' B@ "( "B@B%u $ X$ % ( *!,A@`"l "dB@ "B@lZZh0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do. $%.!$ Results  $%.!Results TemplateerplatA@ F $%.! $ ;'Fh  F "d(| "dB@plll B@Bed ResA@Zh Then the name wouldn't matter.roSee if it has any info in it...he ! h#There are no records in this table .A@`P ! SELECT * from [Posted Results]$%v.[Results Table] = ' $%.!' B@,A@8 "(edHp *!,A@`XPu8 ! B@BeRatinhZ B@B$The table hasn't been processed yet. insert it into the list .See if the results have already been posted...set $%.!$%v.( !d$dhThere is nothing to do!A@`x INSERT INTO [Posted Results] ([Results Table]) VALUES ( 'Results  "d');$B@ "d$dh`A@P "B@ "LVAL jB@ "dB@x F F F F;~ $  )d`F )dg' "$^, 'ah] A better test is to make sure the table has the same structure as the Results Template table "$da(h 'a "$^'a,'hh:P:L:P C@C@59.nxC@:L:PC@59.nH@?Attribute VB_Name = "For@m_UpdaPlayer Ratings"  Basb0{5631CD49-4DB6-11D2-A37A-00A0C9DC1E0E} |Cre atablCTrue ]PredeclaId"@ExposeFals @TemplDeriv%CustomizD$Option Comp@ D3Tv  v "(h_B+Spee i8 u have altDA=anyVfo!Wit!ah!h:2ga e@ .#p_> c 'sert[in`WoqgO a= & MidL9)A1;L1! ɜ) Cl NexD<$c.RowSbcx #pl() igap's50, In`T(1,, ";")AF) Ey~!cc_f7M|^vut c_Cxk^w!]WS^ b plyr' Lo9bptsA.eNewl󠂣FlUescabd2 jG ; nrecR c7xl>= q)DoCmd.H#glaxss ÙP#. MsgBox "E a@fnot*hBgod!1GoalExitdsc3/0&RQ*7]Fw`,9E#zzWhi AS S, SUM([SPo`Bs]) " _e<& " FROM`&  FLVALR`;oH a;Y0iDrIRXChallenger Elem. NogalesAlexArmenta6)(!,Challenger Elem. NogalesIrvinAmado7('"<Challenger Elem. NogalesDiegoAlvere6)(",Challenger Elem. NogalesSeleenaAlvarez6,+$,Challenger Elem. NogalesKevinAlvarez7*)",Challenger Elem. NogalesJulioAlvarez7*)",Challenger Elem. NogalesMikeyAguilar6*)",Challenger Elem. NogalesJosephAgostini8,+#,Challenger Elem. NogalesMartinAcosta8*)#Cast GROUP BY C/ORDER6 6u`w*N=.N+no "!Y/xeE @ .w.?LH¯Sw.MoveLas$mC+= bn?Black"S$ C/ 21.b  + b r<}Do%1w.EOF Orb'Dem™ndԡap._'<\p0 b!31S= l;r +ue wp'*m4 < a Q3 &<3p 2= w!Play er pts oints lw.MoveN(ext \rbr + 1,Else '>b!W\@(b2nd IfUpdateProgress 100 * r / nrec'Fithe 's Aord a u# ratingSet plyCurrentDb().Op enRec set("SELECBT>FROM1s WHERE ID" & p)+){Firs If IsNull(!Grade) Then R*Floo&250At VaK<= 3Ϝ 30# YnE+New6M@RATIN>G 4G < CK  ' Make changes toɄubookmarkkeepsame cC.WithAC.EdiL!Active=True ![Vd5is Yeadr].UYl B%= .LastModified?1!#+/<>_(*Qt!:= b%Pg.Clos/Loo> E&wIb Execute " INSERTTO [Posted Results]_cAa& "([D Table]) VALUES! "'Me!TournUnt "');" Ge>t$  Form.FocuExit_c Cjs_Click: DoCmd.H` glaFa@CC! Sub%Err jU `d PrivE 3(By p As Int0eger$a[ >{bpiC< 0= D"%?Line.Wid{= MaxLenp Perc.Ca ption LTrim$(Str$(p))!3%2Me.Repa aXub 6C( On aGoTo-Cc22d_A*MsgBox1.Describ9XLVALh1e4g3|LV#^*j:y,Challenger Elem. NogalesOmarQuezada9)(!,Challenger Elem. NogalesLeoPerez6&% ,Challenger Elem. NogalesDanikaNavarro8+*#,Challenger Elem. NogalesDamienNavarro8+*#iChallenger Elem. NogalesJoelMoraila9)(!,Challenger Elem. NogalesMiguelLopez9)(#,Challenger Elem. NogalesAlexLeon4&%!,Challenger Elem. NogalesJosueLarios4)(",Challenger Elem. NogalesJeovannyLarios4,+%Challenger Elem. NogalesBustamonteKasey3-,',Challenger Elem. NogalesLeeJones6&% ,Challenger Elem. NogalesAlexHerrera6)(!,Challenger Elem. NogalesRubenHernandez6,+"BChallenger Elem. NogalesAlejandraHeredia5.-&,Challenger Elem. NogalesVictorGrijalva4,+#Challenger Elem. NogalesAlainGodinez2*)"3Challenger Elem. NogalesRachelGillilland4.-#0Challenger Elem. NogalesMarkyGarcia6)(",Challenger Elem. NogalesJoseGarcia7('!Challenger Elem. NogalesEvelynFlores2*)#,Challenger Elem. NogalesLuisEscobar8)(!,Challenger Elem. NogalesMikeyDavis6('",Challenger Elem. NogalesAdamDavis6'&!WChallenger Elem. NogalesErickCox6&%"YChallenger Elem. NogalesAbbyCota6&%!Challenger Elem. NogalesAdrianaCoronado3-,$,Challenger Elem. NogalesMarco PabloCoppola40/(,Challenger Elem. NogalesManuelCoppola6+*#,Challenger Elem. NogalesAndre0=Babce ghDij/kN@Arial[Event Procedure]d2e12hgh MS Sans Serifm45o2w2`\ Detailh1U`adbc UpdateRatingsUpdate Ratings Now[Event Procedure]o05Ubc$ d en Tournament Value List1440d5U`ab|chd Tournament_Label Tournament:e15]`tapb chBox12e125`ab@ c ProgressLined457`ab@ ceProgressPercent0%h1U`4a bi CloseForm Close Form[Event Procedure]LVALxW7pK'mP,z[5~]:wV7rO0 DeGraziaEthanGoodin3 ,DeGraziaTeauntaeGlover4 ,DeGraziaKarlyGarner4 DeGraziaJ. JamesFoster2 ,DeGraziaAndersonFischer6 ,DeGraziaAshleeEgan6 ,DeGraziaMcKenzieDryden5 DeGraziaBrodyDryden2  DeGraziaAjahDinius3 DeGraziaJoshDettloff5 6DeGraziaElisaDettloff5 ,DeGraziaArmandoDenogean4 DeGraziaMakaylaCox3 DeGraziaTreyCooper3 DeGraziaJoshuaCondon3 DeGraziaKellyCoates3 DeGraziaLandonClark3 ,DeGraziaMichaelCheek5 DeGraziaJoeyCarpenterK DeGraziaC.J.Caron3 DeGraziaVictoriaCampa3 DeGraziaNicolasBonneau2  DeGraziaJacksonBirge1 ,DeGraziaMatthewBaker4 9DeGraziaMattArriaga6 ,DeGraziaGarrettAndreatta6 CRS ElementaryJawanPhanthavong1$#,CRS ElementaryLuisaDaniel4CRS ElementaryLouieDaniel2,CrossKalebThompson9 CrossSteveSchrieber9 tCrossRyanProvince7 CrossKyleProvince9 ,CrossJaredMcBryde8 ,CrossChetFuller9 ,CrossPatrickFry9 oCrossCoryChristopherson9 jCrossBrianBishop9 ,CoyoteBenDavis4 UCottonwoodNickMercurio-Sakwa4"!,Coronado K-8KamuelaVanarsdalen6$#,Coronado K-8RandallRosemorͬ7)O|DetailmLast_NameLast Named Last_Name_LabelLast Name LabelmFirst_NameFirst Named First_Name_LabelFirst Name LabeloGraded Grade_LabelGrade Labelm Ratingd Rating_LabelRating Labelo Teamd Team_LabelTeam Labelo Schoold School_LabelSchool LabeloBoardd Board_LabelBoard LabeloSectiond Section_LabelSection LabelIDh DeletePlayerLVAL ni_VBA_MODULEoXd}ܱ=ipQ7)O|}ܱ=ipQx^;9b}ܱ=ipQ}ܱ=ipQW9VV+Q 48<@DzHpLvPTX~\D @[LS S(Lt>LLLLL "" A+# p2=m & " &'#VaB,=@F9(1,#E, ";"In+ p > 0 a4= Chr$(10)Are #k Jd"D&=_ ain.(s !" (E'EH8a:) A 'GTIf4Do Whi@B0 .Iaplx= [(@Left$(E, - 1)9aSet !a5urrentDb(@).OpenF("sct * from .where" 4~@W!Lp=a!R熃Sˆ.Cl%at s _ 1'W 3a CountF2 OA+![]q#8 *peq?i-Q p(one63Yw@ith a \of)5 3JHid;(@C<)ßGGLoop Ƿ=Bee8]Cx(|* A Iy ou suth`?new>\ diff.cK?n/, vbQues"+YesNo DefaultButto n2y?") <>TG  ~Ev:=  Me.Undo o.2FocusWEnd H'Y FuLncnBypI Rly, fw)-CiG'"D2`IsNull(q) Or t `5/E [A's cAwe have` some$lik7O'Mal8ley 2Re1$ce(@!'"A'w XOaNUC[[rN.K'?LVAL y2'z/@ [`#!@@SQ .?Ren"MovewpNotyyr.EOF"=q&R![} ;daQNexĮaG)" xWS $(hq#' 4l occ!"ces `Ws (search)r (target) Zr (r_"@6$6t6sυOsl`;s 8r= Len(s #sp !p 6pqAtCp ы`)r0MQeB+ TAGpVq, s= LY__SRP_2rU ,y8A i J811 I9 @Q:= ,i y'8 1 Y I&(!90?:A; y9> < a0a( (y<y(( 6@4QI@8Q3@<IQ97@ @a@DQ7@HIQq7zzz@L9ppp@PIQQ7vvv@T1@XQ7@\Q7~~~c?0 0LVAL z  t(:,%< < $(a@:D%T T $@W1:%  $a:%  $W1')T@<(6\f@:D%T T $(:,%< < $Q(o%Q@o%>1x)T<6 lx?u@:D%T T $@a:,(:%< < $(a`1l)T@<(6lxp^k^lxVl # *#ll*#| #x*#t *#p #l*#h #d*1X2|xtplhdl # *#ll*#| #x*#t *#p #l*#h #d*1X2|xtplhd k^&k^lx 1># qt/[@'%'%'%*#lt#*#|T"$ T Q@p2|T6:D%p $`1h5:D%p $"qd5 p [@'%'%'%*#ld#*#|T"$ T Q@p2|T6`p pl`C5:,:D%p $:`1`6KC` p HlX*#l`*#*#|lh*#x*#t #p*1X2 |xtp'k^lx  1x5lxp^lX #*1X/T"$ `T $T\'':D!N lX"*#ll*##*F^ 26T"$ `T (T  `.@:D%T T $@$)T@< $X`xlhpl|xtplhdT@<(  l\,CTl %\ %@ 1,!$:4&%:D'%\$\!$:4&%:D'%l$l'%'%'%(*F$l:D):4*\:'`#"$  QX/6$X pl X X 4k6lTF4$LVALnI#m@d7mE$oM+tL'~]7xWhitmoreCurtisLurvey6 KWhitmoreGabrielHughes6 ,WhitmoreJamesGregory7 0WhitmoreKatieDenny5 ,WhitmorePatrickCrandall4 8WhitmoreSreekarBommireddy1 uWhitmoreCharlesAwalt6 WhitmoreWilliamAdkins1 ,WheelerCourtneySmith7 ,Ventana VistaAlexYueh7CVentana VistaJackWolf51Ventana VistaEmmaWing2,Ventana VistaDannyValley7,Ventana VistaCamilleSwerger4! Ventana VistaRobinShim5,Ventana VistaJuliaShim4,Ventana VistaDianaShim6Ventana VistaBazzilRamadan2 ,Ventana VistaAustinPudwill6 ,Ventana VistaMaryMoon63Ventana VistaJihoMoon4,Ventana VistaYoung WooLim4Ventana VistaLincolnKoester2! ,Ventana VistaKaraKim73Ventana VistaHarryKim4\Ventana VistaColinKelly6Ventana VistaBryanHu4,Ventana VistaGregoryHathorn5! <Ventana VistaTaylorGramlich7! ,Ventana VistaEmm:D+%X $$:`1T6$ X ) X  lT1,(4 lTX\< $4 l\,L< \4UpH L4UpFl\4UpJ kJSkJl0 F4L ' kJkHl  Fl2064 kJkFl\4UpJM l0<80 L\l(04  @TC__SRP_3rU h$` ()`&0i` 08`/pLVAL |0=Babce ghijk 2(((Players.Grade)="4") AND ((Players.Rating)<300))Lookup_School.School@PlayersPlayers[Event Procedure]Arial8 hTNEC Silentwriter LC 890g od,,` &hO[&XdCustom page 1BBCustom page 2BBCustom page 3BBl)WINSPOOLNEC Silentwriter LC 890LPT1:d2e12f5g237hgh MS Sans Serifi1ghj1ghk1l23:m4n2o2p5r35zij MS Sans Serif{5`Detail m7U`da bek Last Name Last Name Last_Named5U`ha bcLast Name Label Last NameLast_Name_Labelm7U`dabe First Name First Name First_Named5U`habcFirst Name Label First NameFirst_Name_Labelo05UcddtehnGradeGrade Value List#"K";"1";"2";"3";"4";"5";"6";"7";"8"d5U`hatbc Grade LabelGrade Grade_Labelm7U`dabekRatingRatingd5U`habc Rating LabelRating Rating_Labelo5U`cddDe hn"";"";"";"";"10";"0"TeamTeam Table/QueryWSELECT ID, School & " " & TeamCode AS Team FROM TeamList ORDER BY School, TeamCode; 0;2880LVAL }d5U`haDbc Team LabelTeam Team_Labelo5U`cdde hn"";"";"";"";"10";"30"SchoolSchool Table/QuerySchools0;2160d5U`habc School LabelSchool School_Labelo05Ucdd edh nBoardBoard Value List 1;2;3;4;5d5U`ha bc Board LabelBoard Board_Labelo5U`cdd| eh n"";"";"";"";"10";"10"SectionSection Table/Query Select ID, Section from Sections0;1440L"Select ID, Section from Sections";"Sections";"";"ID";"Section";"PrimaryKey"d5U`ha| bc Section LabelSection Section_Labelh1U`,a| b@c@i DeletePlayer Command16[Event Procedure]H( Ȥ LVALzX6qK+ d@v Delete RecordoLVAL{j @@@@ @@fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vjof|brmxopvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdTeams Players  G G  PlayersCalc New Grades!@." Players.Grade[Calc New Grades].[NewGrade]A wCalc New Grades Players  G G  2@ 'Players.Rating300) wPlayers  G G  /. Ratinͬ)O|Detaild Tournament_LabelmTournamenth CopyTableh CancelLVAL i_VBA_MODULEALȒw Fh x6hH4 l$  ( xDhH4@DS__SRP_3rU P$` $)` pLVAL0=BabcHe gh ij"k! &\5@Ariald2hgh MS Sans Serifm45`DDetailm7W`aXb e Tournamentd5]`ahb@cTournament_LabelNew Tournament Results for:h1U`P abtc,i CopyTableCreate[Event Procedure]h1U`abtc,iCancelCancel[Event Procedure]LVALͬ ʬ)O|Detaild Tournament_LabeleBox12eProgressLined ProgressPercenth CloseFormh CreateResultsd ResultsTable_LabeloCrosstablemTournamentLVAL i_VBA_MODULEd6_mkʬ)O|5_mkxJq<5_mk6_mkqBB <z@xDrH|L~PtTXp\ ` h@[LS S(LtN0{0629ACCA-4FD5-11D2-A37C-00A0C9DC1E0E}7 $*\Rffff*2937dfe7e1*\R2*#2d*\R0*#11*\R0*#16*\R1*#a*\R1*#50*\R1*#52*\R0*#10*\R1*#1c*\R1*#58*\R2*#25*\R2*#27*\R2*#1b*\R2*#26*\R2*#28*\R1*#8e*\R1*#8f*\R1*#2f*\R1*#31*\R0*#c*\R0*#d*\R1*#2e*\R1*#85 ;k($D@`JTk(  $  $  $ $0$ $$p  $ $ ( $X $LVAL  $  $ $ H@$p$ $$$ 0$`$$$$($($$$$$0`$ $$ $`z `Ft $e $!Poi$Hh$x$$$$$$$`l`h <$PH$H$`xH$H$`t`B0 H$($($($ 0($($h0 ($($($8  LVAL ($($($`ph`x( 0 p ($($($8$($($( 08$i 8$PXx b44@ P X H ` 8$8$8$0 ($` ($ ($  8$8$0 8$`8 @    `pLHk H  8$8$8$`t `x  8 @H8$8$8$(8$X8$8$8$8$8$H8$xLVAL 8$8$8$8$88$h8$8$8$ `j4kL P88$h8$8$8$8$(8$(`8$8$8$$$$$$@$p$( 0`Tk055,$$$`|H,++D0`Rhk$p$$H$H$H$XH$H$H$`$x5`Xk4a@$LVAL p$$$$d$$$H $d$`*`$`&hpH$ p[(( $x0`hb|kp@//i\ iF!`xH$H$`tH$ $`p `xH$`pH$ $H$ `t`p`xX`t@`p`xH$H$ x`t`Pp`x`t`p`x`t`p`x`t`(p`x`t`pp`x`t`p`x`t` p`x@`t`H pH$H$`x`t` p`x`t` p !`x`t`H!p`x`t`!pi^!i$h#xLVAL `PpH$H$`$x`\`$x`$x`$xHPpi pH$`t`#p`x`t`#p`x`t` $p`x`t`h$p`x`t`$p`x`t`$p`x`t`@%p`x`t`%p`x`t`%p`x`t`&p`x`t``&p`x`t`&p`x`t`&p`x`t`8'p`x`t`'p`$x`x`t`'p`x`t`((p`x`t`p(p`x`t`(p`x`t`)p`x`t`H)p`x`t`)pxLVAL `ZlX*x+H$H$`$x`$x`$x`$x`$x`$x t `$x"`$x`$x`$x`$x`b^`$!x"`$!x`$!x`$!x`$!xH$H$`$!x`$!x`$!x`$!x`$!x`$!x`nH$H$`nxH$( 0/H$`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!x`$!xi 0 /`z$ (h"p" # $x `ih+/ Di0iB/0hi  @Dx0( x00**,,@-LVAL H-h--Dx0( x00x/H0x3$3\$\$\$\$\$3$(4$X4$P4d$ 5h`xXd$d$`td$\$`05p D`@]k= 8OOt(6|$|$|$\$\$3`x\$\$`t\$\$`6p\$\$`l66\$\$`l(5 \$\$`x(`x`t|$|$`7pH56 63`t |$|$`8pP56336 Dx0( 500LVAL 06P:86( 8 |$@6 |$|$|$|$`nxX;;`pt `x`x;`tB!`h;p`pxH6X7`77`t`nx`pt`p7 $`$!xI (=( I H=0I, h=If< =IL =8``<p`l`i  (8`$!x  $`$!x`$!x#8@l @\ @>L ?([t@f:< H?@[t@, `x8BX[t`x`t@`p?p`x`t `?p `x`t`@p`x`t`H@pDx0( 5008:`t`Ap `l@l @\ @xAL @f:< @, : LVAL B`x `nx`Bp[t`ptC[t`p`t`BpE`$!x`x`t`Bp@`x`t`8Cp`x`t`Cp`x(`tF[tB`$!x`$!x`$!x`$!x `Cp`x`tj0```fSSS`$!xd` S@x `B`$!x @h R`8U0UxUHUhVPVhX@l @\ @TL @fT< @, "d@`Ud @UT @UP @U@ @W0 @U @8V @8X @V @ V @ X @ @ (@ a `x`t`Vp`l@l @\ @WL @fxV< @, c`x`t`Wp`l@W @X @ @ @PX @ U  Z8Y(ZZ Y"d*`(Z@XZx @l @\ `nx `pt `p @hYLLVAL @f8Y< @, @Zh @@ZX @pZH @D @[4 "@$ @  `nx`pt[`jpF`$!x@ H\ Z@l @\ @X[L @f([< xj F`p @, @\ j`d @^  @@\ @p\ `$!x @\ @\ @\ _xF\@] @_ @@^ \] ](]0]@[[[\(^(\[`^^([[>`nx`pt`p@^ @X^x @p^h @`X _@T @P @`L @^H @x_D ``nx`pt`pI`$!x[@_@ @_< @_8 @_( @P`$ @ ` @8` @ "@h` @ @ @ 0hbhW`$!x@ xa(-aEaEabPbxaapFHj  `nx `pt `LVAL p b@ bd @T @8bP @L @< +h#cRh+8*"RPcc8cce0ehW`$!x^`@cL @hcH @eD @c@ @c0 @d, @c @d @(d @@d @Xd @pd @He @d @d @d @d @ex @t @p @l  cd @@`e\ @xeL @e< @e, @e @e @f @ f @8f @Pf @hf @f @f (@f @f| @fl @f\ @gL @(g< @@g, (@Xg @pg @g @g @g @g @g @h g@h @@h @Xh| V@phl @h\ @hL @h< @h, @h @i @i @0i @Hi @`i @xi @i @ @i @|LVAL 0`j0`/jxj`jZH @x @h k`kxkHk"*`@x @kh @d @kT @kD @4 d ( ( I8IhP$GME? @ " " 6 `.0  " ;;;; 4"  B F &pL @  "P<  8; 8< "x;; <@<H<   "x<  3 (TPx  " 6( x  "X. (| (6 86  H6 8  2`3  0( L[6 6  <}7 <}@7 <}7 <}7 <}8  6 "   P LVAL .x  #h.   "`h  #56[@ "5 , 82 8 <  B4%p 02 (`'    0!!H!!h! !.!. X*h*  ,    P .@@  4H 44X 34  0 @/  x* . H$ @   0  8`c#  0& $8& @,`& @.& & &"& H7'H' P'  " 8h' &" 2@)"  "(" ''' ' '' x  (" ( LX-B !@-H-P-  ! 0- - -4A--- - ! "4 p 8 )8  *! ((@(  X( 8.8() f) 2((.2( 0!8"@" 2X2 (L[@8 X6 8 h6 89 LVAL   0 B p(+ *** * *0+,*4-`,+&&8,+ + " (?  >(  "  /   < `<xp0l`lP !ults r') Me.RecordSource = "Results - 97 RQ 2"ZZZ B@( B@b().Ex B@SERT I B@ ! !_ !b Z "2 "2 bQ 2] "2 "2 bM([Ra "2'' "2'FR\@  " '!GROU "2  B@te;'get a small recordsetGROU "2'\'h B@( 2{Set rst = dbs.OpenRecordset("SELECT Title, " & "Count([Title]) AS Tally " & "FROM Employees GROUP BY Title;");   Show old and new data.et!SELECT * FROM Players WHERE ID = $%v.ntX Old data:   X New data: 6 6 Update Player p's record B@eck A ( Restore original data because this is a)  demonstration.suC@ : : C@n B@ck; C@$scan thru next player in the b-tableCurren  " 't("SEL\\ $scan thru next player in the w-table2].[Bl "2' AS \p  " 'M [Res B@ 2] " "2' ! "2 ck;" ! "2 {|\  " 'oin B@ ! "2  R "2'h\  " '7 R B@LVAL ! "2 in  " ' b-tab B@ B@ B@'scan b-table only   scan w-tabley "2'sc B@ ' B@ "2' "2'k  " 'p B@ ! "2 k h( the same record current.Z  " ' B@ ! "2  ! "2 Z "' ' B@ "2' " " ' :fh   scan b-table6Now we have the total point change, pts, for player p.C@59.WHERE criteria;4 Make changes to record and set the bookmark to keep " & !nUPDATE Players SET rating =  WHERE ID =  $B@ B@  " '97 RQ B@S Play$Determine the next player and pointsAS Poi  " 'lts 97 "' ' B@ RQ 2] "' ' B@ B@"GROUP "'")ayZ'P Z "f  ' "3 F,'g   F 'g "f 0 l  )BY [%Determine the potential rating changeP.Find the Player's record and update the rating"f  ZSELECT [Results 97 RQ 2].White AS Player, SUM([Results 97 RQ 2].[White Points]) AS Points FROM [Results 97 RQ 2] !GROUP BY [Results 97 RQ 2].White !ORDER BY [Results 97 RQ 2].White;$%v.  ZSELECT [Results 97 RQ 2].Black AS Player, SUM([Results 97 RQ 2].[Black Points]) AS Points FROM [Results 97 RQ 2] !GROUP BY [Results 97 RQ 2].Black !ORDER BY [Results 97 RQ 2].Black;$%v. ZZZZZZZZ   5SELECT White AS Player, SUM([White Points]) AS Points FROM   GROUP LVAL BY White  ORDER BY White;$%v.& " GRa w!Player = b!Player" ORZl d Fd'g'' B@   5SELECT Black AS Player, SUM([Black Points]) AS Points FROM   GROUP BY Black  ORDER BY Black;$%v. [Resu "(l0A@' R  d "(A@ B@ ! !_$Determine the next player and points ! "2' "' B@ !b "2' "' B@ "2 "2 b "2' "' B@ "2 "2 b "2' "' B@Z "2' " " ' B@ B@h.Find the Player's record and update the rating!SELECT * FROM Players WHERE ID = $%v. B@' "3 F,'g "f  '   F 'g4 Make changes to record and set the bookmark to keep the same record current. "f  C@ :fC@59.nphh` B@B B@B B@BZZlFor Each ctl In Me.Controls MsgBox ctl.NameNext0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do.b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results  insert the table into the listZ If p > 1A@H h  F "d(| F F;~ $  )dZ( F $%.! $ ;'FlA@Xp'LVAL 0 Me.RecordSource = "Results " & Me!Tournament  F'g [Results "d]'dA@e Sub !'ss(b  'SU  ! 'AS Poi  '  'UP  '  'e;d  A@7  F'g "!' B@ B@( "B@B%u $ X$ % ( *!,A@`"l "dB@ "B@lZZh 'dl(l F dah $!.!: < The following test is a poor check, but for now it will do. F F;~ $  )A@ $%.! $%.!$ xTable A@Results 'h 'Fh  F "(| "B@ $%.! B@,dA@h Then the name wouldn't matter.ro ! #There are no records in this table .A@`P ! -Get a list of the Crosstables in the database INSERT INTO [Posted Results] ([Results Table]) VALUES (Results  "d);$B@B@H8p *!,A@`X:Puu88 ! B@BeRatinZ B@B  insert it into the list $%.!$%v.( !d$duhThere is nothing to do!A@`x@ A better test is to make sure the table has the required fields confirm rating B@Beach c= if player is ambiguous, prompt with list, allow new... InsertResult(pidd schoZ8 B@rye sc get the player's namepr1 find it in Players and resolve it to an ID2 use school and school code if necessary" LVAL pid = SelectPlayer(LAST, FIRST) !_. B@ Z`ZhxTable "$%v.d  A@Z0lAdding Player:   A@`  5 B@ !' A@ 0seZ+h PB@B'blt if WhiteResult =TablWLDF $~'b'BResults d Results Template "B@A@Z d d( d(u`X *!,A@`@l8&How to test whether successful or not? !gbox pZZ"f B@B B@HQAdd a new player?Zh+k <!PeHQJQ!Check school to resolve ambiguity "' * f "'  Nameanalyze the result codee $$ $^'& PB@B*%HQ '''$j'ct * f '''$j'st Nam* In case we have something like "O'Malley"Df p't "$dF  "6 "f "A@g   ' S B@B_Schoouh sch.MoveFirst7select * from Schools where [School Code] = school_code !_ B SelectPlayer = UserPicksPlayer()a " B'B select * from Schools where [School Code] = ' '$%v.< <!'Bk8HQPerfectJQShould be impossibleNo such school? Add a new one?for 'B <B@A@` <B@ <"'B <B@BHQPerfectAd'B0Error: Can't find school code in Schools table: A@`'B0Error: multiple Schools entries for school code .A@`HQ9Perfect! (Hmm. What if new player from different school?)No such school? Add a new one?0Error: Can't find school codeLVAL in Schools table: A@` <"'BJQShould be impossible0Error: multiple Schools entries for school code .A@`k <B@BHQ No such school? Add a new one?0Error: Can't find school code in Schools table: A@`HQPerfect <B@ <"'BJQShould be impossible0Error: multiple Schools entries for school code .A@`k` <B@BZ 1what to do? Can't use school to resolve ambiguity "'qh B@h  "6 "f "A@" Avoid recording same result twice  _tnm & F FugyVal r $$ '$x0 if result == "W"+There should be exactly one record selectedhool C P!' Z `Can't find crosstable record &A@`elZ8* bF'bg, count forfeits as losses elseif result == "L" ) select * from [xTable "] where [TNMT_ID] =  &$%v.PCan't find Player:   A@`st & "Can't find Player:   A@`lt, $' P $' B@A@`    '  F'g  F'g BHQ White wonHQ White lost [2 return if(wr > br, 16 - delta, 16 + delta)4 return if(wr > br, -16 - delta, -16 + delta) elseif result == "D" \) return if(wr > br, -delta, delta)h Z`/kf HQ They drew   F  '`F  'g   F '`F 'g   F  '`F  'g & " select * from Players where [Last Name] = ' ' And  [First Name] = ' '$%v. 'xe FuncZ(-ZEZEE Replace alLVAL l occurrences of s (search) in t (target) with r (replace) n'j n p~'  _  x n p~' n  $   n  t $ 'n, bFugzP/ "B@ "B@0 "'* *$j' *$j' 9How to pop up a window to let the user choose the school? "$dF  "6 "f "A@gMT_I   select * from Players where [Last Name] = ' ' And  [First Name] = ' '$%v.8.p3 "$dF  "6 "f "A@g "$dF  "6 "f "A@g "$dF  "6 "f "A@g3ZZZ ! Enumerate Containers collection. 52XProperties of ! container ( Enumerate Properties collection of each  Container object.  !X ! =    C@Bnp2$.`222 How to set new Results table Hidden property OFF? 5 P" P" P" P"f P"$'Z "4sPrivate Function SelectPlayer( ByVal last As String, ByVal first As String, ByVal school_code As String, ByVal rating As Integer, ByVal grade As String) " " " "f "$' `58(   & INSERT INTO [Players] ( [Last Name], [First Name], [Grade], [Rating] ) VALUES (' ', ' ', ' ',  f);$B@@7ah $d    INSERT INTO [Players] ( [Last Name], [First Name], [RatinLVAL g] ) VALUES (' ', ' ',  f);$B@5 "B@ "B@h7 B@Ber$ZR B@ B@B B@ !' B@ B@le B@B%A@ B@ !' B@ select * from Players where ID =  $%v. "$dF  "6 "f "A@g. "$dF  "6 "f "A@g ) "$dF  "6 "f "A@gsele "$dF  "6 "f "A@g5 "$dF  "6 "f "A@g select * from Players where ID =  Z$%v.ZRZR "f'"6 ^  b$' "$dF  "6 "f "A@g "$dF  "6 "f "A@g "$dF  "6 "f "A@g "$dF  "6 "f "A@gH         $ ( , 0 4 8 <  INSERT INTO [Results d] ( Round, Result, White, [White Rating], [White Points], Black,  [Black Rating], [Black Points] ) VALUES ( ,  b,  \,  ^,  ,  Z,  ,  );$B@lyr_ID3 $!.!: ZM 2 ...if the results table hasn't already been builtZMZNZN $%.! Don't add this one... ' ' r $%.!$ '  F F ;'FgH:.Attribute VB_Name = "Form_z CreaResults Table fromdosst<" Bas0{0629ACCA-4FD5-11D2-A37C-00A0C9DC1E0E} |rg= True ]PredecdlaId"E xLVAL poseFals @TemplADeriv%CustomizD$Option Comp@ Da3v   7 AXLeft$, 7)("x' "a# 3e'@0sert in`!45g!AA+F= Mid>8DsJť" & ' ...iJ`⭆2!,DS 9@builIW= $ !Qj?Qt &Q9s9jc9 Vl3e '`kEadd M`Y m+#eKCeEx^'AIfNepxt jk`NXot  a= ;="; م iEkRowSc !gcheh) .#g!, In(1,!, )A9HUߧS% [vgjр-_Cnk[x*ASRecordse)!\pl dyrLoI\/ `nrecs3 BlankRAcSDoCmd.Hglas„j " =jYOpen (F&1sT.MoveLas =.^ &Fir5rvw! Do Whiq)EOFs pl`= SelectPlay(er(Q!t,!fSchcmRateGrade(#7`)b> -)Pbs * c s\_G1& "wheiIDTx AplxQP !IsNull3RD1)c3b$ DTNMT_ID,0!=,ez1!RtD2t, 2? H; 3? b3, 3=44, 455, 5!|Cl`WNQ7r + 7100*r /G"8q?]cLoopOsBX S] kmHpXPm_4N3W:sGMpSub!GErrOckD_cknV{cW`On ШG~oOZRI CWharnPHsC@opyObjM 7@mPC&, ac`dy'HpG`rccful µt?# ' n new % ӚHiddpropy OFFd)@MsgBoxQ.DescriB?"9e Function SelectPlayer( _ ByVal last", HfirLschool_code ZRating (Grade)g 'Privat' As StrW#rWInteger=\g\aDi@m plyrRecordset/r ? SIDLong a = 0 ' In case we have someth like "O'Malley"= Replace(, "'"'"2|E  [*AKTrim'K$#A\CSet]= CurrentDb().OpDena("LVAL s * from s where"& " [L Name]B0'" &€"'p AndDF FAŋ C\ /-Y Cq.C+Coun0'Add a nlew 'Check to@ resol0tambiguityyxq}/gRmS/g % [# CodgAzSdpdA1'No such e8oneXeeError:jn't0enda iptableg #'Howpop up@mwin d#l|the user !se~  ! %`" >= ")#Should be impossi0|multip$leTs ries forO V.ac61 /FG| 0{ 'w7.do?t@0y0A'>UPicksS(h:Ca#o] q?!3DoDiNo.EOFbAS@B5NyExit DoEnd bM)Nex$%Loop S &!X@օ @P occc(of s (search)anx) Dim opllRecordset p_ID 1_tnm  xtabr cB8l88Cs 7a5"8 4IDA.Move.F!j$e= l!{C l(BW$= Calc(h"d , "cX@Execut!UINSERT IN0TLVAL O [ca& Tourn d *]V(RMd,_SsS[b &]zc#tBlackrp| cd  )rVALUESC" $rb *0``0 >`PuBv vj U-l);"c-SEA3p0 Tf Priva*Func0tion03wrr, CbOlEodelt>av !jt(Abs(- br) / 10$6gc 15Si15WgeCasu 1`k" wons1  > S'B!pO16 -El@+XqS`]oy`-uJ 3 `my drew }# rC#eQ#C% & Upd%ProgЊs(#S"0p 0TpP 10p f@Line.`WidthEMaxL`* p$CTPercp.Cap/pTrim$(Str$((p));%$5Me`~pa33zForm_Cli(ck(+OPrror GoTo ErroseG1DoCmd8::XkTd.DriBP08__SRP_3,"rU X [A i X$ A  X i 1 1 $ yY %!&I&IXiYa&&&'9'Y'!"Y a0a(1KPy' (+y(iQ1Q0)RqRSa0 T9R((q))*2 ,i,,-1-y-.A2q21.9//+ 00 X#XX@<IQy@@zzz@Dxxx@ Harrr@L|||@ Pa~~~q@TQ#tttLVAL @X1@\9ppp B???\$x!  Qxoh%!  5h$$ xh|6d:h%x x $dWTB4)xd5T H,.d:h%x x $d)xd(|$ xdTpAzjlp" $ p Dl kj)plcfo,0kzD4%DH" $ H DD 00 8LPkzDT%lp" $ p Dl 0P 8lLJl, #(22L,() plPHD0cqLPkzDT%lp" $ p Dl 0P 8lt'lL  #,*#(*1t2L,()plP5 zdfC3ltF4%l:T%p p $l)plltJ Tltlt F%l:T%p p $l,)pl5$ dad( t4 L,(plPHD04"cT%d" $ `d Pd|'%'%'%:0P:T%d d $Pa@ `#" $  Qx/)dP6 @ x hx plqh x  ql Hx 4k@:T%x $ :0%x $:%x $:%x $:%x $ @8"qp6 @ lpr[P'%' %'@% *#lp#*#d" $ d QPt2d6@  t "@:T"%x $@ !5@t[@:T#%x $ :0%t $:"%x $`# U@"lp@/6@ "@:T$%x $@ !5@[@:T#%x $ :0%t $:$%x $LVAL `# U@"lp@/6@ "@:T%%x $@ !5@n[@:T#%x $ :0%t $:%%x $`# U@"lp@/6@ "@:T&%x $@ !5@[@:T#%x $ :0%t $:&%x $`# U@"lp@/6@ "@:T'%x $@ !5@h[@:T#%x $ :0%t $:'%x $`# U@"lp@/6@  t llqldlllhH x  dH x .P:T(%d d $P)dP#fT%d" $ `d Pd , tx@ dP@ <K#fh%x" $ `x x[Xx!  x L):$*%:h+XH%'4%D" $ `D 0)xD6X4H"ch%x" $ `x x<''4'H ,xx ,.> FX -x6XH4 l$ ( xDXH4$% l\,L<*#@?*#<;*#80*Fl:@:0\:@*#<?*#8;*#$0*Fl:@:0\:@:(0x,h:@X<:A`#" $  \2 HD@<8$6xhX ( T'X%'h%'x%45*Fl:6:7\:0`# " $  QT(/ 6LVAL xhX ( :C%( $b\qlLR ( :C%( $b\qlLq q cT'%'%'%DE*FL:0`# " $  QT$/ 6 P$ plPql,''':FL -6lV $ :C%$ $"q 5l7''':GL:H -6  $ l @''':I\:9l -6 o ( ( 4ko(:%( $l i]15\^:C%( $b\o (  ( X@ q(l(L\$,<d HD@<8$TxhX  xtp ltJpl lpJpjlxltpn knAknlx #dlp*#P'Tknkllx  #L*1x2dPL5TknkjlxltpnE lxF<0@0 ptxdPLTHpx*'Llx  1D>D#H Jqh/H5L lhlAlx 1xKlxp^ k^y k^p^t'x%'%'%:L,:0%@ @ $,aL :M:Nlhi`#H" $  Qtp/H)@,6L xpp plp2''' Olh#H*FL -/H6L p L:0%p $ :%p $:%p $:%p $:%p $ L8"ql6 L lla[,'%' %'L% *#Hll#D*#l@" $ @ Q,t2HDl@6L t L:0%t $LUpf5L t Lk^kfkDLUp\5L'|%:0PL@!  @ L)L :Q:;:R:S:\T:LUx:lL, |L x, lL,  p p4 a`xtp&HDl@,tL x, lL, lL, |$k k pz kz.pz kz@pzkpx kx k kpkzDhb~kzDhb kx k kkzDhbkzDhb kx k k kzDhb kzDhb@$  k ddp k &p ?4k dkT%d:h%x x $d)xd> Mh@ #P #L *#Hx!  x P 2PLHx  4$ & PLHxdK9/'h%x" $ `x ,x5h<'4'D'Td ,xx ,.>dFh -x6hTD4 6LH$ y $dxhTD4TXH  P __SRP_2rU h$`$$)`( $i`,$`0 $`4@)`8Aq/8i`</<`@1Iq8`D/() `H!$i `L p}LVAL0=Babc8e ghij@)kN@Arial[Event Procedure]d2e12hgh MS Sans Serifm45o2w2` Detailh1U`abc CreateResultsCreate Results Table[Event Procedure]o05Ubcpde` n Crosstable Value List1440[Event Procedure]d5U`aXb|chd Tournament_Label Crosstable:e15]`a b chBox12e125`(a b@ c ProgressLined457`(a b@ ceProgressPercent0%h1U`a0 bi CloseForm Close Form[Event Procedure]m7U`pa8b` k Tournamentd5U`abdc,d ResultsTable_Label Tournament: @@@@   @ fpwfuufvxmwvsm`}fuvvbirrmvxsd`wfsm`}fuu`wjphv~buf`wfpf{wrxup`ofpwufvxmwvw`amf~buf`wfufvxmwvw`amfguroburvvw`amf~rmdfpwfuufvxmwvgruoxwjmjw}sxamjviu`wjphv`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`ddprvbirrmsm`}fuv`mmufvxmwv`mmvw`ujpgr`mmvw`ud`w``ssfpd`mmvw`ud`w`o`lfb`mbpf{hu`dfvbuf`wfu`wjphvmjvww`amfjosruwov}v`bfvov}vjof|brmxopvov}vjof|vsfbvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvpf{Zwihu`dfu`wjphv`gwfubi`phfhu`dfvpf{vbirrm}f`ubi`phfhu`dfv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKuE*Ć($_AV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  wnyDraw1/2 - 1/2 Black won 0 - 1White won 1 - 0LVAL i_VBA_MODULENxBv (6 <,<<< <<<<< <$<0<4<8<<<.9"*\Rffff*23da99ecbP@ X`l@ &&te`ham#`D@#`tayer`rWrX $XH$@@l  @x88`Px#X@l h @f (d/ (((T D -X ME: B   *)0LVAL  #` (.p$. ()(lI *)X(pI :)(fI8 $)0hP  <0 &p.   00 `  "0 )@ P BX`h 'p 0   (    xpZ@$'Creating new Ratings List "B@4 "B@Create Ratings List Table "B@Add No-School Players "B@"2Writing flat-ASCII file "B@4   Ratings flat-ASCIISACA Scholastic Ratings  Ratings.txt "B@limiWriting tab-delimited file "B@4    Ratings Tab DelimitedSACA Scholastic Ratings  Ratings.tab "B@)Writing CSV (Comma Separated Values) file "B@4    Ratings CSVSACA Scholastic Ratings  Ratings.csv "B@Writing DBF III file "B@4     dBase III  SACA Scholastic Ratings Ratings.dbf "B@ "B@ "B@4f(XZZ$!'  :\ $ ~ $ 'sh Default Database Directory$'fXP) DoCmd.Echo False, "Writing HTML file"  DoCmd.OutputTo acOutputQuery,' "SACA Scholastic Ratings",' acFormatHTML,' Folder & "Ratings.html", False`  RATINGS.DBF  Ratings.dbf5DoCmd.TransferDatabase forces filenames uppercase, sorename the file for consistency]LVALi`Attribute VB_Name = "Utility" Option Compare Da@tabase`Explicit @ Pub 0Funchsh_Ratings () Dim Folder As S~ng>= Out8put8:oCmd.Echo False, "Cre^ new i ListQD2SetWaH:(9 DHDME W " U UU " 80W@0 WW 6H0"A0 B0 h0 LX1 $1,RU0q1U 2 2 W@HpV V  XV  W W NX V32(TV VhV X2 "  ? dT 8I A xJ PS AhB "  (H dT (I J  J HJ hJ@J "W PW " // " N33 " /U000 ", x(1.--X-0.. - ",.#. $)h8 6N7 7  07 @7IP7 `74 )@8 @/ "H/P/7#6#7 &)8 H9 X9 h9Ix9 -9 9LVAL 9 99 )9 / "  4 H8>>J>???? ? H(? #@?#H? P?A@ A'@ @ M O O O O O O O L P P  P 8P HP `P pP P P P P`@h@ p@ @ >R@F@ @ >R@F8A XA  hA((pS  pB B  BB B 4 " H p2 "Wx252W2W22 2 23 33 3 "  F HF G(G0R0G8G@GHGPGXG H`G #xG#G GA0H xA'8H HH P P P Q Q 0Q @Q XQ hQ pQ xQ Q Q Q Q Q Q R R (RhOH H H >RHFH I >R(IFhI I  I((8R  J J  JJ LVAL J  J " 3 (3 "W035X3Wp3W33 3 33 33 3 " `2h2 " p, " `ph " p`   y0(x` gH 3` 7&' 8(' 5  8  3@' 7&' 8(( 4  0 _@ $f?( S  Hipi p  x   "  /  <  " +(+ =0+=P+ p+x+ + `U+ + "U UUYxp0l`lXZlHl80lh " rA@~  "N )Nd= 5_C@* Enumerate the specified Recordset object.X77`nXlP rB@B B@Bating Hello!A@`$ Xh$.  $select rating from Players where id= "$ X | %v.rhelloA@`hlZLVAL hNext` "$.to  $select rating from Players where id= "$ X | %v.r rA@~xamHello!A@`may rB@B as B@Bd ahmouseupA@`m B@B/ B@Blayer k End Ifl B@!Closeh  rA@~iabHello!A@` 2"f' B@Bhl* Find the record that matches the control.[ID] = " !*B@, !*!. (.l !*!. (.[ID] = " 2B@,l* Find the record that matches the control. 2B@B. B@BA@Me.4Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo12](Me.Bookmark = Me.RecordsetClone.Bookmark4Me.RecordsetClone.FindFirst "[ID] = " & Me![Combo12] ",  select * from Players where id= "  %v.ect ra  select * from Players where id= "  %v.2  ElseZ A@lHQlA@ B ahl If WhiteWon Then% r1 = Me.[White Rating Before]% r2 = Me.[Black Rating Before]' delta = 16 + Int(Abs(r1 - r2) / 10)' delta = 16 - Int(Abs(r1 - r2) / 10)A@ "th hig Higher rated player wonatZHQ White won   )( e?HQ They Drew   )on Higher rated player wonRah0 !  ("g Higher rated player wonahk  )@)   ')   )    "$^'     '  )l  & "B@$(u  *!,A@`(X  F'g  F'g  F'gLVAL  F'g  F'g  F'g  F'g  ))   )   )  F'ga  F'g   ')   '  F'g  )  )@ha  ))  )@)  )  )>  )  )  )>kku8 0 u D B pZ !d(l Table/Query v"x"z(t EmployeeList v"x"z(|  (ox Ml uLeague Match 1 )de]; 8l A@X !d' l  ) l*to a single record in the Customers table,0cmboCompanyName combo box control. The combo boxng7is filled by an SQL statement that returns the customered$The CustomerID has a Text data type.Custom.ID (in the bound column) and the company name.typeSELECT * FROM Customers  WHERE CustomerID = ' "!R'''/The next example changes a form's record source -depending on the company name selected in the025PHu80(u u recs.CloseameDim ctl2 MsgBox ctl.Namen Me.ChFor Each ctl In Me.Controls FROM ") " )8 " )X End If "8$d "$dOW  HQNaHQHQ " )e, " )OM " t )BY " t )am " )X "B@Bu *!,A@`lA@l "f (h " ( " ( B@0Get a list of the Results tables in the database  recs.AddNew B@Bcs!Mov " LVAL ) " ) f " ) HQ " ) "f )llA@HQh " ) " )8 %lZ'A@ ll Me!Board = recs!Boardu# Me!BlackPoints = -delta" Me!WhitePoints = deltaMsgBox Me!BoardEnd Sub/Q " )B recs.MoveFirst     "B@ECT *!,A@`ecl " )   )tA@l %4$d " ) " ):: "f ( Me.Section.Properties. Me.Board = recs!Board " ) B@BwlA@X " ) " ) " ) " ) "$d= recsh recs!White = Me!White(8paha     'hX  )a@  )  )h  )a  F'g  F'g  F'g  F'g  )  )     '  F'g  F'g  )     'ah  F'g  )  )h     '  F'g  F'g  )a@     '  F'g  F'g  )  )h     'h     '     '  F'g  F'g  )   a     'h  F'gLVAL  F'g  )  )  )   F'g " " '  F'g  F'g  )  )   )   )   )  )HQ White Lost (Black Won))   )HQ White won   )  ))   )4get a list of all the results tables in the database1Insert all but "Results" into the Tournament list/Provide an option for creating a new TournamentlZh F "d(|Z F $%.!;'Fs " ) insert the table into the list " ): + 5 t tl F F;~ $  )db A better test is to make sure the table has the same structure as the Results (boilerplate) table< The following test is a poor check, but for now it will do.x $!.!: bles il " ) If Me!Sect = 1 Thenlol (!d ((Round = "h (h "8 ) " )8 " )h " )8 " )A@lA@lp recs!Round = Me!Round ReloadEnd Sub Me!WhiteRating = recs!Ratingay$ If Not IsNull(recs!Section) Then $%.!$ Results $%.!  %4 )&ratingm Play %4$d %4 )8 "$^ 'tMe!Whi recs!Black = Me!Black recs.Update recs.Close)# Me!GameResult = recs!Result) Me!Black = recs!Black i Me!Black.RowSource = "SELECT DISTINCTROW " + LVAL "ID, [Last Name] &"", "" & [First Name] as Name, Grade, Rating, Team " + "FROM Players " + "ORDER BY [Last Name], [First Name];" recs!Section = Me!Sect Me!Round = recs!Round Me!Sect = recs!Section$ Me!Board = recs![Team Board] Me!White = recs!White, Me!WhiteRating = recs![White Rating], Me!WhitePoints = recs![White Points], Me!BlackRating = recs![Black Rating], Me!BlackPoints = recs![Black Points]Round = "h (dS( On Error GoTo Err_Store_Result_Click recs![Team Board] = Me!Boardun"3 Set recs = CurrentDb().OpenRecordset("Results") recs!Result = Me!GameResult( recs![White Rating] = Me!WhiteRating( recs![White Points] = Me!WhitePoints( recs![Black Rating] = Me!BlackRating( recs![Black Points] = Me!BlackPoints% recs.Bookmark = recs.LastModifiedExit_Store_Result_Click: Exit SubErr_Store_Result_Click: MsgBox Err.Description" Resume Exit_Store_Result_Click %4 )&rating %4 )8o  %4 )p %4 ) HQ White Lost (Black Won)ecHQ They DrewHQ White won Me!Sect = recs!Section Me!Board = recs!Board %4$d %4 )8 %4 )luHQ White Lost (Black Won)HQ They Drew " "  '" ( tablelh(  (x( "8(Z0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do.b A better test is to make sure the table has the same structure as the Results (boilerplaLVAL te) table $%.! $%.!$ Results  insert the table into the list F $%.! $ ;'Fh'  F "d(| F F;~ $  )dA@XResults "d (Results "d (&l(+0+" +    "B@    "B@*u***l**l+lllA@ % !.'ug  (. enth+ (  (..FilZl+ ( Me.Bookmark = b Me.FilterOn = True l (Dim b !.'`(ll+l+llh++Zl, (l,A@aRound = "h ( Me.FilterOn = Falsed(A@End Sub Dim b As String Me.FilterOn = False b = Me.Bookmark% Me.Filter = "Round = " & Me!Round b = Me.Bookmark% Me.Filter = "Round = " & Me!Round Me.Bookmark = b Me.FilterOn = True  (.b (b = Me "h( "h(ilh+ZP$ 'Z 'Round = "h (il (. (l*(,Z( ( !.' "h "h( A@X (l%l * Me.Bookmark = b Me.FilterOn = True "h "h( "h "h(l)ZZH0Get a list of the Results tables in the database $!.!: < The following test is a poor check, but for now it will do. b A better test is to make sure the table has the same structure as the Results (boilerplate) table $%.! $%.!$ Results iLVAL nsert the table into the list F $%.! $ ;'Fh'  F "d(| F F;~ $  )dA@Xl'A@lp'h' %4 )&rating %4$d %4 )8 %4 )h&A@&u&&&l&& %4 )&rating %4$d %4 )8 %4 )h8&A@(&u &&&l&Results "d (l%h,l%l%l% If rst.NoMatch Then If rst.NoMatch Thenct$ End If "B@,hZ1 Set rst = CurrentDb().OpenRecordset("select")5 Set rst = CurrentDb().OpenRecordset("select") !.'s ! !B@    "B@%u`$X$ *!,A@`@$l8$"0$ !B@    "B@$#u#"# *!,A@`$#l#00*# !B@ "B@,.#u#*# *!,A@`.h#l`# B@  (  '  "B@arh h' DoCmd.FindRecord Whiteh" B@Round = "h ( ( ! B@  "B@ B@ ( h _ "B@,( ( ! B@  "B@ B@Z5 h'! "B@4hronTurning filter off... "B@4on "B@4g fiZZ 'Turning filter on... "B@4ZZh BZ'FBMake sure the selected player hasn't already played in this round. h'ZZ Bha ! 'B (b().Op !"Sel B@ [Resu  "B@rn h _ "B@,LVAL re Whi B@ Roundh "B@4$ If Not Me.NewRecord Then" DoCmd.FindRecord w Loop_ End If White.SetFocus# Do While Round <> r" DoCmd.FindNext& FilterToRound.SetFocus DoCmd.Echo True "B@X Wh "B@< Do'F  !6Fug f "B@<ts Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.; "  B@B "Z  "'L w "'PWhite'R B@B. "'P!Select * from Players where id = $%v.Black'Rh; "Z  "'L B@B!Select * from Players where id = P$%v. "Z  "'N B@BhX: B@V  $ * $ ^ L already played in this round! $ ^ (with  R against  N) $ ^ $ ^ Are you sure  L is the right player? Z \ f Are you sure?$` bh=Z3Z.Z@Zh4Z4Z4Z;Z;  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.(8l B "  "'Pwon'jna= "'PBlack'Rhx=hp= B@B B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X B@ & B@LVAL ^ ! 'Blayed ! 'B $ ^l Me.UndoA@ End IfhxIncomplete recordA@`sure B@V i $d $d   ?l "B@<'F B@Vh0;h(;3l;BMake sure the selected player hasn't already played in this round.ZZZZZZZZ  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v. ! 'B B "  "'PWhite'Rax9 "'PBlack'RhP9hH9 B@B B!Select * from Players where id = $%v. "Z  "'L B@B!Select * from Players where id = P$%v. "Z  "'N B@B "B@X  $ * $ ^ L already played in this round! $ ^ (with  R against  N) $ ^ $ ^ Are you sure  L is the right player? Z \ f Are you sure?$` b "B@<'F B@Vh7h74BMake sure the selected player hasn't already played in this round.Z5Z3ZP4Z3Z4Z(5Z@5ZX5  !6Fug ' h'Select * from [Results "d] where Round =   and (White =   or Black =  )$%v.7 B "  "'PWhite'Rk "'PBlack'Rh05h(5 B@B B!Select * from Players where id = $%v. "Z  "'h B@B!Select * from Players where id = P$%v. "Z  "LVAL 'N B@B "B@X1 MsgBox "Can't insert - Incomplete record"" MsgBox "Incomplete record" Me.Undo Cancel = Truel` DoCmd.CancelEvent End If Cancel = Truee re "B@<'F B@Vh2h2l2Z6k "BjHQ White wonkHQ White wonHQ Black wonHQ They drewlost to 'jlost to 'j won against 'j drew with 'j won against 'jHQ Black wonHQ They drew drew with 'j "BHQ White won won against 'jHQ Black wonlost to 'jHQ They drew drew with 'jk1HQ White wondrew'jh 'kHQ Black wonlost'j'jHQ They drew with Black'nkp0ah0 "'Plost'jn "BHQ White wonwon'j'jHQ Black won with White'nHQ They drew with White'nk/ "BHQ White won won against 'jHQ Black wonlost to 'jHQ They drew drew with 'ja/ "'PBlack'R "BHQ White wonlost to 'jHQ Black won won against 'jHQ They drew drew with 'jkH.h@.drew'j ' "B HQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'ja- "'P with Black'n "BHQ White wonlost'jHQ Black wonwon'jHQ They drewdrew'jk, with White'n "BHQ White wonwon'jHQ Black wonlost'jHQ They drewdrew'jk@,LVAL a8, "'P with Black'n "BHQ White wonlost'jHQ Black wonwon'jHQ They drewdrew'jk+Z@  + 1 $ ^ h already played in this round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b If M DoCmd.CancelEvent  + 1 $ ^ h already played in this round! $ ^ $ ^ ( j n against  N) $ ^ $ ^ Are you sure  h is the right player? Z \ f Are you sure?$` b^ If IsNull(White) Or IsNull(Black) Or WhiteRating = 0 Or BlackRating Or GameResult = 0 Then^ If IsNull(White) Or IsNull(Black) Or WhiteRating = 0 Or BlackRating Or GameResult = 0 Then( MsgBox Err.DescriptionXUlxUpU(9lU B@H:lxU B@`Uh $%.!Results TemplateU 6hVhhl'0 Fh%z Create New Tournament Results Table  "B@`UVa0 F F;~ $  )dA@XV@ 6don't show the formhen exlVlVlVlV'0hV "B@B'0Z@B'0XVZDW'FW F 6 Frg "B@BhWW "B@BhWW "B@B'0 End If If Not AbortForm Then AbortForm = False DoCmd.CloseGThere doesn't appear to be a way to cancel the form on starup... *sigh*@W(Attribute VB_Name = "Form_z Old Enter Re@sults `"D Bash0{6D5FE3C1-6B8D-11D3-A3DLVAL E-00A0C9D@C1E0E} |CreatablCTrue ]Pre declaId"Expose!Fals @TemplateDeriv%Cust0omizD$Option Com2p@ DTv  8 AA@~Left$ , 8)@Q"E "GA7'insertH4in:AlAoK)  <> ?k J& Mid9) &x ";P!ebIfKmNext >ig'" Or[>[hen8 ExESGDoCmd.OpenAm "z e New burnB@U0BX", %acDialo@lABdjnn 8'don't sh7X5`Zm''= C$'d Xdoesappea\o] eway ?cancelB  starup... *siglh*g #EB Me!To.RowSca`,GU[@, In(1, =)!~ġ'Rele=D !Sub( F 4_BeeI_(CCD@ '@/IsNull(White)aBBRatFDG@@? I  MsgBox "W9dq-c`lerecord]ge.Undo?dE=&SEvd%$reUpdiooolo4ooJ'dInGr;{#Un!''0_AfT Q E, p,s"Me.RR!F5h^@T7U0vR`td V P9.vapVxalu;u?6Fil To S:p5Z|MEnh?13?GDis aQ צ iw.w>0U\s8Echo , "TQACfVU$m Onۤ .`"p _Not.j#$b x.SeӧS Finddw3 4u7RE ZP:ͬr?4>r//$ff-?r=/d/te/ / 0S0 1QLoopo0tbq te$t'atJ'M select `y@㋠ldy RvdPrIdp.RS pr"m pcolMop_Qp 'Rg2seu APlay0h1$b++.@Wp4SspuCh.'C< r = OP ("S * from [" & Me!Tournament"]" _  & " where Round =<& r a<(Whit e,p,or Black ()")Already Playerst.RecordC_t > 0(If +Then7MoveF^i 5!p 59opp%pcol_Arwith $"Select Case #re0sult1 'Dwo]35 2 2  lost 3 y drew Q7 ALVAL LEw; ElseKGTB;? MT3 T3 pGTDTdTI9AYIf.C?1[T@SetCurrDb().OpenCset("Z* from prsD|i{pu .pA` A][m N5]b}"La|st+r~dNt![`DoCmd.Beep'@0MsgBox(Chr$(10)/$h&al b pin this r!!'LjF ([ & djb gain@/E ) "A`you s>u th!ightr?!, vbQuestion +AYesNo"Defa@Butt on2, j ?") <>Ĵ- 0CancelEvYSTrufda.Und>oka# Sub Ppriva_AfterUpd (`O#On ErrGoToA>_姀bRa0ting`.Column(2)rB# MNot IsNull#e7))l` S>=cc !@Boarh 6t4CalcPointsSxit:E 0tR sme ?zd_Before As Integer `'Make-q,sW`9r hasn't o:g:.s Dim p XBGStr h; <_p a rWqv_w K0Boolea30')r.OldValue&""rr`Sii|i["ltsҦ`+/!&@///\qP)//u0/˦o/ / 4a = <//e 1G /7 p:/ rB/ B //?(Q/ */l 17@@/ye//3/=7 /O O O O &\h@(R\ GI 0 @}/ E//pS already played in this round!" & Chr$(10) (_ (& "(Zpr esultXpcolor" a@gainstJ& oppname.)'Are you sugD the rightr?"  , vbQuestion + YesNo DefaXButto n2, "5?") <> Then }DoCmd.CancelEvent  = TrueBlack.UndoEnd I>f "Sub PrivPate  )_AfterUpd () On ErrGoTo_ Me!Rating@1B.Column(2) 'r If Not I@sNull( 7))OSec:t 7+ oatrd6KEA CalcPointsBIxit8:+NEL rr R @lb7ߑb )r>vG@.ltEHDim delta As Integerc)!bonus.Ni c# = (Abs(?WhitedO- Af) / cO1< 0L= B0 > 15+158G>"## Sel!XCa= 1<= 41; 0 + LVAL"p (Iss b\G` q_I` @0`ub CloseForm_ClickTP5 ąQ! ;  _p@MsgBoxq.Descripc *@YD`@ZecordoDoMenuItem acqBar,Edit, 8, Ver7]s6! r' *2P_GotF0ocus5$R.Dropdow@ea.2(LVAL 0=Babce gUh`i j$k<[Event Procedure]{1@Arial8 h\\TOPAZ\LASERJETpCLetter !''''\"winspool\\TOPAZ\LASERJETNe01:[Event Procedure]d2hgh MS Sans Serifi1ghj1ghk1m45o2`Detailo5W`bcdep8"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"10";"0"WhiteWhite Table/Query PlayerList 0;1872;576;576;1008;1152;576;720[Event Procedure][Event Procedure][Event Procedure]+"PlayerList";"Players";"Teams";"Schools";""d5]`abc White_LabelWhiteo5W`bcdepn8"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"";"10";"0"BlackBlack Table/Query PlayerList 0;1872;576;576;1008;1152;576;720[Event Procedure][Event Procedure]+"PlayerList";"Players";"Teams";"Schools";""d5]`abc Black_LabelBlackm 7W;`abk WhiteRating White Ratingd5]7`abc Rating_LabelRatingm 7U;`abk BlackRating Black Ratingm 7W;`0abk WhitePoints White Pointsd5]7`$abc Change_LabelChangem 7U;`0abk BlackPoints Black Pointsd5U`ab(cd Players_LabelPlayersk5U`apb.chi GameResultResult[Event Procedure]1d25U`ab(c Result_LabelResult:i2W`ta optWhiteWond5`dabHcWhiteWon_Label White Woni2W` a optBlackWond5` abHcBlackWon_Label Black Woni2W`a optTheyDrewd5`abHcTheyDrew_Label They Drewm7U`abhchi kRoundRound[Event Procedure]1d5U`,a,b@c Round_LabelRoundo05Ubcd,eh n Tournament Value List1440[Event Procedure]d5U`ab|chdLVAL Tournament_Label Tournament:h1U` a bi CloseForm Close Form[Event Procedure]H Close Formo5W`bc dden"";"";"";"";"10";"10"SectSection Table/QueryISELECT DISTINCTROW [Sections].[ID], [Sections].[Section] FROM [Sections];0;744[Event Procedure]u"SELECT DISTINCTROW [Sections].[ID], [Sections].[Section] FROM [Sections];";"Sections";"";"ID";"Section";"PrimaryKey"d5]` atbc Section_LabelSectiono05WbcddenBoard [Team Board] Value List 1;2;3;4;5492[Event Procedure]d5]`abc Board_Label Team Boardh 1U`Pa| b@c@i DeleteRecord Command75[Event Procedure]@( ȤDLVALP Delete Recordj2U`ahbxcxi FilterToRound[Event Procedure]0d5U`Ta,b$cFilterToRoundLabelShow only this roundVCi N  i i                  ID Last Name First NameGradeRatingTeamSchoolBoardSectionActivePlayed This Year-  PrimaryKeyPlayersTeamsP[Schools].[School] & " " & [Teams].[Team][Last Name] & ", " & [First Name]Players.ID = [Calc New Grades].ID(((Players.Rating)<300) AND ((Players.Grade)="4"))(((Players.Active)=Yes) AND ((Val([Grade]))<10))(((Players.Grade)<>"" And (Players.Grade)<>"0"))((([Results LM 1 - Elementary].Section)<3))[Results LM 1 - Elementary].[Black Points][Results LM 1 - Elementary].[Black Rating][Results LM 1 - Elementary].Black[Results LM 1 - Elementary].[White Points][Results LM 1 - Elementary].[White Rating][Results LM 1 - Elementary].White[Results LM 1 - Elementary].Result[Results LM 1 - Elementary].[Team Board][Results LM 1 - Elementary].Section[Results LM 1 - Elementary].Round((([Results LM 1 - Junior High].Sect}'@. )@PlayerList))))))))))) ]&@}'@Outcomes''''''''''' ]&@]&@0New School Year - Change Grades>>>>>>>>>>> &%@]&@0New 4th Grade Ratings - After Change GradesJJJJJJJJJJJ ,@&%@MSysModules2+++++++++++ *d@d@MSysMonyLVAL i_VBA_PROJECT4?a^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA332.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#8.0#0#C:\Program Files\Microsoft Office\Office\MSACC8.OLB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll#Microsoft DAO 3.5 Object Library*\G{6B7E6392-850A-101B-AFC0-4210102A8DA7}#1.3#0#C:\WIN95\SYSTEM\comctl32.ocx#Microsoft Windows Common Controls 5.0 (SP2) .94Form_Update Player Ratings 33da8c8c1*D^(]QUtility 23da99ecb*DvForm_Players 33a03a6f7*DbH+QTForm_z Create New Tournament Results Table 53da8c8c1*DhIVForm_z Create Results Table from Crosstable 63da8c8c1*D$Form_Enter Results 33aa1b9cb*D7 :Form_z Old Enter Results Form 1339f72a25*DAXLVAL h(Hx_mk1VMz9)O|(_mkH-)O|hOu_mk AccessAnd AS bBooleanByValCase=Dim@DoCEachDElseEelseifGEndHendifRfSFalseUForZFunction_Goto`IfcInkIntegerlIswlocalyLongzLoop|Me~Mid$NextNotNullOrPrivatereturnrsetSelectsetSubThenToTrueWhileWith VBAWin16~Win32Mac DAO db1 Form_Form16 _EvaluateFormDetail2ID]WhiteBlack&WinnerWhite Rating BeforeBlack Rating BeforeeWhite Rating AfterBlack Rating AfterhCombo0 White_LabelqECombo0_AfterUpdateRecordsetClone8 FindFirstM=BookmarkC AfterUpdateControlsKItemz Form_Enter ResultsCombo2Label3,Combo8 Result_Labelr Form_Load{resulturBlack_BeforeUpdateEECancelBlackLVAL _AfterUpdatel%Text10rLabel11AWhiteRatingBeforeWhite_BeforeUpdatetValueK Black_ChangeC{ White_ChangeStrChange _B_str_StrzValMsgBoxR _B_var_IfPIsNullRATING _B_var_Select'EFROM~ Players]where֍into\ WhitePlayerV Recordset OpenRecordset|rstTemp conPubs dbOpenDynamiczvOpenRecordsetOutputs\ rstOutputmEOFFields7MoveNextL!_B_var_conPubs _B_var_Set_B_var_Players`db\propj CurrentDbS White_MouseUpButtonShiftXoYlMouseUpCombo12% bleep_LabelWCombo12_AfterUpdateWhite_AfterUpdateQ RecordSourceb_B_var_OpenRecordsetsP dbOpenTableBvwmCollect_B_var_FindFirst7 dbOpenDynaset lastbh Last Name_B_var_Last Name _B_var_rating+BlackRatingBefore8Label17GWhiteRatingAfterBlackRatingAfterLabel19ILabel20e BlackPlayerR NewRatingsdelta _B_var_delta*floor  _B_var_floor~r1^r2^Frame21ʓLabel22gOption24eLabel25jOption26eLabel27lOption28eLabel29nWhiteWon< _B_var_r1winsKOption24_GotFocusFrame36Label37Option39AeLabel40Option41^eLabel42Option43`eLabel44 GameResult{.GameResult_BeforeUpdateHGameResult_AfterUpdatei`endcase _B_var_EndFdi\ _B_var_diwr_br\aXGameResult_Click_iClick Command45Command45_Click^Err_Command45_Click"DoCmdƧ GoToRecordM6acNewRecYExit_Command45_ClickErro Description fi<] _B_var_fiPlayerK[ AdjustRatings+ WhiteGradeC BlackGradeѹ WLVAL hiteSectionb BlackSectionsWhiteRatingChangeBlackRatingChange!Exit_AdjustRatingsErr_AdjustRatingsText51gsLabel52Text53isText55ksLabel56Text57msText59osLabel60 DISTINCTROW,Reload' First NameVqh_B_var_qORDERATag& Tournament lLabel62RoundTournament_Label# ListIndexQ_B_var_ListIndexKItemData p RowSourceTypeForms Employees  cmboNames RowSource2The'exampleh"cmboCompanyName_AfterUpdate+ strNewRecordcmboCompanyName( ResultsTableR trNewRecord h Customers+_B_var_Recordset Store_Result _B_var_Err_AdjustRatingsS _B_var_Error)Err_Black_AfterUpdatebaExit_Black_AfterUpdateaExit_White_AfterUpdateErr_White_AfterUpdateGCalcBt CalcPointsDErr_CalcPointsq1Exit_CalcPoints2SectionG Command67jCommand67_ClickErr_Command67_ClickExit_Command67_Click: PlayerChange9rstrPlayerFreset>ret _B_var_rsettset recsh_B_var_WhiteSection M1'^ _B_var_M1 WhiteBoard BlackBoard9 WhitePoints{ BlackPoints& WhiteRating  BlackRatinguCombo68&Label69 Section_Label Board_Label?Boardy MoveFirstN Properties+Option39_GotFocus!AddNewa _B_var_AddNewStore_Result_ClickamErr_Store_Result_ClickzExit_Store_Result_Clicke Command74Command74_ClickaErr_Command74_Click DoMenuItem&e acFormBar acRecordsMenu6 acSaveRecordj acMenuVer70XExit_Command74_Clickph CloseForm:CloseForm_Click,Exit_CloseForm_ClickkErr_CloseForm_Click< FirstNamestrFirstLastNamestrLastUpdate LastModified5 Team Board8 LVAL White Ratingf White Points Black Rating Black PointssG^_B_var_White Ratingf_B_var_White Points_B_var_Black RatingPB_B_var_Black PointsmaxȲ _B_var_maxomaximum _B_var_maximum  TableDefs%i_B_var_a ContainersColumniSection0lSectFCount0vne _B_var_ForjL_B_var_i  _B_var_LeftQ _B_str_LeftVlsttnmtwSectinoFRound_BeforeUpdateRound_AfterUpdatekForm_AfterInsertw WhitePlayers~E BlackPlayers AllPlayers@ _B_var_eachc Round_Label Players_LabelQ Black_Label Rating_Labelf` Change_LabelWhiteWon_LabelpCBlackWon_Label5TheyDrew_Labeli* optWhiteWon optBlackWonNY optTheyDrewHubd\ _B_var_bdKbonus _B_var_bonusBoard_BeforeUpdate5& BeforeUpdate6Board_AfterUpdateZSect_BeforeUpdate%Sect_AfterUpdate-;Tournament_BeforeUpdateJMTournament_AfterUpdate Form_CurrentCurrente NewRecord _B_var_recsԂRound0=_B_var_Team BoardcFilter;FilterOn& _B_var_CalcendiC _B_var_endiM FilterToRound FilterRoundplyr4pgptsriscanDMoveLastPointsEdit+ rstEmployeesD strOldFirsto strOldLast(ExecuteYText2~Combo6Last_Name_Labelj _B_var_Loop Form_Update Player Ratings NewRatingd RatingFloorGrade UpdateRatings<UpdateRatings_Click! ComctlLibnProgressMaxLen(SetFocus ProgressLineYUpdateProgress0nrecs6 RecordCount{Enabled۪LTrimbProgressPercentCaptionxRepaint _B_str_MidXrivatei_B_var_FilterToRoundl DeleteRecordHDeleteRecord_ClickErr_DeletLVAL eRecord_Click% acEditMenuExit_DeleteRecord_Clickж AfterInsert:Box12 BoundRound٭DirtyVCheck79Label80CFilterToRound_ClickFilterToRound_AfterUpdate EnableFilter\ DisableFilter DefaultValue*NoMatch/3 FormRecordset FindRecordxe Command81 Command82Command82_Click(Err_Command82_ClicknScreenIPreviousControlExit_Command82_Click FindPlayerrFindPlayer_ClickZErr_FindPlayer_ClickExit_FindPlayer_Click, FindAgain,|FindAgain_Click9Err_FindAgain_Click0FindNextuExit_FindAgain_Click  _B_var_Do_B_var_bEcho OldValueq DoCommandy_B_var_DoCommand CancelEventURFilterToRoundLabel,f_B_var_CancelEvent64 AlreadyPlayed_B_var_alreadyPlayed|rts? _B_var_rtsPAlreadyTwnameoppnametoppcolor2F_B_var_First Name#UndoÞBeep vbQuestionvbYesNoChrK~ _B_str_Chrm#vbYesa?againstvbDefaultButton2pnameZpresultD_B_var_presultSHpcolorpolor"_B_var_NoMatch2'Form_BeforeUpdateP- _B_var_ResultForm_BeforeInsert BeforeInsertForm_Enter PlayersƔ BeginTransRollback FormHeader  First_Name?First_Name_Label Last_Name Grade_LabelTeam Team_Label. FormFooterT _B_str_LTrim v Form_PlayersSCHOOLY School_Labelj DeletePlayerޫDeletePlayer_Click#Err_DeletePlayer_Clickc1Exit_DeletePlayer_ClicktmpGetResultsTables _B_var_rst,dbsǂResultsExit_UpdateRatings_ClickyErr_UpdateRatings_ClickɂOnError _B_var_On6 Postedrstw  Posted_rst3)PostedCommand2 CopyTableV CopyTable_Click CopyObject*Err_CopyLVAL Table_ClickExit_CopyTable_ClickE\tmpNamee(Form_Create New Tournament Results TableDacTable SelLengthSelStartZ)Form_Create Results Table from CrosstableUGetCrosstables~ Crosstable CreateResultsResultsTable_LabelycCreateResults_ClickjqCrosstable_BeforeUpdateeCrosstable_AfterUpdatextab7recorsetH _B_var_WhileIfdp\ _B_var_dpPID _B_var_PID SelectPlayer_B_var_SelectPlayerYfirstzProblemq InsertResult_B_var_InsertResultQRD1RD2RD3RD4RD51RD5rd^rndR1H Err_CopyTabledExit_CopyTableBlandResultsTableBlankResultsTableFErr_BlankResultsTableƂExit_BlankResultsTable school_codeMplygpl^cse _B_var_caserescode opp_tnmt_id_B_var_opp_tnmt_iduxtabrec1eim _B_var_eim.F _B_var_xtabtopp_  Longrescode TNMT_IDrExit_CreateResults_ClickErr_CreateResults_Clicksch RecordCoutn| _B_var_elseifqmSchoolID_B_var_SchoolIDm plyr_tnmt_idP _B_var_ExitSchoolsq6 opp_thmt_idP7of^ _B_var_of. _B_var_opp|op^ opp_tnhmt_id3oppidjopp_IDJWplyr_IDZ plyr_rating6VALUES WhiteResultm_B_var_CalcPoints _B_var_opp_{nnil=Replacef_B_var_ReplacetksjbyvlaQslen _B_var_slen&nrlenC _B_var_rlen_B_var_Err_BlankResultsTable0_B_var_Exit_CreateResults_ClickSZ Hourglassb* Form_z Create New Tournament Results Table+ Form_z Create Results Table from Crosstable;Form_AfterUpdate _B_var_plyraMd school_IDp_name _B_var_p_name Jp_rating_B_var_p_rating p_schoolID_B_var_p_SchoolIDSLVAL p_school_IDp_school*_B_var_p_school  _B_var_SchoolAplistNmsgQsemi _B_var_semiIenddo xisNuv _B_var_isNu?boxyPlayers_Label_ClickJZWhite_GotFocusGotFocusKDropdownBlack_GotFocus Utility1J(Publish_RatingscFolderQ OutputFolderN SetWarnings OpenQuery acExportFixedj TransferTexte> acExportDelim/acExporth]acQueryhTransferDatabase) acOutputQuery/ acFormatHTML}OutputTo`flen6 GetOptionTrim@ _B_var_TrimmTContainerObjectX dbsNorthwindctrLoop. Containera prpLoopi OpenDatabase`IIfzOff! _B_var_plY xxxxxxxxxQopl opp_rating opp_atingF WhirtePointsjaxTable; _B_var_xTable, xTableName_B_var_xTableName rTableName0 baseTableName  alreadyDonefOpenFormpass _B_var_CloseacDialoga_B_var_Err_CopyTable_Click+_B_var_DatabaseP Cancel_ClickacFormacSaveNoDretryingm needRetry Form_ErrorDataErr6Response Form_Unload Form_GotFocusCanD} AbortFormU_B_var_AbortFormXaborformattempt8`attemt _B_var_attemtEh Form_Activaten Activate| Form_z Old Enter Results FormZPreviousSectionYPre5 LastSection% LastBoard DevaultValuezActiveSyesPlayed This YearC _B_var_NameXRatingsA 7~dirò0* pHLVAL ddb1@= d  .9 J<  DAO>DAO *\G{00025E01-:0C  0046}#4.0#0#C:\Program Files\Common Microsoft Shared\w\dao350.dll# 3.5 Object Li`braryH ,ctl >omctlLPibb xb6B7E6392-850A-101B-AFC0-4202A8DA7}#1.3bWIN95\SYSTEM\com532.ocxQWindows qControls 5.0 `(SP2)= Form_Update Player Ratings _VBA_MODULE2VB@g_M@ODU9ED@HB1x]QB,^"B(B"+BUt ilityv!E=KC;9+9b9*!z Cre[New Tournament Results Table|BIOB<%E%! fromossteB5iEntR#"R R"5Old  ?;!X4!__SRP_0?K)^ Form_Players Form_PlayersForm_Enter ResultsForm_Enter ResultsrU~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ AP#&G7yH2> Can't find Player: [ ] [ !  2>2> grade Adding Player:  INSERT INTO [Players] [Last Name],  [First Name], [Grade], [Rating],2>2> [Rating])  [Rating] ) ', 2>2>m. Properties of  container m.'m.    = 2>2>2>2>2>2> !  P 2>2>2>2>2>2>=3>@3>?3>3_mk6_mk5_mk select * from Players  where ID = 9_mk>_mk=_mk  K123H_mkK_mkJ_mkv_mky_mkx_mk_mk_mk_mk_mk_mk Cancel_Click P_mk_mk_mk Enter Results %z Create New Tournament Results Table_mk_mk_mk_mk_mk Form_GotFocus Form_Unload _mk_mk Form_Activate_mk_mk_mk_mk_mkForm_z Old Enter Results Form_mk_mkForm_AfterUpdateBP+y q"BP+y q"BP+y q"a!|y q"d!|y q"c!|y q"!rLVAL qy q"$rqy q"#rqy q"!%:mz q"$%:mz q"#%:mz q"%%:mz q"'%:mz q"&%:mz q"(%:mz q"-%:mz q",%:mz q"7%:mz q":%:mz q"9%:mz q" DefaultValue;%:mz q"A%:mz q"@%:mz q"+=.=-=7=6=9=8=;=:= Form_CurrentA=@=a)O?ѷxd)O?ѷxc)O?ѷxe)O?ѷxk)O?ѷxj)O?ѷxBѷxBѷxBѷx! /|Fѷx$ /|Fѷx# /|Fѷx5Lѷx5Lѷx5LѷxTѷxTѷxTѷxtPYѷxtPYѷxtPYѷx]]]adcegfhml%8%8%8%8%8%80.F o0.F o0.F o0.F o 0.F o 0.F o0.F o0.F o0.F o0.F o0.F o0.F o4PA4PA4PAK=*dީ5}XN=*dީ5}XM=*dީ5}Xx=*dީ5}X{=*dީ5}Xz=*dީ5}X}=*dީ5}X=*dީ5}X~=*dީ5}X|=*dީ5}X=*dީ5}X=*dީ5}X͚qКqϚq9W߳9LVAL W߳9W߳AD$߳DD$߳CD$߳A;߳D;߳C;߳ALN-UXf;D-UXf;C-UXf;?-UXf;F-UXf;E-UXf; (f (f (f (f (f (ffK4 fK4 fK4 fK4 fK4 fK4 LVAL(|y8n|y8n|y8n !i =C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll qA!v l4D#v l4D"v l4DAUlQB/uDUlQB/uCUlQB/uC:\WIN95\SYSTEM\comctl32.ocx 1i GDESTo$@<o$@<GDEST GDESTGDEST}ܱ=ipQ}ܱ=ipQ}ܱ=ipQ#+%+'+&+ADC__SRP_1rU~~~~~~~~~~k     ( Q8 H Xp h Ix  9Cancellastfirst school_coderatingplyr_ID plyr_tnmt_id plyr_ratingrescoderndwrbrresulttsr school_IDRatinggradeGradea{q-|iVC0{a?v\D*X/K @ @ @ @ @ @ @        PlayersSchoolsPlayers.School = Schools.IDA PlayersTeamsPlayers.Team = Teams.ID; Players.Section' g Players.Board% gPlayerTeam)@!" oPlayers.Rating& g Players.Grade% gSchools.School& gName!@  o Players.ID" gSchools Teams Players  G G  PlayersCalc New Grades!@." Players.Grade[Calc New Grades].[NewGrade]A wCalc New Grades Players  G G  2@ 'Players.Rating300) wPlayers  G G ,@ gruo,fpwfuufvxmwv]gruo,sm`}fuv]gruo,xsd`wfsm`}fuu`wjphv]gruo,~buf`wfpf{wrxup`ofpwufvxmwvw`amf]gruo,~buf`wfufvxmwvw`amfguroburvvw`amf]gruo,~rmdfpwfuufvxmwvgruo]ov}vda]xwjmjw}R]BenitezChristopher7)( iTHuntSamuel9!  iTKeintzAlexander9&% ,iTCruzJonathan8#" LiTPlecityD.J.9"! VoDylan8 ,,,MartinezBrandon5&% ,,,MartinezMichael6&% y ,VasquezAlbert9$# u ]~fTranKy8 t ~ThakurAshu9!  s <TemyankoSvetlana7'& p , StinelyPatrick7%$ i ,~fSmartMatthew8#" g ~SharpTrevor7"! e ,iTSenneJared8!  d ,iTScottTommy9!  c ,iTSclafaniSamantha8'& ` ,{gSainzFrankie6#" [ |hRomeroAlex9!  Z ,{gRomeroAlberto6$# X , RogersShana6"! T , RobbinsGrant6#" S , RiviniusBilly7$# R , HaungJasmine6#" Q =iTHarosSelso9!  P , HardyNathaniel5%$ O 22GrohJacob5  M <99GramlichTaylor7%$ K ZGrandiPaul8!  E B{gGarciaAnthony7$# D U}eFreehJoey9  @ 0FalbaumMason7#" ? ,FalbaumBarrett5%$ > >}eEydeBen8 = }eEspyTyler8 VCN   2  2IDOutcomeOutcome2(P  PrimaryKeyEEE(((Players.Rating)<300) AND ((Players.Grade)="4"))(((Players.Active)=Yes) AND ((Val([Grade]))<10))(((Players.Grade)<>"" And (Players.Grade)<>"0"))((([Results LM 1 - Elementary].Section)<3))[Results LM 1 - Elementary].[Black Points][Results LM 1 - Elementary].[Black Rating][Results LM 1 - Elementary].Black[Results LM 1 - Elementary].[White Points][Results LM 1 - Elementary].[White Rating][Results LM 1 - Elementary].White[Results LM 1 - Elementary].Result[Results LM 1 - Elementary].[Team Board][Results LM 1 - Elementary].Section[Results LM 1 - Elementary].Round((([Results LM 1 - Junior High].Section)<3))[Results LM 1 - Junior High].[Black Points][Results LM 1 - Junior High].[Black Rating][Results LM 1 - Ju]&@]&@New School Year - Change Grades>>>>>>>>>>> &%@]&@0New 4th Grade Ratings - After Change GradesJJJJJJJJJJJ ,@&%@MSysModules2+++++++++++ *d@d@MSysModules*********** &X@d@MSysIMEXSpecs,,,,,,,,,,, !!@X@MSysIMEXColumns...........  @ @Import%%%%%%%%%%% s @ @PCreate Ratings List Table88888888888 a{q-|iVC0{a? @ @ @ @ @ @ @           ! " #$%'()*+,-./&0234567   1   Players.Grade[Calc New Grades].[NewGrade]A wCalc New Grades Players  G G  2@ 'Players.Rating300) wPlayers  G G .X0^4^4 c7 f=uFrEg ,iTVoulgaropoulosKathrina9-,$ ,iTVanDeldenKyle9$# ,BBTolinaMelissa6$#  iTStewartRussell9%$ MEESantiagoEd9!  AEESalcidoJonathan9&% &&PeairsMatthew9$# ,BBPaxsonJerry9"! ^BBPaxsonBrandon9$# [PattonKarlyn9#" |&&PappStephanie9$# y8iTPadronChristopher9(' ?,iTMannKate9 7&&MackayRichard9$# 26BBLupeJustin9!  *iTLiuJerry9 ,iTJohnsonRyan9"! uiTHolterMiles9"! ,BBHarveyKim6  bBBHarrisMatthew9$# 8iTHarkeyEmma9!  T&&HamannCarsten9$# ,##GustafsonJulie6%$ ,EEGuiterrezRenee6%$ &&GentaNicholas9$# ,GarciaMaria7"! ,DuranMaria6!  v,BBCrockerJoseph6$# f,ConradAubrey6#" e,ConradAshley6#" ckBBColelayRomel9#" `kBBCobbKedron9!  YBBChavezConrad9#" O,iTCarlsonChristina9'& IPiTBustamanteLuis8%$  Gr&&BurnhamClare9#" FRBBBurnetteLeinani9&% :c::BradleyCharles9%$ 0,BlairC.J.6  //BBBillyVanna9!  *BBBendleJeremy9#" (/EEBeachScott9!  ,BBAmarockLydia6#" #%%AlsterEli9  ,AlexanderChris6%$ ,BBAlbertLeticia6$# -|P%{K!rCuM$sH |L!zQ+ ,iTDavisSophie9"! ,iTLopezMegan9!  ^iTGuarinoAnna9"! miTFinkelsteinEmma9&%! ,iTRockNoah8 77MoradoJaime9"! ,iTGuzmanRicky6"! ,iTWilliamsTaylor9%$ ,iTWatsonGene9!  ,iTRodriguezAna9#" ,iTLopezDaniella9$# ,iTGonzalezJuan Pablo9)( ,iTCapinSamuel9"! ,iTBatizErika9!  ,iTPertusatiJoey9$# ,iTKetchumTed9!  ,iTWebbColter9!  ,iTStielyKameron8$# //SosnowskiAlexander8)( ,iTRondelliScott8$# ,iTPizzuliDonatella8'& ,iTO'SheaKira9!  ,iTNakazatoPen8"! ,iTMulderZach9!  |,iTLiuAmanda8  {s\KoesterElliot9$# y,iTGonzalesAdam8#" w,iTGarcinGiovanni8%$ u,iTFreyWill8 t,iTFernandezVictoria9(' sr//DiggsBrandon8#" q,iTBessetteNicholas8'& p //BassBeverly Ann8&% o,iTBakewellKyle8#" gPuertaHector8#" a,iTMartinezAna Yadell9)( _,iTJonesTravis9"! ],iTIbarraPaulina9$# Y.ElizondoJose8#" W,iTCoronaDaniella9%$ V,iTCiudadWilliam9$# T,iTBalderramaAbel8%$  -QybXiongMaxwell9#" *<&&WorthingtonErica9'&! xBBWheelerDerrick9%$.}T%Z/`6 f<h:iAkAg ,xMLewinsonNate9#" 8iTZunigaRebecca8$# ,iTSiegelConner8#" ,iTIshak-BoushakiSarah8*)$ ,iTMcCalebEmily8#" ,iTSpencerBlake8#" kiTBrownKellner8#" ,iTWoodruffTyler8$# iTNikkariJosh9"! iTPadronJames8"! ,iTPiagentiniNikolas9('  ,iTKarberLily9!  ,iTBrillAlex9  |, WeintraubMax9#" z,iTCarpenterCeleste9'& vJiTClarkAaron9!  i,iTYoungMatthew8#" f,iTBlackwellCameron9'& e)qZAckerleyKevin9$# :,iTAndersonZachary9&% 9,iTAndersonNate8#" 7,iTCoteOlivia9!  eGGBettersAndre9#" YFFMorenoDaniel9#" 6EEMorenoJulian9#" ,EEHallSean9 ,DDCooperBrandon9$# ,BBEndfieldBrad9#" BBAlekayGabriel9$# BEsquibelBrad9#" ,AAGiffordB.T.9"! ~,11VeronoThomas6#" |,11CawthorneTim6#" v,--WilburnNick6"! S,ScottAndrew9"! M,==CooperMichael6$# L,==SanchezGreg6"! K,==ParasNoelia6"! J,==LeeAnn6 F,==ZaninDaniel9"! E,==ZacariasArturo9%$ C,==LagunaCrystalinda6(' ?,==MasonSteven9"! 2aiTAndrewsBilly9#" 1BiTHolbrookWill9#" ,ThompsonMackenzie8('.|T,_4 k@h<kBwN$X, ,iTMaguireColin8#" ,iTMarusaChris9"! ,iTLizarragaKariza8&% ,iTPuchiLaurie9"! ,11GarciaVeronica9%$ ,iTPopeJacob9  ,iTPopeJosh8 ,iTSooHooCarrie9#" 7 BaxterMichael9$# ,iTDelheimAvery9#" JannuziBrigg8#" ,OchoaCarlos8"! -$$GamezLeslie7"! ,iTLopezAndy9  UVirginBradley9$# @**GamezAlan9  x,iTJacobsTyler8"! s,,,MingusDavid9"! r,,,CarterQuintana9%$ o,ViettiChad8!  nSiTMcCallumKael9#" j,iTParksStella8"! h,iTDrollRussell8#" gx//CornellMichael8%$ Z,iTWodkaJoshua9"! Y,iTChozetBlanca9#" X,iTCamachoXenya9#" WKSanta CruzCristobal8*)  V,,,MorenoAndrea9#" P,iTDavisNicholas9$# M,iTGarciaAndy9!  H-iTKimballOtis9"! D,iTWhiteJohn9  7iTKaplanJared9"! ,iTJohnsonTim9!  ,,,SpargoGabriel8$# ,iTSheetzEricha9#" ,11KentWilliam9"! viTPedronChase8"! ,iTYangBryan9  ,iTBarnesAndrew8#" iTBrownAaron9!  ,iTBerensAlec9!  ,iTMaguireChristen8&% ,iTKanisKristiana9%$ ,iTFergusonFlynn9$#.[1]3Z.V,Z/b9 h?m `,iTSchultePatrick9%$ _,iTHlawekRobert9#" X,iTPerkinsJon9!  S, GribschawJacob6%$ R, DelucaAdam8!  Q, AlpertMikey8"! P, SlaniaDaniel9#" M,iTKramerBrandon7$# L,GermanErika7"! K,iTKochCaleb9  F00FerrariRebecca9%$ E00NewmanTynan7"! :,iTWrightPaul8!  ,,iTSitlerCory8!  +,iTBakkeNick9  *,iTBakkeAlexandra8%$ ),iTSnappMichael9#" (,iTMontagueJamie7$# ',iTFisherJessie9#" &,iTMuseValerie9"! %,iTMilenderKyle7#" $,iTLuceroJarrett9$# #,iTPattonCassie9#" ",iTGilbertKatie7#" ,!!WosiakMikojai7$# ,iTBurgeMax8 ,iTRodriguezRolando9'& ,iTRodriguezChristopher9+* ,BBHovelJohn9  /BBDoselaDanielle9%$ /BBHenryTryone9"! ,BBFallMichaelsen9%$ EBBJohnsonRapheal9%$ ,iTWaiteKelsey8"! ,&&SellingMatthew C.9(' ,iTGrundyConnor8#" ,iTMoralesRicardo9%$ ,iTCheangDaniel9#" ,iTReyesRaymundo9$# ,iTSandersIan9!  ,iTSaundersShari9$# 00SaundersEric8#" ,fOHasmanTristan8$# ,iTParrisAmelia9#" ,iTSpellGregory8#" 11ErlyAndy9.[,Y/`8 d<i@mEwMj , PattersonReed7$# ,iTWalkerNicholas9%$ ,iTTesanovic-SarcevicRachel9/.( , GadeaDiego7!  ,iTCerritoElizabeth8'& d//CirilloHarry7#" ,iTBolhackAlex8"! ,KoesterKatie7#" , SandersLouis7#" , PichlerIra7!  , DunnMatthew7"! , BermanAlex5!  ,iTRockowitzSarah9%$ ,iTUchiyamaTia9"! ,iTRubinSophia9"! , HansenJesse7"!  RockowitzJonah7%$ , McBrideAdam7"! %%SoyannwoJoshua7%$ X D'AloisioCollin7&% ,iTHosmerBobby9"! , RamRajeev7  ,iTToussaintEva9#" NelsonEric9!  ,iTGaynorMax9  ,GastelumManuel7%$ 9LisenbyJordan9$# ,DoumasLinnea7#" ~,CorkillBrianna8%$ },iTRielPascal9!  |OWiseErik8 y,iTNorcrossDavid9$# u}qZHellmannBrandon8&% t11ZupenWill9  s011GardnerNeeko8#" r,11MerhebNadine8#" q,11WebberKailey8#" p,11WebberKyle9!  m,iTBradyAmanda8"! iXScordatoDavid8$# g,iTYampolskiRachel8&% f,iTWaldsteinMichelle8(' e,iTBrobeckMarie8#" d;iTStefanAndrew9#" b,iTHaugheyMyles8#" a,iTImpeyPaul9 .T-Q%W+T,W.V.f<i ,iTZunigaJezreel9$# x,iTErnstLauren9"! w,iTBaileyDevin9"! i,iTSchafferSteven9%$ g,iTMaxwellJenay9#" fiTEubanksTrace9#" e,iTLarsenAndrew9#" _,iTVitaEldon8  ], LaneDylan9  Q,iTAhmedZayd9  L,iTEnglishJoel9"! K,iTClineAmber9!  I00NewmanCaitlyn8$# H,iTSarmientoFrancisco9)( G,mWGiblinJackson7$# C,mWSpencerJohn9"! B,mWCruzAdriana9"! ?,mWVitoloMegan9"! ;,iTTimoninaDaria8$# 9,))ArmstrongZachary7'& 7,))EvansJoseph7"! 6,iTWalkerNoah9!  5,iTMontesMatthew9$# 3,iTJonesMegan9!  2,iTBecklundDaniel8%$ 0,iTSturdevantCody9%$  ,,))GironEmily7!  <iTMoroyoquiAdiel9%$ ,iTDe La CruzJed9$#  oiTRosenbergJacob9%$ ,iTWagusBrittany9$# ,iTOgalCarly8  ,iTRostalTravis8#" ,MoradoAntonia6$# ,iTReyesMatt9  GinChristopher8%$ ,iTMaldonadoAlexander8)( ,iTNikkariSarah7#" ,iTHegstromJeff8#" , SchoensteinAaron6'&! ,iTPullenLucien9#" ,iTHudickIan9  ,iTBuchhauserBill9%$  ,iTLorensonTaylor8%$ ZhangKevin8!  ,iTRubensohnDavid9%$.}S+~U)[0Q)U.X,`8f ,HernandezMaria8%$ ,HernandezAna7#" ,iTKathRebecca7"! ,]JonesTravis9"! ,T,OrtegaJordan7#" nMontesLuis9!  ,iTCervantsRicky9$# XKayChloe7 AckerleyKasey6$# ,iTRuizJason8  HowellMegan8"! ,NicholsonDavid8%$ p11MillerConor7"! ,,,McClendonAamir9%$ ,iTHamiltonAlex7#" ,CortinasAllyson8&%  BrewerKellen6#" iTBrewerIan8  jBeltranEduardo7%$ ,iTBarrazaJorge9#" =iTZhangWanjun6"! ,iTRasconRueben6#" ,!!TovarezVivian9$# ,,,LopezRaven7!  bClarkJuan Carlos9'& 1 ClarkNikolas7#" ,iTWatsonJames9"! /iTSamarasinhaSurani8('! 0iTSamarasinhaRuvini8('! ,iTCervantesJose8$# ,PujolRuben8!  ,iTBarajasZaida7#" , SargentMargo7#" ,EEAveryTanner8"! ,fOBecwarKayla7"! ,99GerhauserHowie6%$ , De LucaRyan6"! ,iTMoralesJesus9#" ,MooreHarrison6$# ,iTRussoMelissa8#" ,iTValenzuelaRobert9'&  ,iTRomeroAlan9!  <iTZunigaHaziel8#" ,iTBachilierLuke9$# ,iTBachilierZach9$# ;iTOlguinFrancisco9&%.Y*}P'V/b8iBpGkAk ,HellebrekersTess7'&" ,HatchettBentley7&% , EscobosaIvan6#" bDolanJimmy7!  ,DaveyConnor7"! s\CampbellSean9#" ASandsMichael9#" c, VanWyckChristopher6)( b, TolleySteffanie6&% `, ScheppeNicholas6&% _,iTRaszkaGabe8!  ^,iTPullenMegan7"! \,iTParriharRaashi9%$ [,iTOliverLeigh Anne8'& Z, OliverJohn7!  Y, LyonsNick7  W, HallCharlie7"! V,iTDeLongMax8  U,iTCrowderJacob8#" T, CharlsShannon7$# S,iTCharlsSasha8"! P, ArnettDelaney6$# NLiTSernaTim9 M, CastilloTony9#" KiTZhangSteven8"! >,CollinsRoss6"! <,eRCrumpCaleb9!  7,EEQuinteroJuan9#" 6,EEGrijalvaAnn9"! 5LunaAmbar9  4LunaMarysol8"! 3,iTVillegasJazziel7&% 2,iTSchultzKyle6"! 1,$$GamezDaniel6"! 0, LopezMiguel9"! /,iTNicholsZach8"! %s\DearmoreCharlie9&% $,ThompsonRyan7#" #,HolguinFabian7$# !b KaplanJonah6"! ,,,GrijalvaAyliandra9(' ,iTLindekugelMichael7('  ,iTJamesKatie9!  ,iTFriedmanAdam9#" ,iTAhlersLayanie8$# ,iTLukoHarrison8#".Z2 iAmBtHyM%}R%|P v ! ,iTDe LunaAlejandro9'& ,<<LiuMichael7!   ,iTGerwinChase8"!  ,iTBrockmanJacob8$#  ,iTSamoy-AvaradoElise8)(#  ,99BentleyGarrett6%$  ,iTBentleyRyan8"!  CiTRooneyAlexandra8&%  ,11KeahonGabby8"!  5iTGrossmanChad9#"  ,iTBernalAlexandra9&% ,iTWiedemanKevin8$# ,ArnetteZach7"! ,HubbardAlex7"! ,iTSanchezSteven8$#  ,iTStanleyMarcus8$#  ,iTHurleyCody8!   ,iTStanfordMayela8%$  ,iTSamsonKevin9"!  ,iTWaidaTyler9!   ,iTCartwrightGary9%$   ,iTWestJessica9"!  ,iTMolinaDavid9"! ,iTFaumuinaJarvis9%$ ,iTStanfordMarisol9&% ,iTLealBrisa8  JLuceroMartha8#" liTVegaMarco8  , AuerbachAri7"! .//ZipperianDemi8$# ,StevingJason7#" ,StevingMarcus9$# , TavaresCarlos8$# miTO'RourkeKevin7$# ,iTBreeShantel7"! fiTLandryGreg7!  ,11TannerDevin8"! yiTJoyceConor8!  ,iTRizziJimmy8!  ,iTTaberAlana9!  ,iTMaezAshlee9!  ,TuckerCody8!  ,ThompsonKeenan6%$ ,iTRudaArielle7"! ,MorrellShon7"! ,KellyTyler7! .|S!zS,^2`6 c<nJ nBk z ,iTSanchezLawrence7&% y ,iTSchererBenjamin7&% x ,iTEl MuribNadia8$# w ,iTDoubravaAlex8#" v LiTGibesErica8!  u DiTCampasSamantha9%$ r 7EscobosaBenjamin7'& l ,SNegelspachDavid7&%  k ,iTCrossChristopher9'& j {55WolfsonRyan7"! h 5iTGrantKellner8#" g ,fOMaPaul9 d , FelixBianca9"! c ,iTWilliamsKatie8$# \ :iTBarajasCasey9#" [ 44ParraAlex8  Z ,iTGundyAustin8"! Y ,iTSipeAmber8  X ,iTSpiersGraesyn7$# W ,iTBarajasHaley7#" V ,iTDiseoAaron7!  U piTHillerBrandon7$# T ,iTMaduliMarissa6$# S ,iTMaduliSilvia6#" H ,EECornishIan9!  G ,EEGonzalesRyan9#" A ,iTSalazarAnthony6%$ @ ,iTMilesBrian6!  ? ,iTMontoyaMatthew7%$ > ,iTHernandezDavid7%$ = ,EEMontagueJames6$# : eiTTrumanAlex9!  6 ,McCallumJuno7#" 5 JacobyAlex9!  4 ,iTAldreadKoby9"! 3 fiTKeyesEven9  1 ,SGreenRyan7  0 eqZRoseMichael7"! . ,iTHouchensKaine9$# + ,iTHornerBryce9"! * ,fOHillmanJacob8#" ) ,fOJameson-FasuloTrevor7+*$ % ,<<ShafferMatt6"! $ ,Miller-PerryNoah7'&" # ,iTLewisJoshua8"! " ,iTSchlegelValerie8&%-wM"zP(U*|S(|R*zR#tJ"r ,LaSalleMckinley6&% ,IbarraHector6#" ,iTDupuyWilliam6#" ,BachelierMadeline6(' 8iTRuizJunior8!  , MatottaJulia7#" C11ForrerEsteban7$# %%BrownellCaryn9$# G22BrownellJennifer5'& ,fOPritchettGlen9$# fEgurrolaBrisaymar9(' ,iTReeseJesus8!  |OwensRobert9"! ,r[FerellZachary8$# ,BrittenhamAlexandra5*)  ,iTSanchezSergio8$# EnochsEric8!  XLawsonLauren8#" EndressRyan7"! ,iTCheangRobert9#" HernandezAllen8%$ ,iTMcEldowneyJaxom8&%  ,MoradoEnrique6$# ,TrumanCarly6"! ,StanleySarah7#" 9SchlechtJonathan8'& ,iTJonesKatherine9%$ ,iTDiazCarolina8#" ,--GiovanniEmily9$# ,--GiovanniVince7$# ,--DenigrisRobert9%$ ,--AlmadaFrank6"! 2}eWojtowiczZach9$# ,--HaleKaycee7!  ,--KochKeaton8!  ,--HidalgoMaria6#" W--HidalgoMiguel8$# ,--GuerinJames8"! ,--GuerinRenee9"! uiTKornbergDylan8$# wiTKornbergDavid9$# ,SBosmenyChloe7#"  ,SFrankotMichelle7&% } ,11FrelinghuysenChristian7-,# { ,iTConwayKyle9! .e<f;f>i@n@c:mFx + >LariosGerman7#" * ,EstradaJuan7"! ( ,iTCortezJoey8!  ,--BrownConner7"!  ,11GoodenAlysia9#"  ,11EzellMatt9   ,iTGuerraNicole8#"  ,iTBurkLee8  ,iTOswaltShawn9"!  1SPedronColin6"!  ,iTCarbajalNathan9%$  ,iTEllisHannah9"!  ,t]StauffacherGarrett9)(!  ,t]CastenedaKeanu9%$ ,t]SteimerJared9#" ,t]FloresLizvette9%$ ,t]EchandiaIsaac9$#  ,iTChronisternJacob9'&! ]//HancockNathan6$# //BassJennie7!  ,iTArchuletaKyle6$# ,GarciaNohe7!  ,GonzalesNicole7%$ kRielLaurent6"! ,iTSchwebelHenry9$# ,MercanliFerdane9&% @JayassiGilbert9%$ ,iTDupuyJohanna9#" ,DuranJose8  ,WodkaAaron7!  ,RodriguezJusten7&% ,ParkJazmin7!  ,MedinaElizabeth7&% ,MedinaAlan7!  ,ManjarezCesar7$# ,MachadoKeving7$# ,LaSalleStephen7%$ ,IbarraHector7#" ,CelayaRenee7"! ,CanettSandra7#" ,VillasenorAriel6&%  ,SuarezJorge6"! ,RuizRaul6 ,ReyesJerod6!  ,ParkAlex6 ,ParkAllen6 *-Y/R)uG|S+Z0Y/_3  ,iTLopezStephanie9%$ ,iTAispuroAngel9#" ,LucasSean7  ,LucasJacob6!  { ,iTWallaceWilliam7%$ z ,iTLadnerIan7  x , BurtonSawyer6#" w !%%PennockSteven6$# v , BakewellLuke6#" u ,EEChristyDavid7#" t ,EEChristyAviry8#" s WJannuziBarnes6$# r %%AngeliPeter6"! q  ConstantinoAnthony6)(! p , JonesBen6 o ,,,MolinaAlexander7&% n ,,,MolinaDaniel7#" m ,CarpenterKelly9%$ k .""LeyvaCzarina7#" i ,,,WasiakMikolaj7$# h ,,,LiattiJulia9"! g u//CotterSam7  d ,fOLeeMatthew9!  a ,u^BergerDiego8"! ` ,u^RuizJoe9 _ `nSjoquistMike9#" ^ BnYoungJared9!  [ ,u^OssowskiJulia9$# W Cs\WilliamsSam7"! V , ChristopherDylan7'&! U = BowmanRyan8!  S , CarbelleiraLucas7'&! R ,iTSchulterCaroline8'& Q ,,,Hoeffner Jr.Steven7)(" P ,RiveraAylin8"! O ,u^BourgeoisYvonne Rose9+* C ,,,FloresRobert9#" @ ,iTSepulvedaKathryn9'& > ,EEHawthorneGabe8$# = ,EEChangKevin8!  < ,iTFarrellPaige8#" 8 dRzeslawskiMarco8&%  7 ,iTZavalaRobert9#" 6 ,iTCheangDavid9"! , ,VillaIvan7 '-U%Y1e>b5 Z2Y-Y. ,iTMorentinEmma7#" \}eMooreRyan8  ,iTMillerMatt9!  ,iTMillerGerald9#" , MillerBrianna7$# u~fContrerasRyan8$# Ar[ConsteniusMatt9%$  ,}eCliftonMikey7#" ,iTClaytonKyle8"! ,iTClausonJason9#" ,iTClausonChelsey8%$ WiTCervantesRicky8%$ MiTCarterMatthew9$# ,iTCarpenterCody9$# ,iTCaparaCameron8$# , BrowneNicholas8%$ , BrowneAlex6!  m11BreckinridgeWilliam9*)" ,11BreckinridgeMark7'&" , BowmanNicholas6%$ ,iTBowieRenee8!  , BorboaAdam7!  , BockovenMichael5&% ,~fBellowsDaniel5$# ,~fBeauregardGarrett9('  522GephartBlake6#" n DelatorreDiliana6'& Jr[DreierRobert8#" 522GiblyNati6  GzcDunatungaSalika9&% ,22RooneyMorgan6#" ,22LeeJoey7 I22LeeAndrew6  ,22LaneAdelina6"! ,22GibleyNati6!  s\De SaJacqueline6&% ,SCheungCori6!  ,22BurkDavis7  ,iTWheelerSam9!  ,TempleJohn7!  Yr[SteinkuehlerSydney7)(" @iTDavisJournee9#" qZMathesonLogan7$# P JohnsonConnor6$# ,w`TerrillMorgan8$#.V-[1b6j?nCpGvJ#x < OEscobosaBenjamin9'& ; , ErstadAlex7!  : B~fEhredtAmanda8#" 8 ,iTEcheverriaSam9$#  7 ,{gEatonEden6  4 ,r[DickersonTyler8%$ , ,iTCorrnteAngelina7&% + , ConwayRenee6"! * iTYourgulesZach9$# ( , WuDennis6 ' ,iTWhiteKirstie9#" $ ~fWaddellAndy8"! # -~fWaddellHannah9$# JimenezDaniel8$#  JimenezAdrian9$#  , MikeAndrew6!   ,iTMeyerMelanie9#"  , McNamaraTrent6$#  ,iTMcGrathKelly8#"  7iTMcGeheeMatthew7%$  u McDonnellJon6#"  ,}eMcCannSean7!   , ManeulNavar7"!  D{gLoretoMichael7$#  3{gLopezAlba7   GiTLongMichael8"!  ,iTLohmeierKevin8$#  ,iTLecoursJacob6#"  , LangKevin6   ,SKalaluceDaniel7%$ , HollandLee6!  T{gHillTom8 I}eHensleyAlan7"! ,iTRiedellAustin8$# ,~fRangelMontserrat9'& _r[ProvinceRyan7#" sProvinceKyle9#" ,iTPowersElizabeth8&% , PooleEathan5"! kiTPolkJared9  ,{gPadillaShelly8$# ,{gPadillaRuby7"! ,iTOlumbaDonovan6$# ,}eOesteJanelle8#" ,r[MorganDante7"! ,iTMorentinJordan9%$.^7 e=jBqGvIwO{O"w ,iTWilliamsonBrandon9('  ,iTWesleyTrevor8#" ,iTIdlerZachary8#" ,iTKrauseLisa7!  ,iTBluehdornJordan7&% /McMasterColten6%$ ,ybWarrenAlex8!  ,fOCarlsonJesse7#" `iTKathAllison5"! ,iTArnerAshtin7"! 9iTBenitezChristopher7)( iTHuntSamuel9!  iTKeintzAlexander9&% ,iTCruzJonathan8#" LiTPlecityD.J.9"! VoDylan8 ,,,MartinezBrandon5&% ,,,MartinezMichael6&% y ,VasquezAlbert9$# u ]~fTranKy8 t ~ThakurAshu9!  s qTemyankoSvetlana7'& p , StinelyPatrick7%$ i ,~fSmartMatthew8#" g ~SharpTrevor7"! e ,iTSenneJared8!  d ,iTScottTommy9!  c ,iTSclafaniSamantha8'& ` ,{gSainzFrankie6#" [ |hRomeroAlex9!  Z ,{gRomeroAlberto6$# X , RogersShana6"! T , RobbinsGrant6#" S , RiviniusBilly7$# R , HaungJasmine6#" Q =iTHarosSelso9!  P , HardyNathaniel5%$ O 22GrohJacob5  M <99GramlichTaylor7%$ K ZGrandiPaul8!  E B{gGarciaAnthony7$# D U}eFreehJoey9  @ 0FalbaumMason7#" ? ,FalbaumBarrett5%$ > >}eEydeBen8 = }eEspyTyler8  /~S'\3tI!_7i@mAvL s ,iTWachowiakMorgan7&% , LawsonBenjamin6%$ bSchannepJack5#" ,iTBunchCameron8#" , MacDonaldJames7%$ ,99GramlichEmma6#" V22RacineTate7!  ,22MarNicholas7"! ,kSullevenJeffery7&% ,iTFosterSam7  6s\WuAngela9 ,~fThompsonDillon9%$ ,kTehaAdrienne7#" ,r[StrumpfAndrew9$# ,iTSpainhowerJoey7%$  ,iTSolheidE.J.9"! ,iTSleimanNoah8"! ,iTSewakAinesh9"! ,iTRodriguezJozette7'& ,nXRabinEzra7  ,iTPowellSean6!  }ePolstonRyan9"! ,kPainConner7!  ,kPainAndrew6!  ,ybPRoger7 ,ybOZachary8 ,nXNoggaJan7 QiTNelsonColin9"! ,kNatoliDanny7"! ,kMossTaylor7!  ,}eMcCannMelissa8$# YybMurphyJohn6!  9~fLeonJonathan9#" ,~fLeonElda8 ,ybKJames7 ,ybKCarl8 <{gJimenezIrac9"! ,ybJDominic6 ,EbingerTimothy8%$ ,kDumonsEmma8!  ,kDobbinsDana9"! ,kDiazDamian9!  ,kDavenportTyler9%$ ,nXCamposMichael7$# ,kBausemanCaleb8$# ,nXArchangeliMico7%$  ,kAaronsonAlexa7$#.W.Z.|P%zQ%zU)V,a3 j Q ,EECanesDavid6!  O ,EEGarayAlberto6#" ? ,iTZedakerNic7!  > ,iTTapiaEd8 = ,iTSalazarOscar8#" < ,iTMendozaFrancisco8'& ; ,iTMayoAndrew8!  : ,iTJaimesMaria8"! 9 ,iTHortonKenny7"! 8 , DamienNavarro7$# 7 ,iTBuelnaEd8 6 ,iTGaitherLogan7#" 5 ,iTStormsTyler8"! 4 , TavaresFernanda8&% 3 ,iTGarzaIsaac8!  2 , SanchezJullisa8%$ 1 PRomeroIlana7"! 0 , AgostiniJoseph8%$ / VoAlina7 . ,iTBellMaggie8!  - ,VasquezIvan8"! , ,iTElquezabalDanitza8('  + ,iTMundingerClay8$# * ,iTValenciaSergio8%$ ) ,RuizJoselyn8"! ( ,iTVasquezEduardo8%$ ' , EscobarLuis8"! $ 4 SantanaAlfonso9%$  ,iTYeattsDuncan9#"  ,iTVarelaGabriel8$#  ,iTHalbertCathryn8%$  ,iTCastonguayTevin7&%   ,iTBlumenkornLilli8&%   ,iTOrozcoJoyceline8&% >""ClarkNicholas7$# ,iTCollelmoHector9%$ , AcostaMartin8#" , NavarroDanika8$#  , SpillaneColin7$#  WiTFassOfer9  ,iTContrerasDanitza8'&  EiTRayburnT.J.9"! ,iTHerreraVictor8$# ,SiordiaEduardo7%$ ,~fSuarezJonathan9%$ >**CotaJoey8 -{R)wP#tK!zP$zO$wJ tHm ,&&HamannKylin8"! ,22CorderoKelsea7$# ,nMulligan-LeCroySkylar7,+% ,nQuadeEmeric6"! ,pSmithCourtney7$# s\WatermanJoshua8%$ ,oJacksonKyle7"! u<<AwaltCharles6#" ,&&HamannWynston5$# JiTRachowieckiDavid8'&! , HarrisBrooke7#"  KaminskiMatthew5&% @iTGibesAnthony5#" ,iTBarberErin8!   ,iTMcLaughlinMackenzie6*)  ~ ,iTPrestonTyler9#" } ,iTGuarinoThomas9$# | ,nJacobsWilliam7$# { ,nJacobsMarcus5#" z ,PrinceMarcella6%$ y ,r[GermainDominic7%$ w ,}eMcEwenPaul8!  v ,}eTeranChristian7%$ u ,}eGarciaDillon7#" t ;}eGarciaBrandon9$# s ,kParkMadison6"! r HiTDebrayArun8!  q ,iTBostwickRoxie8$# p _--BostwickWill6#" o >iTStoneLeanne8"! n ,iTBeristainDaniel8&% m ^iTGuillenAnthony8%$ l , NavarroDamien8$# k ,11TedescoTrevor8$# j ,iTHorvathVeronica9&% i ,iTFifeJulie8  g 5iTGonzalesCarlos9%$ f ,iTAgosttiniMelody9&% _ ,iTYoungquistTrevor8'&  \ ,mMartinezJesse7$# [ ,mLaVigneEmma6"! Z ,iTSotoEdmundo7"! X zr[RichardsonTrevor9'&  U , BrownNoah6  R ,EELiquidanoFrancisco6)(.]'S'}T'}S,c:f=l>j  ,{gThurmanCarlos6$#  ,{gRosasAlejandra6%$  ,{gParraFernando6$#  ,{gLuceroKevin6"!  ,{gCortezAngel6"!  ,{gCarrilloFernando6'&  ,{gSkwaitDavid5"!  ,{gMunozLuis5  ,{gCarrilloManuel5%$ ,{gCarrilloJesus5$# ,22ChoiJungyoon7#" ,22ChoiSiyoung4"! _11QuantzDylan7"! ,11AngiuloPatrick7%$ T11DalyConnor7!  ,11Wallace-BoyerCole6('# ,11TwistDerek6!  ,11MatthewsSam5"! ?SChodosDane7!  ,SLentJames5  ,22NolandTrevor7#" 22VasicIvana7!  ,22FranklMira6!  ,22???Robert5  L BosleyChance6#" ,ZhouXhenglong7$# ,WangMichelle7#" <ScordatoAlayna4%$ ,<<ZappiaJason6"! ,<<CrandallPatrick4&% , RosadoIsaac5"! , HopkinsMorgan6$# 1 GuntherAaron5#"  DragonyJacob6#" ,&&HamannStenson8$# ,qCooleyClarence9%$ ,oJacksonChristopher9)( ,iTRamosLuciano8#" t%%AkpanEssang6"! ,iTPieperTyler8"! ,nHessRachel7!  ,nJimenez-WienekeAlexandar6/.% ,nSchneiderMax6#" Ss\Cain-HodgeTory8%$  enDeNikeSam8  ,iTBoshCody8!-}O#oHwN#uK#wIoJ#|S* b ,iTFortnerDaniel8$# a ZiTStewartGalen8#" _ LiTWillieAdam9!  V d11BrerenRyan7!  U ,99ValleyDanny7"! T GReedMichael7"! S ,99PudwillAustin6$# R }SGrandiMichael6$# Q ,22SchommerRobert5%$ P M XuJames6 O =iTWongAlexa8  N ,22WongMax6 F ,uStaplesJackson6%$ E ,mWMcEldoweryJaxon8&%  D ,SchorrMatthew6$# C ,SegalJoshua6"! B ,AraduylaTushara5&% A aiTAradyulaSasidhar9'& @ ,SavageDamien6#" ? bKelschMichael5$# > ,ThompsonKit4"! = FBruckmeierJordan4'&  < ,SandsDonny5!  ; ,MorenoAndrew6#" 8 ,iTMartinezAlejandra8(' 7 ,iTPaezGabriel8"! 6 ,iTLermaNancy9!  5 DGaravitoFernanda9'& 4 <iTJohnsonRobert8$# 3 IiTFrancoMario9"! 2 ,iTCruzOctavio9"! 1 ,iTSorianoMarco9#" 0 ,iTContrerasEdgar9%$ / BiTDorameJ.C.8!  & ,r[MartinezNick7#" % ,r[BooneCori7   W{gSchrimpfRyan9#"  ,{gMartinezViridiana9('  ,{gHickmanKristina9&%  ,|hCasteloEsmeralda9'&  ,{gMartinezBrenda8%$  3{gGallegosTeresita8'&  ,{gHustonKristen7$#  ,{gHernandezPedro7%$  ,{gBeyerleBranden7%$ .\2U.S)~U.[5 hCpEs ,iTOsborn-BrownCedric9)(" ,iTWidgerSam9  IiTRosasMichelle9$# ,iTBuggLogan5  ,iTBaystingSam7"! ,OchoaBernardo9$# , RayMarli5 , JohnsonTyler4#" , LawrenceJohn4#" b HancockAndrew4$# ,22NavarroChristina5'& ,nMichael5 `nMatthewsLiam4#" , BallMateo6  a JiangFrank7!  ,}eEspySamantha6#" t}eEspyChandler4#" ,}eEspyRyan9 6iTBedoyaMark9!  ,iTSapinoThomas8#" ,SDennisJackson5$# ,,,HerbergEvita4#" .00O'ConnorAustin8%$  ,iTBakerJohn8  ~ ,iTWallaceJohn4"! } ,iTWallaceBen6!  | ,iTBenningtonBobby5&%  { ,iTCampasSerena7#" z ,iTEsparzaZachary7%$ y ziTLyonsTimothy8#" u ,~fEspinozaJonathan9'& t ,~fHartliepHarley6%$ s ,~fMichelHeidi9"! r ,~fChaviraRosselyn9&% q n~fBradfordDavid9$# p ,~fMartsAlex9  n ,11QuigleyChristopher5)( m MartinezErnesto8&% l //YellJoshua6!  j ,iTQuickSophia4"! i ,iTGloria (Taz)Louis6('" h ,iTYoungBrendan6#" g ,iTWichnerKaty7"! f ,iTHicksAndre7!  d ,iTEmpensShelby8#" c ,iTHussyStefan8"!.\3 d8 d>jBuN'Y-[1  PennockJoshua4$# ,,,HoeffnerChristopher6*) , MannStephanie6$# , ComrieAlison6#" ,yMolinaMarcus6#" ,JurovcikJonathan6'& 0uSituDaniel6!  11RecchionEdward6%$ ,99YuehAlex7 , WoodsAbraham9#" ,KimminauJessie5%$  ZipperianJimmy4%$ ,{AvilaPaul5  , QuezadaOmar9"! ,~fSuarezElda8!  ,iTTreenBrennan8#" ,zBackesRay8  KzBohmLinda8  ,r[ItoMamoru8  ,r[DickersonTrevor6&% wiTDiancoClark9"! ,iTBakerLogan9!  3r[KnutsonIan8!  ,nBinderDawn6!  IsoeKohta4  ;xHolbergSarah9#" 3 GillillandRachel4'&  ,xLunineJoseph5#" ,xHaugaardZowie7$# FxRuizStar9 ,iTParraKevin5!  t00RiveraXavier7#" ,iTLandryMatthew4$# ,iTBorajasJaime8#" ,iTAguilarYarditza8&% =}eSantinellaKory8%$  q}eMartinSean9!  ,CamposLuis5!  8MorganDaniel7#" , ModianoRebecca7%$ ,iTAllenDelisa8"! ,iTTeigeKarisa8"! ,iTTreadwayTaylor9%$ ,iTBuggAdam8 5iTSandsGerald9"! ,iTDolatKaylee9"!#.V-c7lDrGuN"~V.^5 E,~EdwardsLeah9"! D,~EdwardsCarrie9$# C,~BurkeMichael9#" B,yBisnichukSolomon7'& ?,99AdairAndrew7"! >C""AcostaRodrigo7$# =,SCannonDanielle5%$ <~PaeJohn8 :,xConcienneJeff6$# 7,}eGosslerBret6"! 6,}eMooreDavis6!  4,22TracyQuinn7!  3WiTMissimerMatthew8&% 1aLaosFritz7  0kGengWei8 /,00RiveraMarisol5$# ., HubbellWinston6%$ ,HzBeckDavid7  *IsoeYurika6!  ),iTPieperKyle6!  11RecchionCharles6&% ,11BackstromKitty7%$ EiTLandesCasey9"! ,~fCareagaRachel6$# ,~fPidhaynyRyan7#" <11BackstromBrand8%$ , FiangFrank8!  i MorailaJoel9"! ,,,ShoemakerAdam6$# ,iTShahSanjay8!  @iTBoseSohan8  E MayersohnNick6$# <<StreetyBeau6"! T55StreetyJule8"! ,SCoyneAdam6  //BrodkeySpencer7%$ uYaoJimmy6 ,SmithBlake7!  ,~fOrdunaAngel5"! ,~fLehmanJessa5"! ,11SweetMeaghan6#" 22KarpovDemid6"! K StompolyJohn-Amos6(' ,22HongSukjun5!  ,nXChipmanPeter5#" ,}SmithBrodie8"!.^5 \2].[1 c9g=f; h ,iTCarleyAlex8!  ,PerezJonathan9$# ]vNellisSean9!  ,iTOrtizJovany9"! ,""VillarrealCecilia7('  , AndersonJames6$#  BalianiAnno5"! ,SaenzNikolas4#" ~}eCrosswhiteTimothy8('  |LiTBarclayDavid7#" {2nWhiteAdrianna7$# z,ArnoldChaska8#" y4 GirardJoshua5#" x LaceyJimmy5!  w,iTContrerasAlan9$# t,iTKillmerRachel8$# s,zDowlingKelly8#" r,zStainsbyKyle7#" q,zNewellChloe7"! m,~fPhonBrandon6"! l-~fCareagaManuel8$# j,00LeonMichael5"! iR00LeonSteven9!  h{00FrenchStevie6#" g00FrenchHannah7#" f,iTViljacGregory6$# e,ChoeHarry6  dsAbramsAlex7!  c/ St. PierreGreyson4('  b0 St. PierreBrandon7('  `,11QuigleyBrendan7%$ ^X SmithShakai7"! ],iTRiveraJanier7#" \,~QuintanarChris9%$ [,iTPriceMichael9#" Z,PriceMatthew7#" XH<<ParmanterJeremy7&% W,~OwenCourtney7#" VEEOrozcoDavid9"! U, NathansonMichael4'& T<s\NadlerEitamar7$# S,NadlerAriel5"! N,LopezAnthony7#" MqZJonesAndy6  L<HoveCory8 G,yEsquivalJames9$#-~T'xOn>f?lBl@m@r ,11ShermanDrake5#" ,HeinEarly7  ,22ShibanoJon5!  , AlvarezKevin7#" ,~fRobisonAustin7$# ,22SzwaykowskiAlex7&%! ,SamuelsPhillip7%$ 00DwyerMathew5"! ,VopatBrandon7#" mCobosMarco7!  ,CampbellDaniel4%$ ,FerolinoAndrew4%$ ,iTLewandowskiLea9%$! ,KeyesBlair4!  ,""GonzalesAbraham4&% ,""VerdugoJesus7#" , OlfersZachary8$# u GrossMatthew5#" 6iTGianelliShane8$# ,SGianelliSam5"! ,11ChildressBill5$# ,iTCortesSophie9#" , GuillenSiera5#" CiTMcLeodIan8  K44PlourdeShawn7#" ,mLawrenceMylia7$# ,BryantChristine7&% ,vHornungTyler9#" ,vCarlisleBreeze9%$ ,vDominguezChristina9)( ,vRosemoreRandall7&% ,vFulbrightCasey6%$ ,vBraceroMaryellen6'& ,vDiazDaniella6#" ,vVanarsdalenKamuela6)(! ,vLechnerAlex8"! ,iTDiChristofanoNicholas5,+# ,iTSchererMatt4"! ,iMadridArron8"! ,~fGarciaAndrew6#" ,~fMcCreeryBrienne7&% ,~fRamirezDerek6#" ,~fEmoryKaitlyn7#" ,~fGarciaCristian8%$ ,~fRamirezMatthew9%$ .Y0 _7 d:jBqFoErGq ,u^CostelloNick4#" o%%CookTheo6 osChristophersonCory9)($ ChiversToby3"! yu^ButerbaughLucas4&%  %%ButerbaughIan6$#   BoocherAustin3$# ;BoehmJames5!  ,iTBirchAlexandra9%$ 8BernalZachary9$# HBhenkeChase6"! ==BegayBrenton5#" ,BadartBrady4"! *SAradhyulaSumhith3'& ,AlthauseKray5#" ,iTAl-OtaibiMishari9'& , RogersJake5!  , RogersRebecca6$# , JerdenChris7"! ,11SaundersEliza4$# ,PerrymoreKenny8%$ ,iTSanchezAndres9$# ,iTLopezBen9 4FarhatAlex9!  ,KenneyJackie9#" ,44ClarkAndrew9"! NqZTangJoseph8!  ,GarrisonMichael9&% 5DengAngela9!  ,FinellAustin7#" -GarrisonRJ9!  ,McGownRebecca7$# PeavyFletcher9$# dRandallC.J.9"! RobersonMalcam9%$ ZCobosApril9!  LangeJack9  FerolinoDaniel9%$ RobersonMalachi9&% {McGownJonathan9%$ HookBen9 ManethJacob9"! .VogelJohnny9"! SmootJonathan9$# ,SamuelsDerek7#" ,""GamezIsaiah7"!.\'yQ+^3]1a;f<g?m 7,iTCoatesMadeline7%$ 6,iTLongDavid8  5~iTPetersonKai8"! 4,iTZormeierCoty9#" 3,iTGlauserRichard9%$ 2,iTSmithSarah9!  1,iTDuncanPaige9"! 0,iTSandstedtClayton9'& /LiTBachnickiJoseph9&% .,iTKellerCaria9"! -,iTPerezGabby9!  ,,iTRamirezTyler9#" +8iTEstebanLinaya9$# (zJorgensenMichael6'& ',zMogerRyan6  &BzAltermanMark6#" %,GutierrezJosh9$# $,u^WhiteLeo4 ",iTVolkertsSydney9%$ !U TimambuloKoko7$# ,iTTalebAmer9  ,iTSnealCailyn4"! ,u^SmithDakota4"! sSchrieberSteve9%$ ,iTRiveraJohany5#" ,s\RemmeJefferson8%$ ,RemmeCharles7#" ,NewPriscilla5#" ,iTMuldowneyShane9%$ -MoncadaRafael9$# SiTMillerElias6"! ,iTMcNuttKatie6"! .MarquezMichael9%$ ,iTLowrieRyan9!  ,LohrAriel9  " LiuBrian3 ,iTLeonardZoe4!  ,iTLaursenKyle9"! <iTHilleTyler6!  ,HelinTori7  =iTGonzalez-PortilloGabriel7/.' ,iTGonzalez-PortilloChiara5.-' ,}eGarciaOlivia6#" , FeldmanEric4"! `iTDoucetIan6  00DietzmanRyan3#".~V(\3f8f<nApEnI!{ l-NelsonJoseph9#" j,44HardingShawn9#" iCSFrancisNiven4#" h,SDavisBrant5!  gMSZaepfelBen6!  fYLinAndy7 eoOlanderBrandon3%$ d, WeatherfordReece5'&! c,22MissimerChris5$# bs\BellJustin5!  ajqZForgachChris8#" `qZGafnerGabriel8$# _,YanesKaitlin7#" ^,KeatonAngel8"! ],MeyerClaudia5#" \,WarnerAllisen6$# [,""RosasGeorge4"! ZDCarrilloPatrick8&% Y,iTWattsMarissa8#" X,iTMcCollumBomani8%$ W,""CorralesGabe7#" V,22SiposRyan6  U,22HuXiangyu7  T722FergusonJack6#" S,~SchmidValissa8$# R0~OrozcoEddie8"! Q,nKowalskiRose4#" P,nRichardsAidan5$# O,iTSanchezRoxy8"! N,""MarriettaMichael7'& M,""CarrilloEli7"! L>~AndrewsSam5!  K,~JonesGreg7  IS""MorenoSteven7#" Hl""GastelumDavid7$# F, HubbleGrant4"! E,iTWarnerSydney8#" C,<<GregoryJames7#" B`ZaepfelJake8"! A,s\OwenJohnny8!  >8HuntDavid6  =,AndreattaGarrett6'& <iTHicksRicky7!  ;,iTLeonardNathan7$# :,iTShermanColin7#" 8,iTBauschkaKaitlin7&%&-V*T*Z1 b6e7g;`5  ,De La CruzIsrael9'&  ,iTMonroyDaniella8%$ ,~RisleyJosh8!  RosenSander4"! 11CroninMichael4$# ,nAndersonGregory4&% tsProvinceRyan7#" ,**CunninghamPatricia9)(  %%DhanabalAgni9#" ,MoralesJulio9#" ,iTCastilloAdrian9%$ ,GarciaAnthony9$# @%%MiljesicViktor9%$ R%%BernalJacob9"! ,**ArosAaron9  ,**TapiaTrevor9"! ,**MoralesChristina9'& ,**GomezLupita9"! ,WhaleyRene9!  ,MorenoStevie9#" ?iTMartinezJonathan9'& RitoAndres9!  ,**CampuzanoOscar9%$ ,**ShanksSteven9#" ,**FimbresLuis9"! 0**CazaresJulio9#" ,**SesmaVincent9#" ,**HarveyZion9!  ,**PerezArturo9"! ,SalcidoAlbert9$# ,FloresAlex9!  ~>RomeroMarty9"! },RobertsRuben9#" |,CarpioHector9#" {,BarkerGerald9#" y,iTGonzalesAaron9$# x<**ChavezCesar9"! w<LopezVictor B.9%$ v,LopezVictor R.9%$ t,iTAguilarJesse9#" s,RodriquezBrian9%$ r,CortezAlexander9&% q,ReyesJoshua9"! p,,,MillerKorey6"! n/GallegoAndrew9$#-{M%uKoGuK#yL#T(wM% , DavisMikey6!  , DavisAdam6  , CoppolaManuel6$# , BarbaMario7!  , AmadoIrvin7!  , AguilarMikey6#" ,nXGouldMeaghan5#" ,~SchmidBrandon4$# ,<<TownsendKyle4#" M%%Prescott-SmithJoshua6+*$ -mRichardsonJosh5%$  <mPlourdeSamuel5$# jGarciaJose8!  ,iTIrwinTaylor8"! ,iTHickeyJennifer8%$ ,s\DukartBen8  ,44WhaleyJered9"! C44VillasenorVince9&%  ,44McCabeRyan9!  ,44St. JohnJustin9%$ :44BrentJeremy9"! ]VillarrealCesar9&%  ,sFullerChet9!  eBrowneSimone4#" GBrowneSam6  ,Peskin-OwensEli7&%" ,CanfieldAriana4%$  BorenArianna3#" , CotterTess5!  ,iTGranerAlex4!  qMontillaIlan9#" dMadsonWilliam9$# ,}eWalsinghamKevin4&%   ModianoLauren3$# LPetersonChristian6(' ,<<SchafferMatt6#" ,JaramilloAlejandro9)( wQuirozMatthew9$# qBelloReilly8"! ,