Standard ACE DBnb` Ugr@?~1y0̝cßFN`7Bߜ( -`K{6߱hoC43+y[.|*|c]f_Љ$g'DeFx -bT4.0dv` Y`keb@S `` Y  b Y Y  Y Y  Y  kY  Y   Y b Y  Y @ Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeb@r@YYIdParentIdName        OY!S  `Y Y Y  Y 2ACMFInheritableObjectIdSID YObjectId Y--S  Y  Y Y Y  Y ` Y >Y  Y ,AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order,>, ,>Y"ObjectIdAttribute   -YS  Y Y Y  Y  Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship Ieee D,tNb YYYszObject$szReferencedObjectszRelationship v1b N  : k &  "$ K,I[ @@ @@ @@  @@ @ @@ @  Si`+^dMJmYdbkSi`+kfQMYQk+kQ^QMmSkoL+bQJiQkm+^dMJmYdbSkoL+dLkQiqJmYdbkSkoL+qYkYmkksYmMWLdJiO`dO+MoiiQbm+okQi ifm+kYmQk!ifm+kfQMYQk"`JM+Si`+^dMJmYdbk#`JM+Si`+kfQMYQk+kQ^QMm$`JM+ksYmMWLdJiO%JO`Yb&OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MSi`+^dMJmYdbk+kh+MSkoL+bQJiQkm+^dMJmYdb'+kh+MSi`+^dMJmYdbk+kh+MSkoL+qYkYmk(+kh+MSkoL+dLkQiqJmYdbk+kh+MkfQMYQk+YOS)+kh+MSkoL+qYkYmk+kh+MdLkQiqJmYdbk++kh+SSi`+^dMJmYdbk++kh+SSkoL+bQJiQkm+^dMJmYdb++kh+SSkoL+dLkQiqJmYdbk++kh+SksYmMWLdJiO++kh+iifm+kYmQk++kh+iifm+kfQMYQk+`kvkJMMQkkkmdiJUQ+`kvkJMMQkku`^+`kvkJMQk`kvkMd`f^QuMd^o`bk`kvkMd`f^QumvfQ+JmmJMW`Qbm`kvkMd`f^QumvfQ+OQMY`J^`kvkMd`f^QumvfQ+UoYO`kvkMd`f^QumvfQ+YQQQOdoL^Q `kvkMd`f^QumvfQ+YQQQkYbU^Q `kvkMd`f^QumvfQ+^dbU `kvkMd`f^QumvfQ+kWdim `kvkMd`f^QumvfQ+mQum`kvkMd`f^QumvfQ+obkYUbQOLvmQ `kvkY`QuMd^o`bk+ `kvkY`QukfQMk+ `kvkbJqfJbQUidofMJmQUdiYQk+ `kvkbJqfJbQUidofk+ `kvkbJqfJbQUidofmddL[QMmk+ `kvkbJqfJbQdL[QMmYOk+`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkhiv+Md`LYbQO+OJmJ+hiv+Md`fJiQ+OJmJ+Y`fdimQO+hiv+Md`fJiQ+OJmJ+iJs+hiv+Md`f^Qu+MiYmQiYJ+QuJ`f^Q+hiv+SdiQkm+kmJmk+hiv+SdiQkm+kmJmk+JqQiJUQ+OYSSQiQbMQ+hiv+SdiQkm+kmJmk+QJkm+hiv+Y`fdim+^dMJmYdbk+OJmJ+hiv+Y`fdim+dLkQiqJmYdbk+OJmJ+hiv+Y`fdim+kfQMYQk+OJmJ+hiv+Y`fdim+qYkYmk+OJmJ+hiv+Y`fdim+qYkYmk+OJmJ+:+hiv+YbOYqYOoJ^k+fQi+kYmQ+`Ju+hiv+YbOYqYOoJ^k+fQi+qYkYm+hiv+^dMJmYdbk+JbO+qYkYmk+hiv+`Ji\+Qufdim+hiv+`Ji\+Qufdim+8+hiv+`Ji\+Qufdim+:+ hiv+bQJiQkm+^dMJmYdb+!hiv+bo`LQi+dS+OQmQMmYdbk+Lv+kfQMYQk+"hiv+bo`LQi+dS+kfQMYQk+Lv+kYmQ+#hiv+difWJbQO+dLkQiqJmYdbk+$hiv+fJiJ`QmQi+hoQiv+QuJ`f^Q+%hiv+kfQMYQk+Lv+^dMJmYdb+JbO+SdiQkmhiv+kfQMYQk+Lv+kYmQhiv+kfQMYQk+Lv+kYmQ+iQfdimhiv+ofOJmQ+MdobmksYmMWLdJiOYmQ`kmL^+^dMJmYdbkmL^+dLkQiqJmYdbkmL^+iJs+OJmJmL^+iJs+OJmJ+:mL^+qYkYmk m^o+LYiO+MdOQk+qm m^o+kfQMYQk umJL+kfQMYQk+Lv+^dMJmYdb+JbO+SdiQkm `kvkOLko``JivYbSdokQiOQSYbQOmL^+^dMJmYdbkmL^+qYkYmkmL^+kfQMYQkmL^+dLkQiqJmYdbkmL^+qYkYmkmL^+dLkQiqJmYdbk  @ @ @ @ @ @ @ @ @ @ @ @      !"#$%&'()++++++++ +!+"+#+$+%+&+'+(+)+*+++,+-+.+/+0+ 1+!2+"3+#4+$5+%6789: ;<=     !#%',+V+[+ `+ d+ h+ m+ s+   v1a @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $%&'( ) * + , - . / 0 1 2 3 4 5 6 789:;<=>?@ABCDEFGHIJKLMNOP        !!!"""###$ $!$"%#%$%%&&&'&(')'*'+(,(-(.)/)0)1*2*3*4+5+6+7,8,9,:-;-<-=.>.?.@/A/B/C0D0E0F1G1H1I2J2233344455 5 6 6 6 777888999:/:0:1;2;3;4<5<6<7=8=9=:   !   "#$=>?789456123./0!+!,!-#(#)#*%:%;%<'%'&'',,,VVV[@[A[B`C`D`EdFdGdHhIhhmmmsss !"#$%&'()*+,-.  !"#v1X& ~"w{* z|))))))) ) )) ) )) ))))))))))))))))) )!))")$)%)& )')#)()*)+),)-).)/)0)1)2)))3)5)6)7)8)9):);)<)=)>)4)?)A)B)C)D)@ )E )G )H )I )J )K )L )M )N )O )P )Q w w w  w w w w )F!w!w !w !w !w !w !w!w!w!w!w!w! w!w!w"w"w"w"w"w"w"w"w"w"w "w#w!#w##w$#w%#w&#w'#w(#w)#w"$w*$w,$w-$w.$w/$w0$w+%w1%w3%w4%w5%w6%w7%w8%w9%w:% w;% w<%w2&w=&w?&w@&wA&wB&wC&y&y&y&y& y& y& y& y& y& y &w>'y 'y 'y 'y'y'y'y'y'y'y'y'y (y(y(y(y(y(y( y( y(y)y)y!)y")y#)y$)y%)y&)y')y()y)) y*) y+) y,) y-) y.) y/)y *y0*y2*y3*y4*y5*y6*y7*y8*y9*y:* y;* y<* z*y1y v1@ mL^+^dMJmYdbkmL^+qYkYmk!mL^+kfQMYQkmL^+dLkQiqJmYdbk!mL^+qYkYmkmL^+dLkQiqJmYdbk! mL^+dLkQiqJmYdbk!mL^+dLkQiqJmYdbk!mL^+qYkYmk!  mL^+^dMJmYdbk!mL^+qYkYmk!m^o+kfQMYQk!5*d _ Z  G q  0 =XF#A CR~)%Bbc@c@~s>c@>c@~sq_cfsub_Observations~sq_cSpecies_IDF4MR2KeepLocal Tnnnnnnnl @Ec@"Ec@~sq_cfrm_Locations~sq_cfsub_Visits4MR2KeepLocal Tfffffffd @ mb@ŀac@Admin@8,,,,,,,,,* v,Nc@ Oc@mac_SwitchboardZ@LLL@@@@@@@> @زc@زc@mac_frm_Species_SelectNNNNNNNNNNL A6ʟc@c@mac_frm_Locations@PPPDDDDDDDB @?yc@c@rpt_Sites.@@@@44444442 @ξc@ξc@mod_Current_UserBBBBBBBBBB@  h03c@h03c@SwitchboardF@DDD88888886 @ >}gzc@>}gzc@fsub_VisitsT@DDD88888886 @ >8|c@>8|c@fsub_ObservationsJ@PPPDDDDDDDB @ F6c@F6c@fsub_Nearest_Location@XXXLLLLLLLJ @ I=oc@I=oc@frm_Species_Select<@RRRFFFFFFFD @  rkeb@rkeb@UserDefinedύ@DDD88888886 @ rkeb@rkeb@SummaryInfol@DDD88888886 @rkeb@rkeb@SysRel.........., rkeb@rkeb@Scripts0000000000. rkeb@rkeb@Reports0000000000. rkeb@rkeb@Modules0000000000. rkeb@rkeb@Forms,,,,,,,,,,* rkeb@rkeb@DataAccessPages@@@@@@@@@@> 'keb@keb@MSysComplexType_AttachmentTTTTTTTTTTT %keb@keb@MSysComplexType_TextHHHHHHHHHHH #keb@keb@MSysComplexType_DecimalNNNNNNNNNNN !keb@keb@MSysComplexType_GUIDHHHHHHHHHHH keb@keb@MSysComplexType_IEEEDoubleTTTTTTTTTTT keb@keb@MSysComplexType_IEEESingleTTTTTTTTTTT keb@keb@MSysComplexType_LongHHHHHHHHHHH keb@keb@MSysComplexType_ShortJJJJJJJJJJJ keb@keb@MSysComplexType_UnsignedByteXXXXXXXXXXX keb@keb@MSysComplexColumnsDDDDDDDDDDD keb@keb@MSysRelationshipsDDDDDDDDDDB keb@keb@MSysQueries88888888886 keb@keb@MSysACEs22222222220 keb@keb@MSysObjects88888888886 keb@c@MSysDbϕ@(:::......., @keb@keb@Relationships<<<<<<<<<<: keb@keb@Databases44444444442 keb@keb@Tables.........., D YxN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDxYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@    fYTʿgNY  ValuedvfYTʿgNY  ValuedvfYTʿgNY  ValuedvfYTʿgNY  ValuedvfYTʿgN  Y  ValuedvfYTʿgN""Y  ValuedvfYTʿgN$$Yg ValuedvfYTʿgN&& Y g ValuedvaYxN(( Y Y  Y Y  Y  Y FileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b1R~T* T z \ > T 6  @  T 6  X :  lB} Gu.tV8bD&j,e$ tbl_Visits.Visit_Date4 g tbl_Visits.Visit_Time4 g tbl_Locations.Y_Coord4 g tbl_Locations.X_Coord4 g tbl_Locations.Location_ID8 g tbl_Observations111  tlu_Species'''  tbl_Visits%%%  tbl_Locations+++   G  G    Gbl_X7YZ_____2@*1% 7bl_X7YZ_____1@*1% 7l_ G l_ Gbl_ l_ Gtlu_Speciesqry_Species_by_Site_Reportz@*g[' [tlu_Species].[Species_ID]9 g[tlu_Species].[Common_Name]: gR@* gR@* gL@* gL@ * gT@ * gqry_Species_by_Site_ReportEEE tlu_Species'''   Gtlu_Speciesqry_Species_by_Site_Reportz@ *g[' [tlu_Species].[Common_Name]: gR@ * gR@ * gL@* gL@* gT@* gqry_Species_by_Site_ReportEEE tlu_Species'''   G [ItemNumber]+ 'r@* 'Switchboard Items333  G  Gtbl_Observations111   G  GH@* gB@* gqry_Nearest_Location999   Gtbl_Locations+++   G  G([__Visit_ID] = Visit_IDF)9 'tbl_Observationsfsub_VisitsGG1   G__Visit_ID%%% O  Groltlu_Species'''  ol Grol ol G"([__Location_ID] = Location_IDF)? 'frm_Locations@*7+ 7  G__Location_ID+++ O  GH@* gB@* gqry_Nearest_Location999   GLVALvl$ ^  t " T  j  n >(((tbl_Observations.Species_IDF)="CORA")) OR (((tbl_Observations.Species_IDF)="AMCR") AND ((tbl_Visits.Count)=2)) OR (((tbl_Observations.Species_IDF)="RWBL") AND ((tbl_Visits.Count)=1))tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDF(((tbl_Raw_Data.[How Detect])<>"F"))tbl_Visits.Visit_ID = tbl_Observations.Visit_IDFtlu_Species.Species_ID = tbl_Observations.Species_IDFtbl_Locations.Location_ID = tbl_Visits.Location_IDFSELECT tbl_Raw_Data_2.Site_Station AS Location_ID, tbl_Raw_Data_2.Date AS Visit_Date, tbl_Raw_Data_2.[Time Started] AS Visit_Time, tbl_Raw_Data_2.Wind, tbl_Raw_Data_2.Sky, tbl_Raw_Data_2.Species AS [Species IDF], tbl_Raw_Data_2.Observer FROM tbl_Raw_Data_2SELECT tbl_Locations.Location_ID, tbl_Visits.Visit_Date, tbl_Visits.Visit_Time, tbl_Visits.Wind, tbl_Visits.Sky, tbl_Observations.Species_IDF, "Wilson" AS Observer FROM (tbl_Locations INNER JOIN tbl_Visits ON tbl_Locations.Location_ID = tbl_Visits.Location_IDF) INNER JOIN tbl_Observations ON tbl_Visits.Visit_ID = tbl_Observations.Visit_IDF; tlu_Species.Species_ID=qry_Species_by_Site_Report.Species_IDF[qry_Species_by_Site_Report].[Visit_Time][qry_Species_by_Site_Report].[Visit_Date][qry_Species_by_Site_Report].[Y_Coord][qry_Species_by_Site_Report].[X_Coord][qry_Species_by_Site_Report].[Location_ID]tlu_Species.Species_ID=qry_Species_by_Site_Report.Species_IDF[qry_Species_by_Site_Report].[Visit_Time][qry_Species_by_Site_Report].[Visit_Date][qry_Species_by_Site_Report].[Y_Coord][qry_Species_by_Site_Report].[X_Coord][qry_Species_by_Site_Report].[Location_ID][ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID[qry_Nearest_Location].[Location_ID][qry_Nearest_Location].[Distance]SELECT tbl_Visits.* FROM tbl_Visits WHERE (((tbl_Visits.Count)=[forms]![frm_Locations]![grp_Visit]))[qry_Nearest_Location].[Location_ID][qry_Nearest_Location].[Distance]T&OYNM` I }  D IH BG}EeieCm?;A5c@c@qry_Parameter_Query_Examp5K̖c@*<c@qry_Parameter_Query_Exampleϋ@@pddXXXXXXXV @3nc@A}rc@qry_Number_of_Species_by_Site@|@thh\\\\\\\Z @2C(c@$܌ c@qry_Number_of_Detections_by_Species@@ tthhhhhhhf @18cc@Wc@qry_Nearest_Location@|@ bVVJJJJJJJH @0Qc@@bc@qry_MARK_Export_2@@ \PPDDDDDDDB @.xec@"c@qry_MARK_Exportw@ |@ XLL@@@@@@@> @- M}c@Wхc@qry_Locations_and_Visits@ @ j^^RRRRRRRP @,7".~c@G0~c@qry_Individuals_Per_Visit@ @ l``TTTTTTTR @+W9~c@f>~c@qry_Individuals_Per_Site_Maxm@ |@ rffZZZZZZZX @)gb@=e[c@@qry_Import_Visits_Data7@|@fZZNNNNNNNL @(Awb@[c@@qry_Import_Species_Data)@|@h\\PPPPPPPN @'K_b@,[c@@qry_Import_Observations_Dataϒ @@rffZZZZZZZX @&.Jb@!][c@@qry_Import_Locations_Data9@|@l``TTTTTTTR @$S tߛc@0c@qry_Forest_Stats_Average_Difference@@tthhhhhhhf @#Uc@Sc@qry_Forest_Stats@|@ZNNBBBBBBB@ @"=c@{ c@qry_Complex_Criteria_Exampleu@@rffZZZZZZZX @!&b@n7ժ[c@qry_Compare_Data_Raw @|@bVVJJJJJJJH @HEb5c@_8c@qry_Combined_Data@@\PPDDDDDDDB @sBeb@Beb@ MSysNavPaneObjectIDsJJJJJJJJJJH mLkeb@Lkeb@ MSysNavPaneGroupToObjectsTTTTTTTTTTR hLkeb@Lkeb@ MSysNavPaneGroupsDDDDDDDDDDB drkeb@rkeb@ MSysNavPaneGroupCategoriesVVVVVVVVVVT `1b@1b@MSysIMEXSpecs<<<<<<<<<<: [1b@1b@MSysIMEXColumns@@@@@@@@@@> V%b@%b@MSysAccessXML<<<<<<<<<<: ,keb@keb@ MSysAccessStorageDDDDDDDDDDB c@c@~sq_rrpt_Species4MR2KeepLocal TBBBBBBB@ @ 03c@@03c@~sq_fSwitchboard4MR2KeepLocal TBBBBBBB@ @ c@ c@~sq_ffsub_Nearest_Location4MR2KeepLocal TVVVVVVVT @6c@6c@~sq_ffrm_Locations4MR2KeepLocal TFFFFFFFD @V YTTN--HIHI**Y  Y Y  Y , Y ,>Y >Y DateCreateDateUpdateIdLvNameParentIdType>,>,>-S,>,>,>-T,>,>,>-U,>YYYIdParentIdIdParentIdName--v1b   @ F,4@c$ o q ( =  A W Aq,Bm(>Lh03c@}+Tc@wBlobDeltat0,( wgb03c@}+Tc@vH@=TypeInfot:62" gb03c@G+Tc@u0Af0Blobt2.*" gb03c@G+Tc@t4  w~xc@xc@W% 0CB1 1CB1 2CB0PropDataCopygc_G 6c@Y c@D PropData@GC?/ F6c@Y c@CBlobDelta@0,( wF6c@Y c@B@5TypeInfo@:62" F6c@Y c@A#>f0Blob@2.*" @6c@Y c@@3  wA6ʟc@Kc@7 @=Blob62.*"  0ʟc@Kc@62  wVDc@ZVc@% 0CB0 2CB0 1CB0PropData_[WG VDc@VcDc@Macro1DirDataCopyXTP8 Wc@#زc@@5DirData:62" 78|c@@c@ PropDataGC?/ >8|c@@c@BlobDelta0,( w>8|c@@c@@5TypeInfo:62" >8|c@@c@(:f0Blob2.*" >8|c@@c@2  w>}gzc@c}>c@h PropDatadGC?/ >}gzc@c}>c@gBlobDeltad0,( w>}gzc@c}>c@fh@5TypeInfod:62" >}gzc@c}>c@e46f0Blobd2.*" >}gzc@c}>c@d1  wGzc@Gzc@c@frm_Locationsfsub_VisitsDirDataCopy~zb Gzc@Gzc@b 0CB0 1CB0PropDataCopy\XT< #]c@10c@TF@5PropData:62" 7(]c@M c@P PropDataKGC?/ 7(]c@[=oc@O@5DirData:62" 7(]c@M c@NBlobDeltaK0,( w7(]c@M c@M@5TypeInfoK:62" 7(]c@M c@LS/f0BlobK2.*" 7(]c@M c@K0  w fb@(c@VBA$  w fb@(c@VBAProject2.* wLkeb@Lkeb@MSysDbDirData PLH8 rkeb@rkeb@ImExSpecs0,( wrkeb@rkeb@CustomGroups62. wrkeb@rkeb@ Blob &" wrkeb@rkeb@ 0   wrkeb@Lkeb@ Databases0,( wrkeb@rkeb@ DataAccessPages<84 wrkeb@rkeb@ Cmdbars,($ wrkeb@(c@VBA$  wrkeb@ZVc@Scripts,($ wrkeb@;Pc@Modules,($ wrkeb@)P c@Reports,($ wrkeb@10c@Forms($  wrkeb@ fb@ijPropDataPLH8 rkeb@rkeb@MSysAccessStorage_SCRATCHPLH wrkeb@ fb@MSysAccessStorage_ROOTJFB wLVALf00:u07=5B>a)b*c1e g+l7(]c@x [l8Bc@fsub_Visitsh&D,JVwX&Mc@\/tbl_Visits.e<0WE\-h&D,JVwX&Count[l8BWL+%C쌆Grassland_Percent_(-ˀNTQa+%C쌆Developed_Percentc#tOp=@ +%C쌆X_Coord$miSKO6:wj +%C쌆Y_Coord71.NA~~f[l8B> NY<{38c@fsub_Nearest_Location  tbl_LocationsU <mac_frm_Locations.Last_Updated @Calibri 8hhhh h ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P1LVAL11D/1<FP d2d# " @Calibri    g23I6Y75    i1g4h5    k1    mfg4i# " @Calibri     p    `,d$ FormHeaderx IPBgd5U7`6:a<bw/c,(d#ghjk! Auto_Title0 &Bird Count Database" @Segoe UIx 4T{2H0퉑&X  J:K<L/Md`,  Detailx B!@^IPț p3`6@ a b c,d  *fsub_Nearest_Location 4Form.fsub_Nearest_Locationx tGַF?GVNzJ@ K L`'M d5]`6@ a0 bc,; 6fsub_Nearest_Location Label *fsub_Nearest_Location 6fsub_Nearest_Location_Labelx {&'fKgOJ@ K0 LMk m7U;F{`6< a<bc,mnpq Location_ID Location_ID Primary Keyx LVAL2!IJ/Z{' +.J< /K<0L, 1Md5U7`6ha<bc,ghjk!  Label1 Site ID:x vpIٚ JhK<L Mm0G7U;F{`6< abc,hkmnpq Forest_Percent Forest_Percent&  Fixed *% forest within 300 mx 71.NA~~f +.J< /K0L, 1Md5U7`6habc,hghjk!  Label3 Percent Forest:x @q2E\K#e JhKL Mm0G7U;F{`6< aDbc,hkmnpq "Grassland_Percent "Grassland_Percent&  Fixed 0% grassland within 300 mx anV6M=) +.J< /KD0L, 1Md5U7`6haDbc,hghjk!  Label5 $Percent Grassland:x ک:H2}0{ JhKDL Mm0G7U;F{`6< abc,hkmnpq "Developed_Percent "Developed_Percent&  Fixed 0% developed within 300 mx ^4O_ +.J< /K0L, 1M_ d5U7`6habc,hghjk!  Label7 $Percent Developed:x 8+S±AIi@4 JhKL M_ m7U;F{`6< aLVAL3+bc,hkmnpq X_Coord X_Coord >East coordinate, VT state plane 8mac_frm_Locations.Dist_Checkx >qO% +.J< /K+0L, 1Md5U7`6ha+bc,hghjk!  Label9 X Coordinate:x A=y{|1N2x JhK+L Mm7U;F{`6< abc,hkmnpq Y_Coord Y_Coord @North coordinate, VT state plane 8mac_frm_Locations.Dist_Checkx |)B  +.J< /K0L, 1MFd5U7`6habc,hghjk! Label11 Y Coordinate:x  ٕf@1!qM JhKL MFm80G7;F{`6< a bc,kmnpq Hab_Total r=[forest_percent]+[grassland_percent]+[developed_percent]&  Fixed Primary Keyx 0p$EO +.J< /K 0L, 1MN d5U7`6ha bc,ghjk! lbl_Hab_Total Total Percent:x t2ɒ@kK9Y JhK L MN p3`6ahbc,d fsub_Visits  Form.fsub_Visits1 Location_IDF2 Location_ID Bmac_frm_Locations.Loc_Orphan_Warnx KJi-SJKhL%Md5]7`6a<bc,wghjkLVAL4! "fsub_Visits Label  Visits "fsub_Visits_Labelx ?pANl1LJK<LXMk5U`6(a\ bc,i grp_Visit 1x %A(CDs33JbUpdate data displayed on fsub_Visitsfsub_Visits!J("K\ #L $MUd25`6a bc,; Label28  Visitx i x FNjRvJK LMi2W`6aJ: Option30x tw"Et/%J&KJ'L(M:d5`6a.bc,; Label31 Visit 1x XHI`@JK.LM Mii2W`6a: Option32x N ILɑ%J&K'L(Md5`6axbc,; Label33 Visit 2x 6otYJuxJKxLM Mi2W`6a: Option34x 2ݭi;G#  %J&K'L(Md5`6abc,; Label35 Visit 3x v2_iK+ !JKLM Mm7F{`6ac,;k  Last_User Last_User BLast person to modify this recordx W:V@)Q+.J/K0LL1Md5]`6ab c,; Label40 0Person Modifying Record:x  ɗ08HigJeMJKL@ Mm7UF{`6a(c,;k  Last_Date Last_Date& Short Date BDate the record was last modifiedx ϙE2c4+.J/K(0LL1Mcd5U`6a(bc,; La LVAL bel41 Date Modified:x [OSEpzzJK(LbMcm7UF{`6ac,;k  Last_Time Last_Time& Short Time BTime the record was last modifiedx fbuG`r~+.J/K0LL1Md5U`6abc,; Label42 Time Modified:x emwjC9LŇJKLM`, FormFooterx _UB%N9;LVAL ^ t @$> 3316:RrExportExport data to MARK2MARK_Exportqry_MARK_Export="c:\temp\" & [Forms]![frm_Species_Select]![Species] & ".txt"0 pRun Notepad to view the export (could run MARK instead)="c:\windows\notepad.exe c:\temp\" & [Forms]![frm_Species_Select]![Species] & ".txt"ͬ.cTOILs/Detailo/Speciesd /Species_Labelh /Command2ͬ7Lwv/PageHeaderSection/Detail/PageFooterSection/ReportHeader/ReportFooter/GroupHeader0m/Location_IDd/Location_ID_Labelm/Visit_Dated/ Visit_Date_Labelm/ Visit_Timed/ Visit_Time_Labelm/ Common_Named/ Common_Name_Labelm/X_Coordd/X_Coord_Labelm/Y_Coordd/Y_Coord_Labeld/Label12m/Text13m/Text14/GroupFooter1m/Text15d/Label16ͬN H3< ۙ/FormHeader/Detailm/Distanced /Distance_Labelm/Location_IDd /Location_ID_Label/FormFooter"mac_Switchboard&mac_frm_Locations0mac_frm_Species_Selectͬ }6+E[GMo/Detailm/Observation_IDd /Label1m/Visit_IDFd /Label3m/Detect_Timed /Label7o/Species_IDFd /Label5o/ Detect_Typed / Label9ͬkivoLi3/FormHeaderd /Label5d /Label7d /Label9d /Label11d /Label13/Detailm/Visit_Timem/Visit_Datem/ Windm/ Skym/ Countp/ Observationsd / Observations_LabelObservations Label/FormFooter/Visit_ID/Location_IDF 4CB0 2CB0 1CB0 0CB0 3CB0 5CB0Switchboard&fsub_Observationsfsub_Visitsfrm_Locations.fsub_Nearest_Location(frm_Species_Selectͬ$&%D=1!-q"/Detail/FormHeader/FormFooterd /Auto_Title0m/Location_IDd /Label1m/Forest_Percentd /Label3m/ Grassland_Percentd / Label5m/ Developed_Percentd / Label7m/ X_Coordd /Label9m/Y_Coordd /Label11m/Hab_Totald /lbl_Hab_Totalp/fsub_Visitsd /fsub_Visits_Labelfsub_Visits Labeld /Label28i/Option30d /Label31i/Option32d /Label33i/Option34d /Label35k/grp_Visitp/fsub_Nearest_Locationd /fsub_Nearest_Location_Labelfsub_Nearest_Location Labelm/Last_Userd / Label40m/!Last_Dated /"Label41m/#Last_Timed /$Label42LVALf07 ^ _ a/:u027?8B>a)b*cLe g =forms!l)c@x ř۸hK~IWy  Uh&D,JVwX&Mc@\<tbl_Visits.e<0WE\-h&D,JVwX&Count[l8BCount number (visit 1, 2, or 3) H=[Forms]![frm_Locations]![grp_Visit]x {xbIBǺ.Gv  '+.J4/K%0L1M2p3`6a LVAL bc, d Observations ,Form.fsub_Observations1 Visit_IDF2 Visit_ID Bmac_frm_Locations.Vis_Orphan_Warnx QFg1ZA6JKLMd5]7`6abc,wghjk! $Observations Label Observations $Observations_Labelx W#JF.`  JKL5M`, FormFooterx Շ֠@ N7>LVALf0;:u07=5B>a)b*c3.e g l>8|c@x w|D y  USR4B"ND:Nc@@KHstbl_ObservationsW.N2}VSR4B"ND:Observation_IDX0;%OlgHSR4B"ND:Visit_IDF!EIS18 SR4B"ND:Detect_Time9DN # SR4B"ND:Species_IDFT;K3!LaGNc@tlu_Species"hB"MSR4B"ND:Detect_Type   tbl_Observations @Calibri 8hhhh h ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P11D/1<FPd2d# " @Calibri    mfg4i# " @Calibri     LVAL<oj4l# " @Calibri     *,-8`,   Detailx ,4ծ@9/m87U;F{`6ahb@&c,ge mnpq Observation_ID Observation_ID Primary Keyx M񳫄AϾ`E+.J/Kh0L-1Md5U7`6hahbc,gghjk!  Label1 IDx LCJO*&p~o JhKhLpMm7U;F{`6ab@&c,gkmnpq Visit_IDF Visit_IDF ,Foreign key, tbl_Visitx  =?Gsν噙+.J/K0L-1Md5U7`6habc,gghjk!  Label3 Visit IDx O0w,LL bGJhKLpMm7U;F{`6a~b@&c,ge)kmnpq Detect_Time Detect_Time nTime detected during count; 11 = incidental observationx Ώ떺A"6+.J/K~0L-1Md5U7`6ha~bc,gghjk!  Label7 Timex 2K3HxdXJhK~LpMoC5U9D{`Fbc6de@&f,gh)nZ X"Species Code";">";"Common Name";"";"10";"8"x LVALq?>"OV_* Species_IDF Species_IDF] Table/Query[ tlu_Species 864;2880 ^Foreign key, tbl_Species; bird species detected./0126J7K8L-9M3d5U7`6habc,gghjk!  Label5 Speciesx )bZKѭ"JhKLpM3oC0\5U9D{`Fbc6d0e@&f,gh)nx 96$KcX0 Detect_Type Detect_Type] Value List[ &A;Auditory;V;Visual  0;1008 ,(V)isual or (A)uditory& >./0126J7K08L-9M d5U7`6ha0bc,gghjk!  Label9 Typex E&bHZVvJhK0LpM LVAL ͬ6v~~oKms, /PageHeaderSection/Detail/PageFooterSection/ReportHeader/ReportFooter/GroupHeader0/GroupHeader1m/ Visit_Dated/ Visit_Date_Labelm/ Visit_Timed/ Visit_Time_Labelm/ X_Coordd/X_Coord_Labelm/Y_Coordd/Y_Coord_Labeld/Label12m/Text13m/Text14/Species_IDm/Common_Namem/Location_IDd/Label15d/Label16 33$RVnrClose_SwitchboardClose switchboard form2Switchboard0&FRVToggle_PaneToggle Navigation Pane{F11}0ͬ`wgKNG/z/Detail/FormHeader/FormFootere/VerticalShadowBoxg/Pictureh /Option1m/OptionLabel1e/HorizontalHeaderBoxd /Label2d / Label1/ SwitchboardID/ ItemNumber/ ItemText/ Command/Argument33 v4:>\Loc_Orphan_WarnPrint error message if Location_ID is null[Location_ID] Is NullYou must enter data about the location before entering visit information-14Orphan Warning ^fGo to a control on frm_Locations to enter data...[Location_ID] p"@Vis_Orphan_WarnPrint error message if Visit_ID is null[Visit_ID] Is NullYou must enter data about the visit before entering observations-14Orphan Warning Zb|Go to a control on fsub_Visits to enter data...[Visit_Time]R~Dist_CheckRequery fsub_Nearest_Locationfsub_Nearest_LocationpvzDisplay warning if location is within 400 meters of an existing location[fsub_Nearest_Location]![Distance]<400="Location " & [fsub_Nearest_Location]![Location_ID] & " is only " & FormatNumber([fsub_nearest_location]![distance],0) & " meters from this location. Locations should be at least 400 meters apart."-13Distance Warning Go to Location_ID because can't go to X_Coord if just leaving that control...Location_ID ,4DGo to X_Coord control...X_Coord( zLast_UpdatedStore most recent user to make change to record[Last_User]fOSUserName()( BZhStore Date of most recent change[Last_Date]Date()(BZhStore Time of most recent change[Last_Time]Time()LVALf0?:u07=5B>a)b*ce gl6c@x >> NY<{3y t U?A@^Wc@\=qry_Nearest_LocationEX4.?A@^Distance.BPdC\jB?A@^Location_IDDistanceLocation_ID  SELECT [qry_Nearest_Location].[Distance], [qry_Nearest_Location].[Location_ID] FROM qry_Nearest_Location;  *fsub_Nearest_Location @Calibri1D/1<FPd26d# '\" @Calibri    e2'    f'    g26Y75'    h4g# h%'" @Calibri    ig4h5'    jg4h5    k2'    l0Y:g4'    mf:LVAL@g4i# '" @Calibri     n6h4j# '" @Calibri     $,'8o8j4l# '" @Calibri     *,-8p'    r45I'    w4I'    z4i# j%'" @Calibri    {2d# " @Calibri    ~278bc,'    .4`,' FormHeaderx Ӛݫg!B/}ESG`,  Detailx TNEִ ;m7U;F{`6@ ahbLc,Je  Distance Distancex S)hA<@+.J@ /Kh0L1Md5U7`6hahb c,J Distance_Label Distancex Cu P[L[woJ LVAL hKhL Mm7U;F{`6@ abLc,Jek Location_ID Location_ID Primary Keyx X FMV+.J@ /K0L1MGd5U7`6hab c,J "Location_ID_Label Site IDx hyaDW M7JhKL MG`, FormFooterx T^]G-LVALf0B$:FSu27=5B>a)b*c<e gj=k : l03c@x  ؒA"&Gy  U~kN, n03c@)tc/Switchboard ItemsCm]D*O}%7~kN, ItemNumber ϮA>_g~kN, SwitchboardID=[Argument]=[Argument]=[Argument]ItemText  SELECT * FROM [Switchboard Items] WHERE [ItemNumber]>0 And [SwitchboardID]=TempVars!SwitchboardID ORDER BY [ItemNumber];  Switchboard @Calibri1N7 33L$>CurrentItemNumber[ItemNumber]Y33LSwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")FLabel19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))FLabel29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))D/1<FPd2d# " @Calibri    e12    g23I6Y75    hg# h%" @Calibri    mfg4i# " @Calibri     LVALC`, FormHeaderx Mȋn QH]{{e125]bc, &HorizontalHeaderBoxx ,Q:AH'8LMd5`6 ab:c,d#  Label2  Main Switchboard" @Segoe UIx mDi8J KLMd5`6 ab:c,d#  Label1  Main Switchboard" @Segoe UIx mOymLųtܫJ KLMl`,  Detailx ^);[qK 5e123I5U`63 bzc, "VerticalShadowBoxx mKU)J3 L Mh1U`6 aPbc,g#  Option1" @ Systemx eBțp^x 33I1ErrorHandlerL4J[Command]=1SwitchboardID[Argument]F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-... 048<[Command]=2=[Argument]000- ... 04:>[Command]=3=[Argument]0-10- ....048[Command]=4=[Argument]50-...: [Command]=5521L$...SwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-...C[Command]=6-...LVALD"0[Command]=7=[Argument]-...!>[Command]=8=[Argument] & "()"- ..." &*Unknown option.-10$RX\ErrorHandler=[MacroError].[Description]-10!%J &KP'L (MSm85I7UCF{`6> aPbi#k OptionLabel1 ItemText" @ Tahomax "0QIV5m(x 33I1ErrorHandlerL4J[Command]=1SwitchboardID[Argument]F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-... 048<[Command]=2=[Argument]000- ... 04:>[Command]=3=[Argument]0-10- ....048[Command]=4=[Argument]50-...: [Command]=5521L$...SwitchboardIDDLookUp("SwitchboardID","Switchboard Items","[ItemNumber] = 0 AND [Argument] = 'Default'")F...Label19=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))F...Label29=DLookUp("ItemText","Switchboard Items","[SwitchboardID] = " & TempVars("SwitchboardID"))...-...C[Command]=6-..."0[Command]=7=[Argument]-...!>[Command]=8=[Argument] & "()"- ..." &*Unknown option.-10$RX\ErrorHandler=[MacroError].[Description]-10+.J> /KP0L1M@g26Yb} c, Picturex ~_ jiiOԹo>L} M!`,hLVAL FormFooterx 8HwHGp+ݾ,,s.i& G h  ~ K  v  q  DDDDDDDDDDDDDnR(c@(c@Tn@'PROJECT840" (c@(c@S5mod_Current_Usermod_Current_UserPROJECTwmqmiW (c@(c@Ra@'dir0,(" (c@(c@Q& @Q_VBA_PROJECTB>:" (c@(c@P6 @'LDXOBUHLHPVTGEWYYYQAEMASDFLIb^Z" (c@(c@O AcessVBADataNJF. ;Pc@;Pc@ 0CB0PropDataIEA1 c@c@*$mod_Current_UserDirDatad`\L c@c@ PropDataGC?/ WȾc@c@0  wزc@!j$c@|@ 5Blob2.*" زc@!j$c@1  wa=oc@T2c@ PropDataGC?/ I=oc@8c@BlobDelta0,( wI=oc@8c@j@5TypeInfo:62" I=oc@T2c@TPf0Blob2.*" B=oc@T2c@5  wyc@p

a)b*c-e gjw.k ;lmc@x lۗ Dtgy  UT;K3!LaGvc@Zxc/tlu_SpeciesEG`SH/Lw̜ŜqMc@Zxc/qry_Species_by_Site_Report=_K EG`SH/Lw̜ŜqLocation_IDx4 eKQhEG`SH/Lw̜ŜqX_CoordO:VjJ]7cDEG`SH/Lw̜ŜqY_Coord"}A;pM~EG`SH/Lw̜ŜqVisit_DateQ]m%8`J ɀ(FEG`SH/Lw̜ŜqVisit_Timei<+J>֍T;K3!LaGCommon_Name9iSXiDVT;K3!LaGSpecies_IDKPB EG`SH/Lw̜ŜqSpecies_IDFz3ZIɷQh&D,JVwX&Visit_Date3! Fs&h&D,JVwX&Visit_Timec#tOp=@ +%C쌆X_Coord$miSKO6:wj +%C쌆Y_CoordQ1 0LXHO+%C쌆Location_ID  SELECT [qry_Species_by_Site_Report].[Location_ID], [qry_Species_by_Site_Report].[X_Coord], [qry_Species_by_Site_Report].[Y_Coord], [qry_Species_by_Site_Report].[Visit_Date], [qry_Species_by_Site_Report].[Visit_Time], [tlu_Species].[Common_Name], [tlu_Species].[Species_ID] FROM tlu_Species INNER JOIN qry_Species_by_Site_Report ON tlu_Species.Species_ID=qry_Species_by_Site_Report.Species_IDF;  rpt_Species @Calibri 8hhh-hh ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetLVALHXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P11D01<FPd26d# e%PM\" @Calibri    'e   'f1IPM   'g6Y75   'h4g# h%'" @Calibri    'i5Ig4h5PM    'jg4h5    'k3IPM    l0Y3I:g4PM    'mf5I:Cg4i# PM" @Calibri     'n6=Ih4j# PM" @Calibri     '$,'8o3I8Aj4l# PM" @Calibri  LVALI   '*,-8pPM    'r4PM     'w4IPM    'z4i# j%'" @Calibri    '{25d# " @Calibri    ~23I78bc,PM   '.40K Species_ID Location_ID Visit_Date Visit_TimeK`, ReportHeaderx 9[" FĺK;d68`6<a<b c, d# Label12 "Species Sightings" @Cambriax HܰT< J<K<L MI`, "PageHeaderSectionx _f $@CBjTd27`6ya<bc,'  Visit_Date_Label Date  DetachedLabelx Dk ZO qb~ JyK<LG"MJd27`6"a<bc,'  Visit_Time_Label Time  DetachedLabelx ÃHJ"LG\ J"K<L&MJd27`6a<bc,' X_Coord_Label East  DetachedLabelx  #EGlT JK<L`MJd27LVALJ`6a<bc,' Y_Coord_Label  North  DetachedLabelx zMzBN JK<L=MJd257`6Ya<b? c,' Label15 Common Namex )9ҽD7f JYK<L MJd27`6 a<bc,' Label16 Locationx V EF0;y J K<LMJK`, GroupHeader0x 6t-:C̾'< ;K`,a GroupHeader1x w(<,X3F28; ;K`,h  Detailx 79OOOlo? ;m;F{`6yabc, Visit_Date Visit_Date& Short Date Date of countx y)}(A~+.Jy/K0LG"1M,m;F{`6"abc,k Visit_Time Visit_Time& Short Time Time of countx X0Պ Bio+.J"/K0L&1M,mE;F{`6abc,k X_Coord X_Coord >East coordinate, VT state planex ]6BqNH葅b+.J/K0L`1M,mE;F{`6abc,k Y_Coord Y_Coord @North coordinate, VT state planex l,F8 A+.J/K0L=1M,mE;F{`6Yab? c,k Common_Name Common_Name 0AOU accepted common namex 1?N&`v+.JY/K0L 1M,mE;F{`6 abc,k Location LVAL _ID Location_ID Primary Keyx S[Z~Aë:Ġ+.J /K0L1M,`, "PageFooterSectionx V1C B=m;F{`6<abc,i#  Text13  =Now()& Long Datex ֢NAD+.J</K0L1Mm;F{`6abc,i#k  Text14 H="Page " & [Page] & " of " & [Pages]x ,2NPKGW+.J/K0L,1MK`, ReportFooterx Йӛ(OLVALf0L:u7:<=5B>a)b*c-e gj֍T;K3!LaGCommon_Name9iSXiDVT;K3!LaGSpecies_IDKPB EG`SH/Lw̜ŜqSpecies_IDFQ1 0LXHO+%C쌆Location_IDz3ZIɷQh&D,JVwX&Visit_Date3! Fs&h&D,JVwX&Visit_Timec#tOp=@ +%C쌆X_Coord$miSKO6:wj +%C쌆Y_CoordF_Dr9)o­O)osCommon_Name  SELECT [qry_Species_by_Site_Report].[Location_ID], [qry_Species_by_Site_Report].[X_Coord], [qry_Species_by_Site_Report].[Y_Coord], [qry_Species_by_Site_Report].[Visit_Date], [qry_Species_by_Site_Report].[Visit_Time], [tlu_Species].[Common_Name] FROM tlu_Species INNER JOIN qry_Species_by_Site_Report ON tlu_Species.Species_ID=qry_Species_by_Site_Report.Species_IDF;  rpt_Sites @Calibri 8hhh-Jh ,卵 o,Lexmark 3500-4500 Series (NONE)P*3e@`H^/7w`H`HLO"Arial)  2(NONE)P*3e@`H^/7w`H`HLO"Arial)  2珞Lexmark 3500-4500 Series8珞, ` : KPcpSoftware\LexmarkInkjetLVALMXX,XXXX,XXXXX珞 U!:3500-4500_Series_1A3005_P11D01<FPd26d# e%PM\" @Calibri    'e   'f1IPM   'g6Y75   'h4g# h%'" @Calibri    'i5Ig4h5PM    'jg4h5    'k3IPM    l0Y3I:g4PM    'mf5I:Cg4i# PM" @Calibri     'n6=Ih4j# PM" @Calibri     '$,'8o3I8Aj4l# PM" @Calibri  LVALN   '*,-8pPM    'r4PM     'w4IPM    'z4i# j%'" @Calibri    '{25d# " @Calibri    ~23I78bc,PM   '.4 Location_ID Visit_Date Visit_Time Common_NameK`, ReportHeaderx T.AEH- 'd68`6<a<bc, d# Label12 Site Data" @Cambriax ^E J<K<LMI`, "PageHeaderSectionx |n67OOd27`6ha<bc,' "Location_ID_Label Location  DetachedLabelx FL@P JhK<L7MJd27`6a<bc,'  Visit_Date_Label Date  DetachedLabelx JFA*ʗ JK<LMJd27`6a<bc,'  Visit_Time_Label Time  DetachedLabelx "i`53ONS' JLVALOK<LMJd27`6a<b c,' "Common_Name_Label Common Name  DetachedLabelx >jKHY/ JK<L"MJd27`6sa<bc,' X_Coord_Label East  DetachedLabelx f`E8H JsK<L MJd27`6A a<bc,' Y_Coord_Label  North  DetachedLabelx P8b]F2!K! JA K<LMJK`, GroupHeader0x  0%ASH ;K`,J  Detailx JbO|RE ;mE0G;F{`6habc, Location_ID Location_ID Primary Keyx wHn&+.Jh/K0L71M,mE;F{`6abc,k Visit_Date Visit_Date& Short Date Date of countx ӕV)o$At9b+.J/K0L1M,mE;F{`6abc,k Visit_Time Visit_Time& Short Time Time of countx wR J+.J/K0L1M,mF{`6ab c,k Common_Name Common_Name 0AOU accepted common namex F_Dr9+.J/K0L"1M,mE;F{`6sabc,k X_Coord X_Coord >East co{LVALordinate, VT state planex BDek+.Js/K0L 1M,mE;F{`6A abc,k Y_Coord Y_Coord @North coordinate, VT state planex \8 CF~V+.JA /K0L1M,K`,a GroupFooter1x I GiXܞmF{`6a<bhc,  Text15 *=Count([Common_Name])x P:HN]) +.J/K<0L,1MJd`6a<bc, Label16 $Number of Species:x Z@ |AQڪJK<LMJ`, "PageFooterSectionx jc B 5Pcm;F{`6<abc,i#  Text13  =Now()& Long Datex 3p4׹Kw1+.J</K0L1Mm;F{`6abc,i#k  Text14 H="Page " & [Page] & " of " & [Pages]x  ^ _:u027=5B>a)b*ce gh6 i j k  lI=oc@x ePMZgy  UT;K3!LaGSuSc@Cd/tlu_Species9iSXiDVT;K3!LaGSpecies_IDi<+J>֍T;K3!LaGCommon_Name  @Calibri1D/1<FPd2d# " @Calibri    hg# h%" @Calibri    oj4l# " @Calibri     *,-8`,  Detailx 8<BÑo5UD{`Fbc6d,e@ f,;Z \"Species Code";">";"Common Name";"";"10";"100"x %CcBjSD Species] Table/Query[ SELECT [tlu_Species].[Species_ID], [tlu_Species].[Common_Name] FROM tlu_Species ORDER BY [Common_Name];   0;3600Y F"SELECT [tlu_Species].[Species_ID], [tlu_Species].[Common_Name] FROM tlu_Species ORDER BY [Common_Name]; ";"tlu_Species";"";"Species_ID";"Common_Name";"PrimaryKey"26J7K,8L9Mgd5U`6,a,bWc,@ Species_Label Speciesx x[BQ8NJ,K,LMlh1U`6a bi Command2 Export to MARK~ :mac_frm_Species_Select.Exportx LCYM]!%J&K 'L (MtLVALam  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office12\MSACC.OLB#Microsoft Access 12.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation:*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\PROGRA~1\COMMON~1\MICROS~1\OFFICE12\ACEDAO.DLL#Microsoft Office 12.0 Access database engine Object Library guVJ 8LDXOBUHLHPVTGEWYYYQAEMASDFLI094a575719 mod_Current_Userx +ANK5`&AccessVBAWin16~Win32MacVBA6# Bird_CountsAstdole`DAOmod_Current_User] _EvaluateapiGetUserName/lpBuffer>nSize} advapi32.dll}0 fOSUserNamelngLen[lngX/ strUserName͈ vbNullStringH    LVAL^0* pHd Bird_Counts8@ = t  guVJ( J< rstdole>stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\sys@tem32\e2.tlb#OLE Automation0!DAO>JDAOA A4AC9E1DA-5BAD-7-86E3-24F4CDCEC@A28}#cAPROGRA~1\@COMMONM ICROSOFFICE12\ACE9.DLL#Microsoft Office 1f^0* pHd Bird_Counts8@ = t  guVJ( J< rstdole>stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\sys@tem32\e2.tlb#OLE Automation0!DAO>JDAOA A4AC9E1DA-5BAD-7-86E3-24F4CDCEC@A28}#cAPROGRA~1\@COMMONM ICROSOFFICE12\ACE9.DLL#Microsoft Office 1f Access database engine Object LibraryOA mourrent_UserG  d_Cur@en@^ _Us@^r@ UTUUBAJPXQRSODTXBECBBKGZOYJGH28AT UBKJPX@QRSNDU@XEBKGZYJ#@AH@1BBE,0x!B+BA3HOx$GetUserNameAxME+@ i`_fi+`ion.` `"  @ 6H . ( 2 8 H P h H B &(@HPX >` x:******************** Code Start **************************0 This code was originally written by Dev Ashish.( It is not to be altered or distributed, " except as part of an application.+ You are free to use it in any application,1 provided the copyright notice is left unchanged. Code Courtesy of Dev Ashish Returns the network login name]]$ \'"' " $'    "  $ 'd $'ki8******************** Code End **************************XAttribute VB_Name = "mod_Current_User" Option Compare Database ` '*Rde Start >&x This co-was originally written by Dev As(h.2It 3not to be al tered< d$isd,*ex`cept Yt of an applicaOYou jfree)use i1ny)provid7the\DpyYht Gics left unchang,ed0DCqCourtesyD k PrivBaDeclGF"apiGetLib "adv 32.dl@l" Aliq_( "A" (ByVal lpBuffer Sng, nSizeLo8ng)AufO:S(B/Re@turns Bnetwork loo n@ Dim lngLqAs ,XAlF6 2=-$(254, 0):= 255FX@L(!C%DIf (@X >en +?Lv$Q - 1DElA@vbNull 8End If E\@VCK  Qn, , @ @ @ @ @ @ @ @ @ @........ . .  .  .  . . ....K.L.M.N.O.P.T.b.c.d.e.f.g.h.. .!.".#.$.%.&.'6.(7.)@.*A.+B.,C.-D..W./t.0u.1v.2w.3xEEEEEEEEEE E E E E EEEEEEEEEEEEOE&PE'QE(RE)SE*TE+ ,@@@@@@@@@@@@@@@@@@@@@....... . .  . . ..K.O.T.b.c.d.. @.*t.0EEEE E EEE.%.&.'6.(W./EE.OE&  .  .  . .SE*TE+PE'QE(RE)KL.KM.KN.KP.de.df.dg.dh..!.".#.$67.)@A.+@B.,@C.-@D..tu.1tv.2tw.3txEEEEEEE E E EEEEEEE,@@@ @   @@@@  @ @@@M`OLJik.Mokmd`Uidofk. OJmJJMMQkkfJUQk. OJmJLJkQk. Sdi`k.Y`QukfQMk.`dOo^Qk.`kvkJMMQkkkmdiJUQ+iddm.fidfOJmJ.iQfdimk.kMiYfmk.qLJ.`kvkJMMQkkkmdiJUQ+kMiJmMW.6.8.:. <.*>.0@EOYiOJmJ.OYiOJmJMdfv.fidfOJmJ.fidfOJmJMdfv.6E8E OYiOJmJEfidfOJmJE 6EOYiOJmJEfidfOJmJE6E8E:.(OYiOJmJ.%OYiOJmJMdfv.&fidfOJmJ.'fidfOJmJMdfv./JMQkkqLJOJmJE&qLJfid[QMm. 6.  OYiOJmJ. L^dL. fid[QMmE+fid[QMms`E*qLJ.+qLJ+fid[QMmE(OYiE)^OudLoW^WfqmUQsvvvhJQ`JkOS^YE'KL^dL.KL^dLOQ^mJ.KfidfOJmJ.KmvfQYbSd.dL^dL.dL^dLOQ^mJ.dfidfOJmJ.dmvfQYbSd.L^dL.!L^dLOQ^mJ.#fidfOJmJ.$mvfQYbSd."6L^dL.)@L^dL.+@L^dLOQ^mJ.-@fidfOJmJ..@mvfQYbSd.,tL^dL.1tL^dLOQ^mJ.3tfidfOJmJEtmvfQYbSd.2L^dLEL^dLEL^dLOQ^mJEfidfOJmJEmvfQYbSdEL^dLE L^dLOQ^mJE fidfOJmJEmvfQYbSdE L^dLEL^dLOQ^mJEfidfOJmJEmvfQYbSdEL^dLEfidfOJmJES YNWWY   Y Y  Y , Y ,> Y >Id LValueObjectGuidObjectNameProperty Value,>,>,WX>,>,>,WY>,>,>,WZ>,YYYId$ObjectGuidProperty$ObjectNamePropertyWHv1b V V V qYN\\Y Y  Y Y Y Y >Y Y AttributesDataTypeFieldNameIndexTypeSkipColumn SpecID Start Width>,>,\^>,>,>,\_>,YY Index1PrimaryKeyv1@ [p8 History  Grassland_Percent3/  Forest_Percent-)  Filler + Developed_Percent3/  8Comment  []]]]+]8] [@Md``Qbm]OQqQ^dfQO+fQiMQbm]SY^^Qi]SdiQkm+fQiMQbm]UiJkk^JbO+fQiMQbm]WYkmdiv] YN  aa Y Y Y Y  Y  Y Y Y  Y Y  Y   Y   Y  eDateDelim"DateFourDigitYear DateLeadingZerosDateOrderDecimalPointFieldSeparatorFileType SpecIDSpecNameSpecTypeStartRowTextDelimTimeDelimacjeYPrimaryKeyv1` /. MARK_Export:-++'  ``Ji\+Qufdimb>YNee Y Y Y  Y Y ,>Y >Y  Filter FlagsIdNamePosition SelectedObjectIDType>,>,eg,>YIdv1@@id}Custom ^v v- vdfff RYNiiY Y Y  Y Y ,>Y >Y  FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPosition>,>,ik,>>,>,il,>YYGroupCategoryIDIdv1 hyLO" n A    w  w w w w w w  w  w Custom Group 162.*  w w w w w w w w~ h @ @jj j j j jjjjjjjjjjjjj ~ h @ @jjjjjjjj j j  j j j j jjjj YpxNnnp ppY Y Y Y  Y ,>Y >Y  FlagsGroupIDIconIdNameObjectIDPosition>,>,>nq,>>,>,>nr,>YYGroupIDIdv1(mVyLk> ] 0  | O " n A  ` 3   R % qDc6 U(tGf9 X+wJi<^  o]  o\  o[1 oZ1 oY oV oU oT: oS: oR6 oQ6 oP6 oO6 oN5 oM5 oL5 oK5 oG" oF" oE" oD" oC2 oB2 oA2 o@$ o?% o>% o=# o<# o;3 o:3 o97 o87 o77 o67 o5 o4  o3  o24  o1 o0- o/, o.+ o-+ o,, o+, o*, o)4 o(4 o'- o&- o% o$  o"  o! o *  o* o9  o!  o)  o( o& o' o  o! o  o   o  o  o' o' o9 o) o& o ( o  o  o  o  o o o o o o  o, myLk> ] 0  | O " n x ow ov  ou. ot. os0 or0 oq/ op/ oo/ on/ om ol ok o j oi oh og o f oe8 od8 oc8 ob8 oa o`  o_ o0 m @ @ @ @ @ @ @ @ @ @ @ @ @ @ooooo o1oNpooooooooo*o+o,o.o5o7o9o;o<o?oCoGoKoMoOoRppppo-o/o0oTppp poPppp o o p p oooo"o&o)o2o6o8o:o@oDoHoLoQoSppp pppooooo#o$o'o3oAoEoIpp p pooo o%o(o4o>oBoFoJppoo o o o oooo!o=oU0 m @ @ @ @ @ @ @ @ @ @ @ @ @ @oooooo o o o o  o o o o ooooooooooooooo o!o"o$o %o!&o"'o#(o$)o%*o&+o',o(-o).o*/o+0o,1o-2o.3o/4o05o16o27o38o49o5:o6;o7<o8=o9>o:?o;@o<Ao=Bo>Co?Do@EoAFoBGoCKoDLoEMoFNoGOoHPoIQoJRoKSoLToMUoNVoOYoPZoQ[oR\oS]oT^oU_p`papbpcpdpepfpgphp ip jp kp lp mpnpopppqprpsptpupvpwpxpRYVNttY  Y Y IdNameTypedv%sEh=}0 k " e  a @  C Z / e.Tb\{.eY"S4qry_Orphaned_Observations<83qry_Number_of_Species_by_SiteD@2qry_Number_of_Detections_by_SpeciesPL1qry_Nearest_Location2.0qry_MARK_Export_2,(/qry_MARK_Export_1,(.qry_MARK_Export($-qry_Locations_and_Visits:6,qry_Individuals_Per_Visit<8+qry_Individuals_Per_Site_MaxB>*qry_Import_Visits_Data_2:6)qry_Import_Visits_Data62(qry_Import_Species_Data84'qry_Import_Observations_DataB>&qry_Import_Locations_Data<8%qry_Forest_Stats_East40$qry_Forest_Stats_Average_DifferencePL#qry_Forest_Stats*&"qry_Complex_Criteria_ExampleB>!qry_Compare_Data_Raw2. qry_Compare_Data_Imported<8qry_Combined_Data,(sMSysNavPaneObjectIDs2.mMSysNavPaneGroupToObjects<8hMSysNavPaneGroups,(dMSysNavPaneGroupCategories>:`MSysIMEXSpecs$ [MSysIMEXColumns($VMSysAccessXML$ ,MSysAccessStorage,(Admin mac_Switchboard($mac_frm_Species_Select62mac_frm_Locations,(rpt_Species rpt_Sitesmod_Current_User*& Switchboard  fsub_Visits  fsub_Observations,( fsub_Nearest_Location40 frm_Species_Select.*frm_Locations$ UserDefined SummaryInfo SysRelScriptsReportsModulesFormsDataAccessPages($'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects MSysDbRelationships$ DatabasesTables s\!l= J  6 =tbl_Visitstbl_Observations>:<tbl_Speciestbl_Observations@<;tbl_Locationstbl_Visits84:xtab_Species_by_Location_and_ForestPLtlu_Species tlu_Bird_Codes_VT,(tbl_Visitstbl_Raw_Data_2&"tbl_Raw_Data"tbl_Observations*&tbl_Locations$ Switchboard Items,(9qry_Update_Count*&8qry_Species_by_Site_Report>:7qry_Species_by_Site0,6qry_Species_by_Location_and_ForestNJ5qry_Parameter_Query_Example@<6D|99 c - j $ ] t < ?  M#s#/y1{CSg=u&ZX_coordtbl_Raw_Data.X_coordA w&ZLocation_IDtbl_Raw_Data.Site_StationN' w&Ztbl_Raw_Data))) &Z G&Ztbl_Locations+++ O&Z &Z G% ZL@ x '% ZIIf([X_Coord]>475000,Yes,No); g%ZStDevOfForest_PercentF@xG;; o%ZMaxOfForest_PercentB@xC77 o%ZMinOfForest_PercentB@xC77 o%ZAvgOfForest_PercentB@xC77 o%ZEastIIf([X_Coord]>475000,Yes,No)C o%Ztbl_Locations+++ %Z G%Z G%Z %Z G$ZDifference@x1%% o$Zqry_Forest_Stats_East;;; $Zqry_Forest_Stats111 $Z G$Z G$Z $Z G#StDevOfForest_PercentF@xG;; o#MaxOfForest_PercentB@xC77 o#MinOfForest_PercentB@xC77 o#AvgOfForest_PercentB@xC77 o#tbl_Locations+++ # G# G# # G"r@* '"tbl_Visitstbl_Observations\@*QE% "tbl_Locationstbl_Visitsb@*K?+ "tbl_Visits.Count/ g"tbl_Observations.Species_IDF; g"tbl_Locations.Location_ID8 g"tbl_Observations111 "tbl_Visits%%% "tbl_Locations+++ " " G!H@* '! tbl_Raw_Data.[Common Name]9 g!tbl_Raw_Data.Date0 g!tbl_Raw_Data.[Time Started]: g!tbl_Raw_Data.Y_coord3 g!tbl_Raw_Data.X_coord3 g!tbl_Raw_Data.[Time Detect]9 g!tbl_Raw_Data.Species3 g!tbl_Raw_Data.Count1 g!tbl_Raw_Data.Site_Station8 g!tbl_Raw_Data))) ! G! G! ! G tbl_Visitstbl_Observations`@*QE%  tlu_Speciestbl_Observationsj@*SG'  tbl_Locationstbl_Visitsf@*K?+   tbl_Observations.Detect_Time; g tlu_Species.Common_Name6 g tbl_Observations.Species_IDF; g tbl_Visits.Count/ grLVAL)|:H < f  v , z . h  v&Hx ``(((tbl_Observations.Species_IDF)=[Enter four character species code:]))tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDF(((tbl_Visits.Visit_ID) Is Null))tbl_Visits.Visit_ID = tbl_Observations.Visit_IDFCount(qry_Species_by_Site.Species_IDF)tlu_Bird_Codes_VT.Species=tbl_Observations.Species_IDFCount(tbl_Observations.Species_IDF)Sqr(([X_Coord]-[Forms]![frm_Locations]![X_Coord])^2+([Y_Coord]-[Forms]![frm_Locations]![Y_Coord])^2)(((tbl_Locations.Location_ID)<>[forms]![frm_Locations]![Location_ID]))Sqr(([X_Coord]-[Forms]![frm_Locations]![X_Coord])^2+([Y_Coord]-[Forms]![frm_Locations]![Y_Coord])^2)tbl_Locations.Location_ID=qry_MARK_Export_1.Location_IDMax(IIf([Count3] Is Null,0,[count3]))Max(IIf([Count2] Is Null,0,[Count2]))Max(IIf([Count1] Is Null,0,[count1]))(((tbl_Observations.Species_IDF)=[Forms]![frm_Species_Select]![Species]))tbl_Visits.Visit_ID=tbl_Observations.Visit_IDFtbl_Locations.Location_ID=tbl_Visits.Location_IDFqry_MARK_Export_2.Developed_Percentqry_MARK_Export_2.Grassland_Percenttbl_Locations.Location_ID = tbl_Visits.Location_IDFtbl_Visits.Visit_ID = tbl_Observations.Visit_IDFtbl_Locations.Location_ID = tbl_Visits.Location_IDFCount(tbl_Observations.Observation_ID)qry_Individuals_Per_Visit.Location_IDMax(qry_Individuals_Per_Visit.CountOfObservation_ID)qry_Individuals_Per_Visit.Location_ID(((tbl_Raw_Data.[How Detect])<>"F"))tbl_Raw_Data.Count=tbl_Visits.Counttbl_Raw_Data.Site_Station=tbl_Visits.Location_IDFIIf([How Detect]="C" Or [How Detect]="S" Or [How Detect]="D","A","V")(((IIf([X_Coord]>475000,Yes,No))=Yes))StDev(tbl_Locations.Forest_Percent)Max(tbl_Locations.Forest_Percent)Min(tbl_Locations.Forest_Percent)Avg(tbl_Locations.Forest_Percent)[qry_forest_stats].[avgofforest_Percent]-[qry_forest_stats_east].[avgofforest_percent]StDev(tbl_Locations.Forest_Percent)Max(tbl_Locations.Forest_Percent)Min(tbl_Locations.Forest_Percent)Avg(tbl_Locations.Forest_Percent)=WJ  I  W % h  o   a + {;i3q >s,wE'L[* tbl_Raw_Data.Count1 g* tbl_Raw_Data.Site_Station8 g*Skytbl_Raw_Data.Sky5 w*Windtbl_Raw_Data.Wind8 w*Visit_Timetbl_Raw_Data.[Time Started]N% w*Visit_Datetbl_Raw_Data.DateD% w*Counttbl_Raw_Data.Count; w*Location_IDFtbl_Raw_Data.Site_StationP) w*tbl_Raw_Data))) * G*tbl_Visits%%% O* * G) Ztbl_Raw_Data.Sky/ g) Ztbl_Raw_Data.Wind0 g) Ztbl_Raw_Data.[Time Started]: g) Ztbl_Raw_Data.Date0 g) ZIIf([count]="Tape",3,[count])< g) Ztbl_Raw_Data.Site_Station8 g)ZSkytbl_Raw_Data.Sky5 w)ZWindtbl_Raw_Data.Wind8 w)ZVisit_Timetbl_Raw_Data.[Time Started]N% w)ZVisit_Datetbl_Raw_Data.DateD% w)ZCount_NewCountIIf([count]="Tape",3,[count])X-# )ZLocation_IDFtbl_Raw_Data.Site_StationP) w)Ztbl_Raw_Data))) )Z G)Ztbl_Visits%%% O)Z )Z G( Ztbl_Raw_Data.[Common Name]9 g( Ztbl_Raw_Data.Species3 g(ZCommon_Nametbl_Raw_Data.[Common Name]O' w(ZSpecies_IDtbl_Raw_Data.SpeciesG% w(Ztbl_Raw_Data))) (Z G(Ztlu_Species''' O(Z (Z G'ZH@ x ''Ztbl_Raw_Datatbl_VisitsF@ xI=) 'Ztbl_Raw_Datatbl_Visitsb@ xI=) 'ZVisit_IDFtbl_Visits.Visit_IDD# w'ZHowDetectDetect_Type@ xE9# 'ZTimeDetectDetect_Time[time detect]/100Z;% 'ZSpecies_IDFtbl_Raw_Data.SpeciesI' w'Ztbl_Visits%%% 'Ztbl_Raw_Data))) 'Ztbl_Observations111 O'Z 'Z G& Ztbl_Raw_Data.Developed5 g& Ztbl_Raw_Data.Grassland5 g& Ztbl_Raw_Data.Forest2 g& Ztbl_Raw_Data.Y_coord3 g& Ztbl_Raw_Data.X_coord3 g& Ztbl_Raw_Data.Site_Station8 g&ZDeveloped_Percenttbl_Raw_Data.DevelopedW3 w&ZGrassland_Percenttbl_Raw_Data.GrasslandW3 w&ZForest_Percenttbl_Raw_Data.ForestN- w&ZY_coordtbl_Raw_Data.Y_coordA wF|?; k M /  i $ 9 W 9  u 0 Z<Qy!{=fzQo70tbl_Locations.Location_ID8 g0qry_MARK_Export_1333 0tbl_Locations+++ 0 0 G/ @x '/ IIf([Count]=3,1,0)1 g/ IIf([count]=2,1,0)1 g/ IIf([count]=1,1,0)1 g/ tbl_Observations.Species_IDF; g/ tbl_Locations.Location_ID8 g/tbl_Visitstbl_Observations\@xQE% /tbl_Locationstbl_Visitsb@xK?+ /Count3IIf([Count]=3,1,0)= o/Count2IIf([count]=2,1,0)= o/Count1IIf([count]=1,1,0)= o/tbl_Observations.Species_IDF; g/tbl_Locations.Location_ID8 g/tbl_Observations111 /tbl_Visits%%% /tbl_Locations+++ / / G.Comment "/* " & [Location_ID] & " */;"K o.F@x g.F@x g."qry_MARK_Export_2.Forest_Percent? g.Filler1+ o.History[one] & [two] & [three]D o.qry_MARK_Export_2333 . G. G. . G- tbl_Visits.Visit_ID2 '-tbl_Locationstbl_Visitsf@xK?+ -tbl_Visits.Visit_ID2 g-tbl_Locations.Location_ID8 g-tbl_Visits%%% -tbl_Locations+++ - G- G- - G, tbl_Visits.Visit_ID2 g, tbl_Locations.Location_ID8 g,tbl_Visitstbl_Observations`@xQE% ,tbl_Locationstbl_Visitsf@xK?+ ,tbl_Visits.Visit_ID2 g,CountOfObservation_IDL@xG;; o,tbl_Locations.Location_ID8 g,tbl_Observations111 ,tbl_Visits%%% ,tbl_Locations+++ , G, G, , G+ J@x g+MaxOfCountOfObservation_IDh@xQEE o+J@x g+qry_Individuals_Per_VisitCCC + G+ G+ + G* tbl_Raw_Data.Sky/ g* tbl_Raw_Data.Wind0 g* tbl_Raw_Data.[Time Started]: g* tbl_Raw_Data.Date0 g| @ @ @ @ @ @ @ @ @ @ @ @ @ @))))))))) ) )) ) )) ))))))))))))))))) )!))")$)%)& )')#)()*)+),)-).)/)0)1)2)))3)5)6)7)8)9):);)<)=)>)4)?)A)B)C)D)@ )E )G )H )I )J )K )L )M )N )O )P )Q w w w  w w w w )F!w!w !w !w !w !w !w!w!w!w!w!w! w!w!w"w"w"w"w"w"w"w"w"w"w "w#w!#w##w$#w%#w&#w'#w(#w)#w"$w*$w,$w-$w.$w/$w0$w+%w1%w3%w4%w5%w6%w7%w8%w9%w:% w;% w<%w2&w=&w?&w@&wA&wB&wC&y&y&y&y& y& y& y& y& y& y &w>'y 'y 'y 'y'y'y'y'y'y'y'y'y (y(y(y(y(y(y( y( y(y)y)y!)y")y#)y$)y%)y&)y')y()y)) y*) y+) y,) y-) y.) y/)y *y0*y2*y3*y4*y5*y6*y7*y8*y9*y:* y;* y<* z*y1y {~ @ @ @ @ @ @ @ @ @ @ @ @ @ @"w"w"w"w"w"w"w"w "w#w!#w##w$#w%#w&#w'#w(#w)#w"$w*$w,$w-$w.$w/$w0$w+%w1%w3%w4%w5%w6%w7%w8%w9%w:% w;% w<%w2&w=&w?&w@&wA&wB&wC&y&y&y&y& y& y& y& y& y& y &w>'y 'y 'y 'y'y'y'y'y'y'y'y'y (y(y(y(y(y(y( y( y(y)y)y!)y")y#)y$)y%)y&)y')y()y)) y*) y+) y,) y-) y.) y/)y *y0*y2*y3*y4*y5*y6*y7*y8*y9*y:* y;* y<* z* z* z* z*y1+z+z+z+z+z +z + z +z,z ,z,z,z,z,z,z,z,z,z,z, z, z,z -z-z-z-z-z-z -z!-z"- z#-z.z$.z&.z'.z(.z).z*.z+.z,.z-.z..z%/z//z1/z2/z3/z4/z5/z6/z7/z8/z9/z:/ z;/ z/ z?/ z@/z00zA0zC0zD0zE0}0}0}0}0}0}0}0 }0 }0 } 0 } 0zB1} 1} 1}1}1}1}1}1 }1} 2}2}2}2}2}2}2}2 }2 }2}3}3} 3}!3}"3}#3}$3}1Dl$( P  S  b D  6 | 7 t0L.d|R4n)s.HK6tbl_Visits.Count/ g6tbl_Observations.Species_IDF; g6tbl_Locations.Forest_Percent; g6tbl_Locations.Location_ID8 g6tbl_Observations111 6tbl_Visits%%% 6tbl_Locations+++ 6 6 G5 @(x '5 tbl_Observations.Species_IDF; g5 tbl_Locations.Location_ID8 g5tbl_Visitstbl_Observations\@'xQE% 5tbl_Locationstbl_Visitsb@&xK?+ 5tbl_Locations.Location_ID8 g5tbl_Observations111 5tbl_Visits%%% 5tbl_Locations+++ 5 5 G4B@%x '4tbl_Visitstbl_Observations`@$xQE% 4tbl_Visits.Visit_ID2 g4!tbl_Observations.Observation_ID> g4tbl_Observations111 4tbl_Visits%%% 4 G4 G4 4 G3 !qry_Species_by_Site.Location_ID> g3CountOfSpecies_IDFL@#xA55 o3!qry_Species_by_Site.Location_ID> g3qry_Species_by_Site777 3 G3 G3 3 G2 !tlu_Bird_Codes_VT.[Common Name]> g2 tlu_Bird_Codes_VT.Species8 g2tlu_Bird_Codes_VTtbl_Observationsl@"x_S3 2CountOfSpecies_IDFF@!xA55 o2!tlu_Bird_Codes_VT.[Common Name]> g2tlu_Bird_Codes_VT.Species8 g2tbl_Observations111 2tlu_Bird_Codes_VT333 2 2 G1 @ x '1@x '1tbl_Locations.Location_ID8 g1Distance@x-!! o1tbl_Locations+++ 11 O1 G1 1 G0 !tbl_Locations.Developed_Percent> g0 !tbl_Locations.Grassland_Percent> g0 tbl_Locations.Forest_Percent; g0 tbl_Locations.Location_ID8 g0tbl_Locationsqry_MARK_Export_1n@xYM+ 0!tbl_Locations.Developed_Percent> g0!tbl_Locations.Grassland_Percent> g0tbl_Locations.Forest_Percent; g0threeJ@x' o0twoJ@x# o0oneJ@x# o)| @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @* z* z*y1+z+z+z+z+z +z + z +z,z ,z,z,z,z,z,z,z,z,z,z, z, z,z -z-z-z-z-z-z -z!-z"- z#-z.z$.z&.z'.z(.z).z*.z+.z,.z-.z..z%/z//z1/z2/z3/z4/z5/z6/z7/z8/z9/z:/ z;/ z/ z?/ z@/z00zA0zC0zD0zE0}0}0}0}0}0}0}0 }0 }0 } 0 } 0zB1} 1} 1}1}1}1}1}1 }1} 2}2}2}2}2}2}2}2 }2 }2}3}3} 3}!3}"3}#3}$3 }%3}4}&4}(4})4}*4}+4},4}-4}.4}/4}'5}05}25}35}45}55}65}75 }85 }95 }:5}16};6}=6}>6}?6}@6}A6}B6}C666 6 6 6 6}<777 7 7 7 7 7777 7 78888888888888  8 !8 "8 #8 $8 %89&9(9)9*9+9,9':-:/:0:1:2:3:4:5:6: 7: 8: 9:.Ee] y  F   Ox qggރq=" c@" c@tbl_Visitstbl_ObservationsVVVVVVVVVVT <+YŤb@+YŤb@tbl_Speciestbl_ObservationsXXXXXXXXXXV ;Ác@Ác@tbl_Locationstbl_VisitsPPPPPPPPPPN 4[~c@%c@qry_Orphaned_Observations@@l``TTTTTTTR @/ogs4c@ic@qry_MARK_Export_1G@ @ \PPDDDDDDDB @*V[c@8[c@@qry_Import_Visits_Data_2@ |@ j^^RRRRRRRP @%5›c@Tśc@qry_Forest_Stats_EastϹ@|@dXXLLLLLLLJ @ ~b@:zN~c@qry_Compare_Data_ImportedϪ0@l``TTTTTTTR @=O c@tO c@~sq_rrpt_Sites4MR2KeepLocal T~~~>>>>>>>< @>c@>c@~sq_ffsub_Observations4MR2KeepLocal TNNNNNNNL @ Cܻc@Cܻc@~sq_cfsub_Visits~sq_cObservations4MR2KeepLocal Tdddddddb @XEc@Ec@~sq_cfrm_Locations~sq_cfsub_Nearest_Location4MR2KeepLocal Tzzzzzzzx @hCc@ hIRc@rpt_Species@DDD88888886 @7(]c@7(]c@frm_Locationsh@HHH<<<<<<<: @:/Ҝc@nߜc@xtab_Species_by_Location_and_ForestϚ0|@tthhhhhhhf @meb@hc@tlu_SpeciesT@DDD88888886 @}c@C(c@tlu_Bird_Codes_VTϾ@PPPDDDDDDDB @9!.b@hc@tbl_Visitsϕ0BBB66666664 @,2c@4c@tbl_Raw_Data_2R @JJJ>>>>>>>< @1b@K_b@tbl_Raw_Dataϻ0FFF:::::::8 @xb@hc@tbl_Observations @NNNBBBBBBB@ @%b@hc@tbl_Locations]0HHH<<<<<<<: @*)'3c@n03c@Switchboard Items@PPPDDDDDDDB @9uc b@7)[c@0qry_Update_Count@|@ZNNBBBBBBB@ @8) I%c@Mc@qry_Species_by_Site_Reporto@@nbbVVVVVVVT @7 fc@X