Standard Jet DBnb` Ugr@?~1y0̝cßFN_o7М("`{6,߱`C;3y[K!|*|Mw{^f_Љ$g'DeFx -bT4.0m7_H? Y@SS  Y   Y Y  Y Y  Y  Y  Y  r Y s Y E Y a Y d Y 2Y  Y   Y  jY ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeniLSSYYIdParentIdName        OYSY Y Y  Y 2ACMFInheritableObjectIdSID YObjectId Y@SSY  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Ordernzf edY"ObjectIdAttribute -Y@SSY Y Y  Y  Y L Y S Y S Y Lccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationshipLS SL SL YYYszObject$szReferencedObjectszRelationship f!R  > o * K  | 7 H  i$U  hX@ phh" h@H>@ dX@@@@ \^\fMWJiUQLJM\kdoiMQ6[omY^+Oxu+`dO+LQ+omY^Ymv+:66<6F8@`JMfJmMW88:@6:JO`YbOJmJJMMQkkfJUQkOJmJLJkQkSdi`k `dOo^Qk iQ^JmYdbkWYfkiQfdimk kMiYfmk kvkiQ^ mJL^Qk+kh+MSdi`8+kh+MMd`Ld6+kh+MSi`OQJ^k+kh+MMLdLJb\kdoiMQ+kh+MSi`OQJ^k+kh+MMLdOQk\YbU`JbJUQi+kh+MSi`OQJ^k+kh+MMLdQumsJiiJbmvkdoiMQ+kh+MSi`OQJ^k+kh+MMLdSY`JbJUQi+kh+MSi`OQJ^k+kh+MMLdkJ^Qk`Jb8+kh+MSi`OQJ^k+kh+MMLdkJ^Qk`Jb:+kh+MSi`OQJ^k+kh+MMLdkQJiMW+kh+MSi`OQJ^k+kh+MMLdmiJOQ`SU+kh+MSi`OQJ^k+kh+MMLdqQWYM^Q`J\Q+kh+MSi`OQJ^k+kh+MMLdqQWYM^Q`dOQ^ +kh+MSi`OQJ^k:+kh+MMLdLJb\kdoiMQ!+kh+MSi`OQJ^k:+kh+MMLdOQk\YbU`JbJUQi"+kh+MSi`OQJ^k:+kh+MMLdQumsJiiJbmvkdoiMQ#+kh+MSi`OQJ^k:+kh+MMLdSY`JbJUQi$+kh+MSi`OQJ^k:+kh+MMLdkJ^Qk`Jb8%+kh+MSi`OQJ^k:+kh+MMLdkJ^Qk`Jb:&+kh+MSi`OQJ^k:+kh+MMLdkQJiMW+kh+MSi`OQJ^k:+kh+MMLdmiJOQ`SU+kh+MSi`OQJ^k:+kh+MMLdqQWYM^Q`J\Q+kh+MSi`OQJ^k:+kh+MMLdqQWYM^Q`dOQ^+kh+MSi`WQ^fQOYmdi+kh+MMLdmdfYMk+kh+MSi``JbJUQik+kh+MMLd`JbJUQik+kh+MSi``JbJUQik+kh+M^km`JbJUQik+kh+MSi`fidOoMmk+kh+MMLdfidOoMmk+kh+MSi`fidOoMmk+kh+M^kmfidOoMmk+kh+MSi`hoYM\kmJim+kh+MMLdiQfdim +kh+MSi`kJ^QkkmJSS+kh+MMLdkmJSS +kh+MSi`kJ^QkkmJSS+kh+M^kmkmJSS +kh+MSi`kQ^QMmOQJ^k+kh+MMLdiQfdim H:>iJmQk ^\fLJb\kdoiMQ^\fLJb\kdoiMQ6^\fMWJiUQLJM\kdoiMQ^\fMWJiUQLJM\kdoiMQ6^\fMWJimkh^^\fQumsJiikdoiMQ^\fQumsJiikdoiMQ6^\f`SUk^\f`dOQ^k^\f`dOQ^k6^\f`dbmW^\fdfQiJmdik^\ffJv`QbmmvfQ^\ffidOoMmUidofk^\fqQWYM^Qk^\fqQWYM^Qk6^\fqQbOdik^o+YbkoiJbMQMdOQk^o+mJuUidofk `kvkJMMQkkdL[QMmk!`kvkJMMQkku`^"`kvkJMQk`kvkdL[QMmk`kvkhoQiYQk`kvkiQ^JmYdbkWYfkfidqYOQi<<#hiv+YbkoiJbMQiJmQSdikfQMYSYQOfidqYOQi$hivfJmMW88:@6:J%hivfJmMW88:@6:L&hoQiv8'kvkmQ`+fJiJ`QmQikmL^+okQi^dUmL^+okQikmL^JUQUidofkmL^LJb\iJmQkmL^MWJiUQLJM\kmL^MWJiUQLJM\k6mL^MiYmQiYJOQSmL^MivkmJ^iQfdimkmL^Mo``iJb\YbUOJmJ mL^OQJ^QikWYf mL^OQJ^k mL^OQJ^ksYmWdom`JmMWYbUmL^OQJ^ mL^OQJ^k6 mL^OQJ^k`YkMmL^OQJ^k`YkMsYmWdom`JmMWYbUmL^OQJ^kmL^OQJ^k`YkM6mL^SJqiQfdimkmL^YbkoiJbMQmL^`JbJUQikmL^`JbJUQik6mL^`QboLoY^OQimJumL^`QbokmL^fJM\JUQkmL^fiQSQiQbMQkmL^fidOoMmkmL^fidqYOQikmL^iJb\YbUkmL^iJb\YbUkMWJimmL^iJb\YbUkOJmJmL^iJb\YbUkOJmJMWJimmL^iJmQUidofkmL^kJ^QkkmJSS mL^kJ^QkkmJSS6!mL^kQiqYMQMdbmiJMmk"mL^kQmof#mL^kdimUidof$mL^kdimUidof6%mL^mdfmQb&mL^mdmJ^fdYbmkOJmJ'ofOJmQYbkoiJbMQ(ofOJmQiJmQk)JMMQkk^Jvdom`kvkOLko``JivYbSdokQiOQSYbQO+  @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @            !"#$%& !"#$%&'( ) * + , -#.$/%0&1'2 34(5)6*7^8^9^:^;^<^=^>^ ?^ @^ A^ B^ C^"&*048=BGHKOSWZ` e!v"~    "48 =!B"G#J$O%T&X'_^a^n nnniiiiiiiii i i i iiiiiiiiiiiii$i% i& i' i( i) i* i+ i, i- i. i/ i0 i1 i2 i3 i4i5i6i7i8i9i:i;i<i=i>i?i@iAiBiCiDiEiFiGiHiIiJiKiLiMiNiOiPmmmmmmmmmm m m m m mmmmmmmmmmmm m m m!m!m!m"m "m!"m"#m##m$#m%$m&$m'$m(%m)%m*%m+&m,&m-&m.'m/'m0'm1(m2(m3(m4)m5)m6)m7*m8*m9*m:+m;+m<+m=,m>,m?,m@-}A-}B-}C.}D.}E.}F/}G//0001112,2-2.35363745464758595:6;6<6=7>7?7@8G8H8I9J99:::;;;<< < = = = >>>???@@@AAABBBCCC}8}9}:}6}7};}<}=}>}?}@mAmBmC}}}}}}"}"}"}&mD&mE&mF*} *} *} 0mG0mH0mI4mJ4}4}8}8}8}=}=}=}B}B} B} G}G}G}H}H}H}K}K}K}O} O}!O}"S}#S}$S}%W}&W}'W}(Z})Z}*Z}+`},`}-`}.e}/e}0e}1e}2v}3v}4v}5~~ ~     !"#$%&'()*+/0123489:;<=>?@ABCDEFGHIJ     """444888= =!="B#B$B%G&G'G(J)J*J+O,O-O.T/T0T1X2X3X4_A_B_CaDaEaF !")#$%*&'(+,-./iiii ii iiii!i"i#0T1X2X3X4_A_B_CaDaEaFiiii ii iiii!i"i# g!{5Z|=d8]           !"$%& '#(*+),./0-13452689:7;=>? @<ACDE FBGIJK LHMOPQ RNSUVW T          !!!! !""""" "#####  #$!$#$$$%$ &$"%'%)%*%+%,%-% .%(&/&1&2&3& 4&0'5'7'8'9':';'6(<(>(?(@(A( B(=)C)E)F)G) H)D*I*K*L*M*N*O* P*J+Q+S+T+++ +R,,,,,, , ,- - ------------ ....... .!."./#/%/&/$R   H'd S N [  v rK W  * ,(Hc_GE0wsDB"eaAA>2@A>2A>2@A>2@~sq_cOJ<@OJ<@~sq_cfrmDeals2~sq_ccboSalesman2*J4MR2KeepLocal T```````^ @^1‹OJ<@TOJ<@~sq_cfrmDeals2~sq_ccboFIManager*J4MR2KeepLocal T```````^ @щOJ<@:OJ<@~sq_cfrmDeals2~sq_ccboExtWarrantySource*J4MR2KeepLocal Tpppppppn @^OJ<@OJ<@~sq_cfrmDeals2~sq_ccboBankSource*J4MR2KeepLocal Tbbbbbbb` @G3d9@jqd9@~sq_cfrmDeals~sq_ccboVehicleModel*J4MR2KeepLocal Tdddddddb @^a$f9@bf9@~sq_cfrmDeals~sq_ccboTradeMfg*J4MR2KeepLocal T\\\\\\\Z @5g9@Xg9@~sq_cfrmDeals~sq_ccboSearch*J4MR2KeepLocal TXXXXXXXV @^+e9@ie9@~sq_cfrmDeals~sq_ccboSalesman1*J4MR2KeepLocal T^^^^^^^\ @f9@f9@~sq_cfrmDeals~sq_ccboFIManager*J4MR2KeepLocal T^^^^^^^\ @^e9@>e9@~sq_cfrmDeals~sq_ccboDeskingManager*J4MR2KeepLocal Thhhhhhhf @^q*V6@q*V6@~sq_cForm1~sq_cCombo0*J4MR2KeepLocal TLLLLLLLJ @  q7@q7@Admin*J@l8,,,,,,,,,*  %QuMZ@%QuMZ@macPatch112502*J>>>>>>>>>><  3+L{@3+L{@util_dzx_mod_BE_Utility_20030815*Jbbbbbbbbbb`   QrMZ@ QrMZ@basPatches*J66666666664  (l@(l@frmNoGo*JT@k<<<0000000. @ k:r5@k:r5@UserDefined*JA@kDDD88888886 @ k:r5@k:r5@SummaryInfo*Jd@kDDD88888886 @^Q=r5@Q=r5@SysRel*J.........., Q=r5@Q=r5@Scripts*J0000000000. Q=r5@Q=r5@Reports*J0000000000. Q=r5@Q=r5@Modules*J0000000000. Q=r5@Q=r5@Forms*J,,,,,,,,,,* Q=r5@Q=r5@DataAccessPages*J@@@@@@@@@@> uK6r5@uK6r5@MSysRelationships+HDDDDDDDDDDB uK6r5@uK6r5@MSysQueries+H88888888886 uK6r5@uK6r5@MSysACEs+H22222222220 uK6r5@/ 9@MSysObjects+H@DDD88888886 @uK6r5@]m]e@MSysDb*J@#:::......., @uK6r5@uK6r5@Relationships+H<<<<<<<<<<: uK6r5@uK6r5@Databases+H44444444442 uK6r5@uK6r5@Tables+H.........., %XfH*T6 { I + \ * Q   v D  i 7  fH* kMxEW%Ln-Y"J_[Name]% g_ [StaffNo]( g_tblSalesStaff+++ _ _ G _[Name]% '_[Name]% g_ [ManagerNo]* g_tblManagers''' _ _ G _[Name]% '_[Name]% g_[ExtWarrantySourceNo]4 g_lkpExtWarrSource111 _ _ G _[Name]% '_[Name]% g_ [ManagerNo]* g_tblManagers''' _ _ G _[Name]% '_[Name]% g_[BankSourceNo]- g_lkpBankSource+++ _ _ G_[Mfg]=cboVehicleMake3 '_ [Model]& g_lkpVehicles''' _ _ G_[mfg]$ g_lkpVehicles''' _ G_ _ G_[mfg]$ g_lkpVehicles''' _ G_ _ G_ [StockNo]( g_tblDeals!!! _ _ G _[Name]% '_[Name]% g_ [StaffNo]( g_tblSalesStaff+++ _ _ G _[Name]% '_[Name]% g_ [StaffNo]( g_tblSalesStaff+++ _ _ G _[Name]% '_[Name]% g_ [ManagerNo]* g_tblManagers''' _ _ G _[Name]% '_[Name]% g_[ExtWarrantySourceNo]4 g_lkpExtWarrSource111 _ _ G _[Name]% '_[Name]% g_ [ManagerNo]* g_tblManagers''' _ _ G _[Name]% '_[Name]% g_[BankSourceNo]- g_lkpBankSource+++ _ _ G_[name]% g_lkpMfgs _ _ GLUZ%W" V 8  l N  z \ >  } _ A r T 6  a'NzCi5@"e3R xD+_[MSysObjects].[Name]3 g+_MSysObjects''' +_ +_ G* _[Name]% '*_[InactiveDate]- g*_[Name]% g*_[EmployeeID]+ g*_ [StaffNo]( g*_tblSalesStaff+++ *_ *_ G) _[Name]% ')_[Name]% g)_ [StaffNo]( g)_tblSalesStaff+++ )_ )_ G( _[MSysObjects].[Name]3 '(_L@ '(_OtherNameMid([Name],4)>## o(_[MSysObjects].[Name]3 g(_MSysObjects''' (_ (_ G'_[TargetRetail]- g'_[Cost]% g'_[Name]% g'_ [ProductID]* g'_tblProducts''' '_ '_ G& _[Name]% '&_[Name]% g&_ [ProductID]* g&_tblProducts''' &_ &_ G% _[Name]% '%_[InactiveDate]- g%_[Name]% g%_[EmployeeID]+ g%_ [ManagerNo]* g%_tblManagers''' %_ %_ G$ _[Name]% '$_[Name]% g$_ [ManagerNo]* g$_tblManagers''' $_ $_ G# _Title$ '#_title$ g#_ context& g#_tblHelp #_ #_ G" _[Name]% '"_[Mfg]=cboVehicleMake3 '"_[Name]% g"_lkpModels### "_ "_ G! _[Name]% '!_[Name]% g!_lkpMfgs !_ !_ G _[Name]% ' _[Name]% g _lkpMfgs  _  _ G_ [StockNo]( g_tblDeals!!! _ _ G _[Name]% '_[Name]% g_ [StaffNo]( g_tblSalesStaff+++ _ _ G _[Name]% 'X(OA=Oz M 9 5Lv J ( PLH]E8l CCIEB/@111A&@2@A&@2@Query1,,,,,,,,,,, n0t?KZ@K2"NZ@@qryPatch112502b*J @|@XLL@@@@@@@> @/@9LZ@ZwA9LZ@0qryPatch112502a*J@|@lXLL@@@@@@@> @.r5k@s5k@qry_InsuranceRateForSpecifiedProvider*J@@lxxlllllllj @nv^:@^:@MSysAccessXML*J4MR2KeepLocal  T|||<<<<<<<: @e=2@_=2@MSysAccessObjects*JDDDDDDDDDDB `6kl@7o@lu_TaxGroups*Jj@FFF:::::::8 @nW)u5@07@lkpVendors*J@BBB66666664 @SQ{=t5@|rEK@lkpVehicles0*J;@FFF:::::::8 @OLZBK@쵟K@lkpVehicles*J@DDD88888886 @KaHs5@'as5@lkpProductGroups*J@NNNBBBBBBB@ @Hb)u5@Wh9@lkpPaymentType*J@JJJ>>>>>>>< @nGo)u5@)u5@lkpMonth*Jw@>>>22222220 @=e9@94]K@lkpModels0*J@BBB66666664 @8XK@'FíK@lkpModels*J@~@@@44444442 @*nT-@@ CPE@lkpMfgs*JL@~<<<0000000. @BLҎK@.?K@lkpExtWarrSource0*J^ZF PPPDDDDDDDB @XK@mf­K@lkpExtWarrSource*J@ZF NNNBBBBBBB@ @6PE@p8PE@lkpChartSQL*Je@~DDD88888886 @n0POK@OK@lkpChargebackSource*J@kTTTHHHHHHHF @&CK@.SK@lkpBankSource0*J[YwF JJJ>>>>>>>< @+l@6o@lkpBankSource*JpoF HHH<<<<<<<: @,R1@8@924Rates*J(@k|@lJ>>22222220 @+u8U<@8U<@~sq_cfrmSelectDeals~sq_ccboReport*J4MR2KeepLocal Tdddddddb @n)W<@BW<@~sq_cfrmSalesStaff~sq_ccboStaff*J4MR2KeepLocal T```````^ @(<12,[rate]/[term]*12,[rate])Format(IIf([term]>12,([rate]/([term]/12)),[rate]),"#.0000")((([tblInsurance].[ProviderID])=999))[tblInsuranceCANADA].[CreatedDate][CreatedBy] & "-" & [StateCode] & "-" & [RateID][tblInsuranceCANADA].[FinanceType][tblInsuranceCANADA].[Description][tblInsuranceCANADA].[ProviderID][tblInsuranceCANADA].[FinanceType][tblInsuranceCANADA].[Description][tblInsuranceCANADA].[ProviderID][tblInsuranceAll410].[FinanceType][tblInsuranceAll410].[Description][tblInsuranceAll410].[ProviderID]tblDealsMisc.DealNo = tblDeals.DealNotblDeals.StockNo = tblDeal.StockNotblDeals.DealNo = tblDealsMisc.DealNo(((tblDeals.PaymentType) Is Null))tblInsurance.Description = lu_InsuranceCodes.InsuranceCode((([tblInsurance].[Type])="CL") And (([tblInsurance].[Term])>12) And (([tblInsurance].[StateCode])="OH" Or ([tblInsurance].[StateCode])="PA" Or ([tblInsurance].[StateCode])="NY" Or ([tblInsurance].[StateCode])="NJ" Or ([tblInsurance].[StateCode])="DE"))((([MSysObjects].[Name]) Like "rpt*"))((([MSysObjects].[Name]) Like "rpt*"))CK-W o Q 3 ~ : | ? u W 9  x > qS5bD&Qj}0RHg0AmountFinancedtblDeals.AmountFinancedR- w0DeskingManagertblDeals.DeskingManagerR- w0FIManagertblDeals.FIManagerC# w0TradeMfgtblDeals.TradeMfg@! w0ModeltblDeals.Model7 w0MaketblDeals.Make4 w0YeartblDeals.Year4 w0 VINtblDeals.VIN1 w0 StockNotblDeals.StockNo= w0 NewtblDeals.New1 w0 Salesman2tblDeals.Salesman2C# w0 Salesman1tblDeals.Salesman1C# w0CustomertblDeals.Customer@! w0FundedtblDeals.Funded: w0DeliveredtblDeals.DeliveredC# w0PaymentTypetblDeals.PaymentTypeI' w0DealDatetblDeals.DealDate@! w0TO tblDeals.TO. w0QualifyingDealtblDeals.QualifyingDealR- w0DealershiptblDeals.DealershipF% w0tblDeals!!! 0 G0tblDealsTemp))) O0 0 G/D@ '/tblDeals.PaymentType "Finance"P9 w/tblDeals!!! / G/ G/ / G.!(((tblInsurance.ProviderID)=8))> '.tblInsurancelu_InsuranceCodest@WK) .tblInsurance.*- g.!lu_InsuranceCodes.InsuranceCode> g.lu_InsuranceCodes333 .tblInsurance))) . G. G. . G-"(((tblInsurance.ProviderID)>32))? '-tblInsurance.StateCode5 g-tblInsurance.Rate0 g-tblInsurance.Term0 g-tblInsurance.Description7 g-tblInsurance.Type0 g-tblInsurance.FinanceType7 g-tblInsurance.Age/ g-tblInsurance.ProviderID6 g-tblInsurance))) - G- G- - G,_@ ',_tblInsurance.*- g,_Expr1[RATE]/([Term]/12); o,_[tblInsurance].[Term]4 g,_[tblInsurance].[Type]4 g,_tblInsurance))) ,_ ,_ G+ _[MSysObjects].[Name]3 '+_L@ '+_OtherNameMid([Name],4)>## o%YNY Y  Y dY Y Y Y  Y (Y 0Y  8Y  @Y  HY  PY  XY `Y hY pY xY Y Y Y Y Y Y Y Y Y Y Y Y Y Y  Y!! Y"" Y## Y$$ Y%% Y&&  Y'' (Y(( 0Y)) 8Y** @Y++ HY,, PY-- XY.. `Y// hY00 pY11 xY22 Y33 Y44 Y55 Y66 Y77 Y88 Y99 Y:: Y;; Y<< Y== Y>> Y?? Y@@ YAA YBB YCC YDD YEE YFF  YGG (YHH 0YII 8YJJ @YKK HYLL PYMM XYNN `YOO hYPP pYQQ xYRR YSS YTT YUU YVV YWW YXX YYY YZZ Y[[ Y\\ Y]] Y^^ Y__ Y`` Yaa Ybb Ycc Ydd Yee Yff  Ygg (Yhh 0Yii 8Yjj @Ykk HYll PYmm XYnn `Yoo hYpp pYqq rYrr tYss vYtt xYuu zYvv |Yww ~Yxx Yyy Yzz Y{{ Y|| Y}} Y~~ Y Y Y Y Y Y Y Y Y  Y dY  Y dY Y BankSourceNoDealershipNameInactiveDateJanGoalUnitsJanActUnitsFebGoalUnitsFebActUnitsMarGoalUnitsMarActUnitsAprGoalUnitsAprActUnitsMayGoalUnitsMayActUnitsJunGoalUnitsJunActUnitsJulGoalUnitsJulActUnitsAugGoalUnitsAugActUnitsSepGov1 4yY N Y d Y  Y  Y ChartNameDataQuerySelectClauseGroupByClauseYYPrimaryKeyv1 LVAL Jc l f  SELECT tblRevenueBreakout.[Revenue Source], tblRSELECT tblRevenueBreakout.[Revenue Source], tblRevenueBreakout.[Revenue] FROM tblRevenueBreakoutSELECT qryChartDealsByMake.[Salesman 2], Count(qryChartDealsByMake.[Salesman 2]) AS [CountOfSalesman 2] FROM qryChartDealsByMakeSELECT qryChartDealsByMake.[Salesman 1], Count(qryChartDealsByMake.[Salesman 1]) AS [CountOfSalesman 1] FROM qryChartDealsByMakeSELECT [Payment Type],Count([Payment Type]) AS [CountOfPayment Type] FROM [qryChartDealsByMake]SELECT [Year],Count([Year]) AS [CountOfYear] FROM [qryChartDealsByMake]SELECT [Model],Count([Model]) AS [CountOfModel] FROM [qryChartDealsByModel]SELECT [Make],Count([Make]) AS [CountOfMake] FROM [qryChartDealsByMake]SELECT qryChartDealsByMake.[Ext Warranty Source], Count(qryChartDealsByMake.[Ext Warranty Source]) AS [CountOfExt Warranty Source] FROM qryChartDealsByMakeSELECT [Department],Count([Department]) AS [CountOfDepartment] FROM [qryChartDealsByMake]SELECT [BankSource],Count([BankSource]) AS [CountOfBankSource] FROM [qryChartDealsByMake]  ^ / 7 chaF & I Product Mix Chartc@ **chaDeals By Salesperson 2 ChartqryDeals By Salesperson 2@GROUP BY qryChartDealsByMake.[Salesman 2] HAVING (((Count(qryChartDealsByMake.[Salesman 2]))>0))J>#chaDeals By Salesperson 1 ChartqryDeals By Salesperson 1@GROUP BY qryChartDealsByMake.[Salesman 1]uJ>#chaDeals By Payment Type ChartqryDeals By Payment Typea@GROUP BY qryChartDealsByMake.[Payment Type]uH<"chaDeals By Model Year ChartqryDeals By Model YearI@GROUP BY qryChartDealsByMake.[Year]iD8 chaDeals By Model ChartqryDeals By ModelM@GROUP BY qryChartDealsByModel.[Model]a:.chaDeals By Make ChartqryDeals By MakeI@GROUP BY qryChartDealsByMake.[Make]]8,chaDeals By Ext Warranty Source ChartqryDeals By Ext Warranty Source@GROUP BY qryChartDealsByMake.[Ext Warranty Source] HAVING (((qryChartDealsByMake.[Ext Warranty Source]) Is Not Null))VJ)chaDeals By Department ChartqryDeals By Department[@GROUP BY qryChartDealsByMake.[Department]oD8 chaDeals By Bank Source ChartqryDeals By Bank Source[@GROUP BY [BankSource] HAVING (((qryChartDealsByMake.BankSource) Is Not Null))F:! @@MWJOQJ^kLvLJb\kdoiMQMWJimMWJOQJ^kLvOQfJim`QbmMWJimMWJOQJ^kLvQumsJiiJbmvkdoiMQMWJimMWJOQJ^kLv`J\QMWJimMWJOQJ^kLv`dOQ^MWJimMWJOQJ^kLv`dOQ^vQJiMWJimMWJOQJ^kLvfJv`QbmmvfQMWJimMWJOQJ^kLvkJ^QkfQikdb8MWJimMWJOQJ^kLvkJ^QkfQikdb:MWJimMWJSYfidOoMm`YuMWJim AYNooY  Y dY Y  Y Y Y $Y ,Y 4Y  <Y  DY  LY  TY  \Y dY lY tY |Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y  Y!! Y"" Y##  Y$$ Y%% Y&& $Y'' ,Y(( 4Y)) <Y** DY++ LY,, TY-- \Y.. dY// lY00 tY11 |Y22 Y33 Y44 Y55 Y66 Y77 Y88 Y99 Y:: Y;; Y<< Y== Y>> Y?? Y@@ YAA YBB YCC  YDD YEE YFF $YGG ,YHH 4YII <YJJ DYKK LYLL TYMM \YNN dYOO lYPP tYQQ |YRR YSS YTT YUU YVV YWW YXX YYY YZZ Y[[ Y\\ Y]] Y^^ Y__ Y`` Yaa Ybb Ycc  Ydd Yee Yff $Ygg ,Yhh 4Yii <Yjj DYkk LYll TYmm \Ynn d&ExtWarrantySourceNoNameInactiveDateJanGoalUnitsJanActUnitsFebGoalUnitsFebActUnitsMarGoalUnitsMarActUnitsAprGoalUnitsAprActUnitsMayGoalUnitsMayActUnitsJunGoalUnitsJunActUnitsJulGoalUnitsJulActUnitsAugGoalUnitsAugActUnitsSepGoalUnitsSepActUnitsOctGoalUnitsOctActUnitsNovGoalUnitsNovActUnitsDecGoalUnitsDecActUnitsPctJanUnitsPctFebUnitsPctMarUnitsPctAprUnitsPctMayUnitsPctJunUnitsPctJulUnitsPctAugUnitsPctSepUnitsPctOctUnitsPctNovUnitsPctDecUnitsJanActProfitJanActSalesFebActProfitFebActSalesMarActProfitMarActSalesAprActProfitAprActSalesMayActProfitMayActSalesJunActProfitJuv1v1G jK* i@ DecemberDec   NovemberNov   OctoberOct  SeptemberSep" AugustAug JulyJul JuneJun MayMay AprilApr MarchMar FebruaryFeb  JanuaryJan  G @         eY}6o@}6o@Enter Bank Name HereSystem Defaultdzb=8(aY'N(( Y  Y (DataTypeOperatore! BfalUnitsSepActUnitsOctGoalUnitsOctActUnitsNovGoalUnitsNovActUnitsDecGoalUnitsDecActUnitsPctJanUnitsPctFebUnitsPctMarUnitsPctAprUnitsPctMayUnitsPctJunUnitsPctJulUnitsPctAugUnitsPctSepUnitsPctOctUnitsPctNovUnitsPctDecUnitsJanActProfitJanActSalesFebActProfitFebActSalesMarActProfitMarActSalesAprActProfitAprActSalesMayActProfitMayActSalesJunActProfitJunActSalesJulActProfitJulActSalesAugActProfitAugActSalesSepActProfitSepActSalesOctActProfitOctActSalesNovActProfitNovActSalesDecActProfitDecActSalesPctJanSalesPctFebSalesPctMarSalesPctAprSalesPctMaySalesPctJunSalesPctJulSalesPctAugSalesPctSepSalesPctOctSalesPctNovSalesPctDecSalesJanGoalSalesFebGoalSalesMarGoalSalesAprGoalSalesMayGoalSalesJunGoalSalesJulGoalSalesSepGoalSalesOctGoalSalesNovGoalSalesDecGoalSalesJanGoalProfitFebGoalProfitMarGoalProfitAprGoalProfitMayGoalProfitJunGoalProfitJulGoalProfitSepGoalProfitOctGoalProfitNovGoalProfitDecGoalProfitAugGoalProfitAugGoalSalesPctJanProfitPctFebProfitPctMarProfitPctAprProfitPctMayProfitPctJunProfitPctJulProfitPctAugProfitPctSepProfitPctOctProfitPctNovProfitPctDecProfit Term1 Term2 Term3 Term4 Term5 Term6 Term7 Term8 Rate1 Rate2 Rate3 Rate4 Rate5 Rate6 Rate7 Rate8MoneyFactor1MoneyFactor2MoneyFactor3MoneyFactor4MoneyFactor5MoneyFactor6MoneyFactor7MoneyFactor8CreatedByCreatedDateLastModifiedBy LastModifiedDateInactive#YPrimaryKey/xYNoo''Y  Y dY Y  Y Y Y $Y ,Y 4Y  <Y  DY  LY  TY  \Y dY lY tY |Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y  Y!! Y"" Y##  Y$$ Y%% Y&& $Y'' ,Y(( 4Y)) <Y** DY++ LY,, TY-- \Y.. dY// lY00 tY11 |Y22 Y33 Y44 Y55 Y66 Y77 Y88 Y99 Y:: Y;; Y<< Y== Y>> Y?? Y@@ YAA YBB YCC  YDD YEE YFF $YGG ,YHH 4YII <YJJ DYKK LYLL TYMM \YNN dYOO lYPP tYQQ |YRR YSS YTT YUU YVV YWW YXX YYY YZZ Y[[ Y\\ Y]] Y^^ Y__ Y`` Yaa Ybb Ycc  Ydd Yee Yff $Ygg ,Yhh 4Yii <Yjj DYkk LYll TYmm \Ynn dBankSourceNoNameInactiveDateJanGoalUnitsJanActUnitsFebGoalUnitsFebActUnitsMarGoalUnitsMarActUnitsAprGoalUnitsAprActUnitsMayGoalUnitsMayActUnitsJunGoalUnitsJunActUnitsJulGoalUnitsJulActUnitsAugGoalUnitsAugActUnitsSepGoalUnitsSepActUnitsOctGoalUnitsOctActUnitsNovGoalUnitsNovActUnitsDecGoalUnitsDecActUnitsPctJanUnitsPctFebUnitsPctMarUnitsPctAprUnitsPctMayUnitsPctJunUnitsPctJulUnitsPctAugUnitsPctSepUnitsPctOctUnitsPctNovUnitsPctDecUnitsJanActProfitJanActSalesFebActProfitFebActSalesMarActProfitMarActSalesAprActProfitAprActSalesMayActProfitMayActSalesJunActProfitJunActSalv1 dv@@j nActSalesJulActProfitJulActSalesAugActProfitAugActSalesSepActProfitSepActSalesOctActProfitOctActSalesNovActProfitNovActSalesDecActProfitDecActSalesPctJanSalesPctFebSalesPctMarSalesPctAprSalesPctMaySalesPctJunSalesPctJulSalesPctAugSalesPctSepSalesPctOctSalesPctNovSalesPctDecSalesJanGoalSalesFebGoalSalesMarGoalSalesAprGoalSalesMayGoalSalesJunGoalSalesJulGoalSalesSepGoalSalesOctGoalSalesNovGoalSalesDecGoalSalesJanGoalProfitFebGoalProfitMarGoalProfitAprGoalProfitMayGoalProfitJunGoalProfitJulGoalProfitSepGoalProfitOctGoalProfitNovGoalProfitDecGoalProfitAugGoalProfitAugGoalSalesPctJanProfitPctFebProfitPctMarProfitPctAprProfitPctMayProfitPctJunProfitPctJulProfitPctAugProfitPctSepProfitPctOctProfitPctNovProfitPctDecProfitC$YPrimaryKey<Y.$acP N++.... Y dName+.XK+6YYNamePrimaryKeyv1@@w *.vfVI:,vfTD, o ] N = (   Yamaha Volvo VolkswagenToyota StudebakerSaturn SaabRenault Range RoverPugeot Porsche Pontiac Plymouth Packard OldsmobileNissan MitsubishiMercury Mercedes-BenzMazda Lincoln Lexus Land RoverKiaJeepJaguar Isuzu Hyundai Hundai Hummer Hudson Honda GMCGEOFordFMEagle Dodge Datsun Daewoo Chrysler Chevrolet Cadillac Buick BMWAcura  & *@ @@@ @@   @ JMoiJ,L`s,LoYM\,MJOY^^JM,MWQqid^Qm,MWivk^Qi,OJQsdd,OJmkob,OdOUQ,QJU^Q, S`, SdiO, UQd, U`M, WdbOJ,WoOkdb,Wo``Qi,WobOJY,WvobOJY,Ykoxo,[JUoJi,[QQf,\YJ,^JbOidqQi,^Quok,^YbMd^b,`JxOJ,`QiMQOQkLQbx',`QiMoiv,`YmkoLYkWY,bYkkJb,d^Ok`dLY^Q,fJM\JiO, f^v`domW,!fdbmYJM,"fdikMWQ,#foUQdm,$iJbUQidqQi,%iQbJo^m,&kJJL,'kJmoib,(kmoOQLJ\Qi,)mdvdmJ,*qd^\ksJUQb,+qd^qd,,vJ`JWJ,-x esJulActProfitJulActSalesAugActProfitAugActSalesSepActProfitSepActSalesOctActProfitOctActSalesNovActProfitNovActSalesDecActProfitDecActSalesPctJanSalesPctFebSalesPctMarSalesPctAprSalesPctMaySalesPctJunSalesPctJulSalesPctAugSalesPctSepSalesPctOctSalesPctNovSalesPctDecSalesJanGoalSalesFebGoalSalesMarGoalSalesAprGoalSalesMayGoalSalesJunGoalSalesJulGoalSalesSepGoalSalesOctGoalSalesNovGoalSalesDecGoalSalesJanGoalProfitFebGoalProfitMarGoalProfitAprGoalProfitMayGoalProfitJunGoalProfitJulGoalProfitSepGoalProfitOctGoalProfitNovGoalProfitDecGoalProfitAugGoalProfitAugGoalSalesPctJanProfitPctFebProfitPctMarProfitPctAprProfitPctMayProfitPctJunProfitPctJulProfitPctAugProfitPctSepProfitPctOctProfitPctNovProfitPctDecProfitasco'-esYPrimaryKeyNYN11Y  Y dY SourceNoNameInactiveDate6|S6|S612S|66|S6|S613S|6YYBankSourceNoPrimaryKeyv1 0 0NYN55Y  Y dY SourceNoNameInactiveDate6|S6|S657S|66|S6|S65S|6YYBankSourceNoPrimaryKeyv1@ *@ @@@ @@   @ JMoiJ,L`s,LoYM\,MJOY^^JM,MWQqid^Qm,MWivk^Qi,OJQsdd,OJmkob,OdOUQ,QJU^Q, S`, SdiO, UQd, U`M, WdbOJ,WoOkdb,Wo``Qi,WobOJY,WvobOJY,Ykoxo,[JUoJi,[QQf,\YJ,^JbOidqQi,^Quok,^YbMd^b,`JxOJ,`QiMQOQkLQbx',`QiMoiv,`YmkoLYkWY,bYkkJb,d^Ok`dLY^Q,fJM\JiO, f^v`domW,!fdbmYJM,"fdikMWQ,#foUQdm,$iJbUQidqQi,%iQbJo^m,&kJJL,'kJmoib,(kmoOQLJ\Qi,)mdvdmJ,*qd^\ksJUQb,+qd^qd,,vJ`JWJ,- 4]YN99 Y Td Y dMfgName4t9;:StS:tS:t9<:StYYNamePrimaryKeyv1*8y^E-wXYamahaMotorcycle JeepLibertyJaguarXJ-6 FordThunderbirdFordTaurusFordPintoFordMustangFordGalaxieFordFocusFordFalconFordFairlaneFordExplorerFordExpeditionFordEdselFordBroncoBuickRoadmaster 7 8   @@LidbMd:QOkQ^:QufQOYmYdb:Quf^diQi:SJYi^JbQ:SJ^Mdb:SdMok:UJ^JuYQ:^YLQimv:`dmdiMvM^Q:`okmJbU: fYbmd: idJO`JkmQi:mJoiok: mWobOQiLYiO: u[B:  8 @  @LoYM\idJO`JkmQi:SdiOLidbMd:SdiOQOkQ^:SdiOQufQOYmYdb:SdiOQuf^diQi:SdiOSJYi^JbQ:SdiOSJ^Mdb:SdiOSdMok:SdiOUJ^JuYQ:SdiO`okmJbU: SdiOfYbmd: SdiOmJoiok: SdiOmWobOQiLYiO: [JUoJiu[B: [QQf^YLQimv:vJ`JWJ`dmdiMvM^Q:]YN>> Y Td Y dMfgName4t>D:StS:tS:t>E:StYYNamePrimaryKeyv1  *=y^E-wXYamahaMotorcycle JeepLibertyJaguarXJ-6 FordThunderbirdFordTaurusFordPintoFordMustangFordGalaxieFordFocusFordFalconFordFairlaneFordExplorerFordExpeditionFordEdselFordBroncoBuickRoadmaster j nActSalesJulActProfitJulActSalesAugActProfitAugActSalesSepActProfitSepActSalesOctActProfitOctActSalesNovActProfitNovActSalesDecActProfitDecActSalesPctJanSalesPctFebSalesPctMarSalesPctAprSalesPctMaySalesPctJunSalesPctJulSalesPctAugSalesPctSepSalesPctOctSalesPctNovSalesPctDecSalesJanGoalSalesFebGoalSalesMarGoalSalesAprGoalSalesMayGoalSalesJunGoalSalesJulGoalSalesSepGoalSalesOctGoalSalesNovGoalSalesDecGoalSalesJanGoalProfitFebGoalProfitMarGoalProfitAprGoalProfitMayGoalProfitJunGoalProfitJulGoalProfitSepGoalProfitOctGoalProfitNovGoalProfitDecGoalProfitAugGoalProfitAugGoalSalesPctJanProfitPctFebProfitPctMarProfitPctAprProfitPctMayProfitPctJunProfitPctJulProfitPctAugProfitPctSepProfitPctOctProfitPctNovProfitPctDecProfit?YPrimaryKey)YNooCCY  Y dY Y  Y Y Y $Y ,Y 4Y  <Y  DY  LY  TY  \Y dY lY tY |Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y  Y!! Y"" Y##  Y$$ Y%% Y&& $Y'' ,Y(( 4Y)) <Y** DY++ LY,, TY-- \Y.. dY// lY00 tY11 |Y22 Y33 Y44 Y55 Y66 Y77 Y88 Y99 Y:: Y;; Y<< Y== Y>> Y?? Y@@ YAA YBB YCC  YDD YEE YFF $YGG ,YHH 4YII <YJJ DYKK LYLL TYMM \YNN dYOO lYPP tYQQ |YRR YSS YTT YUU YVV YWW YXX YYY YZZ Y[[ Y\\ Y]] Y^^ Y__ Y`` Yaa Ybb Ycc  Ydd Yee Yff $Ygg ,Yhh 4Yii <Yjj DYkk LYll TYmm \Ynn d&ExtWarrantySourceNoNameInactiveDateJanGoalUnitsJanActUnitsFebGoalUnitsFebActUnitsMarGoalUnitsMarActUnitsAprGoalUnitsAprActUnitsMayGoalUnitsMayActUnitsJunGoalUnitsJunActUnitsJulGoalUnitsJulActUnitsAugGoalUnitsAugActUnitsSepGoalUnitsSepActUnitsOctGoalUnitsOctActUnitsNovGoalUnitsNovActUnitsDecGoalUnitsDecActUnitsPctJanUnitsPctFebUnitsPctMarUnitsPctAprUnitsPctMayUnitsPctJunUnitsPctJulUnitsPctAugUnitsPctSepUnitsPctOctUnitsPctNovUnitsPctDecUnitsJanActProfitJanActSalesFebActProfitFebActSalesMarActProfitMarActSalesAprActProfitAprActSalesMayActProfitMayActSalesJunActProfitJuv17 =   @@LidbMd@QOkQ^@QufQOYmYdb@Quf^diQi@SJYi^JbQ@SJ^Mdb@SdMok@UJ^JuYQ@^YLQimv@`dmdiMvM^Q@`okmJbU@ fYbmd@ idJO`JkmQi@mJoiok@ mWobOQiLYiO@ u[B@  = @  @LoYM\idJO`JkmQi@SdiOLidbMd@SdiOQOkQ^@SdiOQufQOYmYdb@SdiOQuf^diQi@SdiOSJYi^JbQ@SdiOSJ^Mdb@SdiOSdMok@SdiOUJ^JuYQ@SdiO`okmJbU@ SdiOfYbmd@ SdiOmJoiok@ SdiOmWobOQiLYiO@ [JUoJiu[B@ [QQf^YLQimv@vJ`JWJ`dmdiMvM^Q@ "'|YBZ= x K  | U .  e <  q L % Bool2Used only Bool2New only BooleannoBooleanyesNumberis missing"Numberany number between2Numberless than Numbermore than Numberat leastNumberat mostNumberdoes not equal*NumberequalsDateis missing Date2next week Date2last week Date2this week Date2next month Date2last month Date2this month Date2next quarter$ Date2last quarter$ Date2this quarter$ Date2next year Date2last year Date2this year Datetomorrow Datetoday Dateyesterday Dateany date between* Datebefore Dateafter Dateon or before" Dateon or after Dateon Textcontains Textends with Textbegins with Textis not Textis [Y N Y  Y d Y Y MonthIDNameAbbreviationLastDayyae YYPrimaryKeydY$ac NII Y dNamedvQ~ahsysBE_APPVersionv2.00.049G21BUpdated by software: 6/14/2004 1:53:47 PM@&"YNLL Y dNameQLNYPrimaryKeyv1@ tKWarranty MiscellaneousInsurance Finance Environmental Protection K QbqYidb`QbmJ^fidmQMmYdbMSYbJbMQMYbkoiJbMQM`YkMQ^^JbQdokMsJiiJbmvM.YNPPY  Y d Y dVehicleTypeNoMfg Model3dS3dPR7YPrimaryKeyv1 Ot^@,s[@) l U :  VolkswagonVolkswagenToyotaSuzukiSubaruSaturnSaab PontiacPlymouthPeugotOldsmobileNissanMitsubishiMercuryMazda LincolnLand RoverJeep  Isuzu  Hyundai Hummer Honda  GMC FordMustang Eagle Dodge ChryslerChevroletCadillacBuick BMW  O @ @ @ @QQQQQQQQ Q Q  Q  Q  Q Q QQQQQQQQQQQQQQQQQ.YNTTY  Y d Y dVehicleTypeNoMfg Model3dS3dTV7YPrimaryKeyv1@  St^@,s[@) l U :  VolkswagonVolkswagenToyotaSuzukiSubaruSaturnSaab PontiacPlymouthPeugotOldsmobileNissanMitsubishiMercuryMazda LincolnLand RoverJeep  Isuzu  Hyundai Hummer Honda  GMC FordMustang Eagle Dodge ChryslerChevroletCadillacBuick BMW  S @ @ @ @UUUUUUUU U U  U  U  U U UUUUUUUUUUUUUUUUU4YNXXY  Y d Y d Y d Y S7R12MCAHSingle 7 Day Retro 12 Mo Critical4 /S7RAHSingle 7 Day Retro! /.S7NRAHSingle 7 Day Non-Retro& / S7FMAHSingle 7 Day Full Monthly) /S7EAHSingle 7 Day Elim /6S60NRAHSingle 60 Day Non-Retro( /(S60FMAHSingle 60 Day Full Monthly+ /S60EAHSingle 60 Day Elim" /4S45NRAHSingle 45 Day Non-Retro( /&S45FMAHSingle 45 Day Full Monthly+ /S45EAHSingle 45 Day Elim" / S30RAHSingle 30 Day Retro# /2S30NRAHSingle 30 Day Non-Retro( /$S30FMAHSingle 30 Day Full Monthly+ /S30EAHSingle 30 Day Elim" /<S14R6MCAHSingle 14 Day Retro 6 Mo Critical4 /DS14R18MCAHSingle 14 Day Retro 18 Mo Critical6/@S14R12MCAHSingle 14 Day Retro 12 Mo Critical6/ S14RAHSingle 14 Day Retro# /0S14NRAHSingle 14 Day Non-Retro( /"S14FMAHSingle 14 Day Full Monthly+ / S14EAHSingle 14 Day Elim" /,S120FMAHSingle 120 Day Full Monthly- /S120EAHSingle 120 Day Elim$ /S120CAHSingle 120 Day Critical( /JRLCLJoint Residual Life" /JLLTPDCLJoint Level Life w/Tot Perm Dis1 /JLLCLJoint Level Life /JDLTPDCLJoint Decr Life w/Tot Perm Dis0 /JDLCLJoint Decreasing Life$ /9J90NRAHJoint 90 Day Non-Retro' /+J90FMAHJoint 90 Day Full Monthly* /J90EAHJoint 90 Day Elim! /;J7R6MCAHJoint 7 Day Retro 6 Mo Critical1 /CJ7R18MCAHJoint 7 Day Retro 18 Mo Critical3 /?J7R12MCAHJoint 7 Day Retro 12 Mo Critical3 /J7RAHJoint 7 Day Retro //J7NRAHJoint 7 Day Non-Retro% /!J7FMAHJoint 7 Day Full Monthly( /J7EAHJoint 7 Day Elim /7J60NRAHJoint 60 Day Non-Retro' /)J60FMAHJoint 60 Day Full Monthly* /J60EAHJoint 60 Day Elim! /5J45NRAHJoint 45 Day Non-Retro' /'J45FMAHJoint 45 Day Full Monthly* /J45EAHJoint 45 Day Elim! / J30RAHJoint 30 Day Retro" /3J30NRAHJoint 30 Day Non-Retro' /%J30FMAHJoint 30 Day Full Monthly* /J30EAHJoint 30 Day Elim! /=J14R6MCAHJoint 14 Day Retro 6 Mo Critical3 /EJ14R18MCAHJoint 14 Day Retro 18 Mo Critical5/AJ14R12MCAHJoint 14 Day Retro 12 Mo Critical5/ J14RAHJoint 14 Day Retro" /1J14NRAHJoint 14 Day Non-Retro' /#J14FMAHJoint 14 Day Full Monthly* /-J120FMAHJoint 120 Day Full Monthly, /J120EAHJoint 120 Day Elim# /J120CAHJoint 120 Day Critical' /FCLCLCredit Life /M7RFTAH7 Day Retro Full Term% /G7R6MCAH7 Day Retro 6 Mo Critical* /K7R18MCAH7 Day Retro 18 Mo Critical, /I7R12MCAH7 Day Retro 12 Mo Critical, /N14RFTAH14 Day Retro Full Term' /H14R6MCAH14 Day Retro 6 Mo Critical, /L14R18MCAH14 Day Retro 18 Mo Critical. /J14R12MCAH14 Day Retro 12 Mo Critical. /~isysBE_APPCurrentLocC:\Custom F&I Works Back Ends\Complete Insurances\F&IWorks_049G21B.MDBUpdated by software: 6/14/2004 1:53:47 PM  ,Z@ @  @  @@@ @@  @ @@    @ @@@      @@@ 8>i8:`M\8>i8F`M\8>i:>`M8>iiB`M\8>iSm\Di8:`M\Di8F`M\DiB`M\DiSm\M^\[8:6M\[8:6Q\[8:6S`\[8>Q,[8>Q8:`M1[8>Q8:`MBBfQM+[8>Q:>`MBBfQM+[8>S`\[8>bi\[8>i\[8>i8:`M\[8>i8:`MBBfQM+[8>i8F`M\[8>i:>`MBBfQM+[8>i:>`MfM[8>i<6`MfM[8>iBBfQM9[8>iB`M\[8DQBBfQM;[<6Q\[<6Q8:`M2[<6Q8:`MBBfQM+[<6Q:>`MBBfQM+[<6QBBfQM<[<6S`\[<6bi\[<6i\[<6i8:`M0[<6i8:`MBBfQM+[<6i:>`MBBfQM+[<6iBBfQM:[>@Q\[>@S`\[>@bi\[B6Q\[B6S`\[B6bi\[DQ\[DS`\[Dbi\[Di\[Di8:`M\[Di8:`MBBfQM'[Di8F`M\[Di:>`MBBfQM'[Di:>`MfM[Di<6`MfM[DiBBfQM8[DiB`M\[H6Q\[H6S`\[H6bi\[O^\[O^<8<@&[O^6'[O^>8>@([O^>B@6)[O^@8@@*[O^O`[O^O`mY[O^dqQi@@+[O^mY[O^mfO\[O^o<8%[^^\[^^O` [^^O`mY [^^mY[^^mfO\[i^\k8:6M\k8:6Q\k8:6S`\k8>Q\k8>Q8:`M/k8>Q8:`MBBfQM+k8>Q:>`MBBfQM+ k8>QBBfQM6k8>S`\k8>bi\k8>i\k8>i8:`M\k8>i8:`MBBfQM+>k8>i8F`M\k8>i:>`MBBfQM+ k8>i:>`MfMk8>i<6`MfMk8>iBBfQM4k8>iB`M\k<6Q\k<6Q8:`M.k<6Q8:`MBBfQM+k<6Q:>`MBBfQM+ k<6QBBfQM7k<6S`\k<6bi\k<6i\k<6i8:`M-k<6i8:`MBBfQM+k<6i:>`MBBfQM+ k<6iBBfQM5k>@Q\k>@S`\k>@bi\kB6Q\kB6S`\kB6bi\kDQ\kDS`\kDbi\kDi\kDi8:`M\kDi8:`MBBfQM'=kDi8F`M\kDi:>`MBBfQM' kDi:>`MfMkDi<6`MfMkDiBBfQM3kDiB`M\kH6QkH6S`kH6bikO^kO^<8<@kO^6 kO^>8>@!kO^>B@6"kO^@8@@#kO^O`kO^O`mYkO^dqQi@@$kO^mYkO^mfOkO^o<8k^^k^^O` k^^O`mY k^^mYk^^mfOki^Z@ @  @  @@@ @@  @ @@    @ @@@      @@@ 8>i8:`M\8>i8F`M\8>i:>`M8>iiB`M\8>iSm\Di8:`M\Di8F`M\DiB`M\DiSm\M^\[8:6M\[8:6Q\[8:6S`\[8>Q,[8>Q8:`M1[8>Q8:`MBBfQM+[8>Q:>`MBBfQM+[8>S`\[8>bi\[8>i\[8>i8:`M\[8>i8:`MBBfQM+[8>i8F`M\[8>i:>`MBBfQM+[8>i:>`MfM[8>i<6`MfM[8>iBBfQM9[8>iB`M\[8DQBBfQM;[<6Q\[<6Q8:`M2[<6Q8:`MBBfQM+[<6Q:>`MBBfQM+[<6QBBfQM<[<6S`\[<6bi\[<6i\[<6i8:`M0[<6i8:`MBBfQM+[<6i:>`MBBfQM+[<6iBBfQM:[>@Q\[>@S`\[>@bi\[B6Q\[B6S`\[B6bi\[DQ\[DS`\[Dbi\[Di\[Di8:`M\[Di8:`MBBfQM'[Di8F`M\[Di:>`MBBfQM'[Di:>`MfM[Di<6`MfM[DiBBfQM8[DiB`M\[H6Q\[H6S`\[H6bi\[O^\[O^<8<@&[O^6'[O^>8>@([O^>B@6)[O^@8@@*[O^O`[O^O`mY[O^dqQi@@+[O^mY[O^mfO\[O^o<8%[^^\[^^O` [^^O`mY [^^mY[^^mfO\[i^\k8:6M\k8:6Q\k8:6S`\k8>Q\k8>Q8:`M/k8>Q8:`MBBfQM+k8>Q:>`MBBfQM+ k8>QBBfQM6k8>S`\k8>bi\k8>i\k8>i8:`M\k8>i8:`MBBfQM+>k8>i8F`M\k8>i:>`MBBfQM+ k8>i:>`MfMk8>i<6`MfMk8>iBBfQM4k8>iB`M\k<6Q\k<6Q8:`M.k<6Q8:`MBBfQM+k<6Q:>`MBBfQM+ k<6QBBfQM7k<6S`\k<6bi\k<6i\k<6i8:`M-k<6i8:`MBBfQM+k<6i:>`MBBfQM+ k<6iBBfQM5k>@Q\k>@S`\k>@bi\kB6Q\kB6S`\kB6bi\kDQ\kDS`\kDbi\kDi\kDi8:`M\kDi8:`MBBfQM'=kDi8F`M\kDi:>`MBBfQM' kDi:>`MfMkDi<6`MfMkDiBBfQM3kDiB`M\kH6QkH6S`kH6bikO^kO^<8<@kO^6 kO^>8>@!kO^>B@6"kO^@8@@#kO^O`kO^O`mYkO^dqQi@@$kO^mYkO^mfOkO^o<8k^^k^^O` k^^O`mY k^^mYk^^mfOki^ hYNaaY  Y dY  Y pY  Y Y TaxGroupIDTaxGroupNameShowOrderCommentsInactiveCreatedByCreatedDate<<ac<<<ad<YYPrimaryKeyTaxGroupIDv1`_5LCLSDuPage CountyLCLSWisconsinLCLSMcHenry County LCLSLake CountyLCLSCook County ` bbbbb ` bbbbb YNffY Y DataIDfuYAOIndex{6 Ke[ r"wu r:SysAccessObjects{LLLLLLLLLLJ `RCE@xT@@ox`0a$`ajy NomY^+iJmQLvfidqYOQiko``Jiv+Uidof+Yb+Y^l YOQiloGaMXR bS@hPd ebcf_QTePXMSysACEsntsXTKe[ࡱ>  Root Entryদ{h# @RVBA`!^দ{h#VBAProject `!^{h#VBA`!^{h# If .$ !"#%,&'()*+e-/012345678TKLMNOPQRSWV_XY[\]b^Ud /0345789=@BdiroAcessVBAData PROJECTwmPROJECT Wny timesThankz!'&a`exec@ macroAcit doestmot oncC'dHC/"t$M `d% R[TQuit#*)'o#E@p t Access 9.0 Object LibraryG{0002E157-0000-0000-C000-ID="{F699BA49-8C39-44DA-B6F1-C08C0B0BCD21}" Module=basPatches DocClass=Form_frmNoGo/&H00000000 Module=util_dzx_mod_BE_Utility_20030815 Name="db1" HKe[elpContextID="0" VersionCompatible32="393222000" CMG="A2A0AB0B490F490F490F490F" DPB="44464DED4D8E4E8E4E8E" GC="E6E4EF4F3353D454D4542B" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] basPatches=88, 88, 910, 515, Form_frmNoGo=0, 0, 0, 0, C util_dzx_mod_BE_Utility_20030815=88, 116, 716, 627, Z basPatchesbasPatchesForm_frmNoGoForm_frmNoGoutil_dzx_mod_BE_Utility_20030815util_dzx_mod_BE_Utility_20030815Z8DOHXJEILDTOTXDFLYTHCHFZLRRPEEJGLLUQCSYAFXVJ:x XUSOZDHSRVRRDEYJZITTJEULCLXB:Jh NSJGQKIVQRPPFEUKGDNSLEGSBFRN:_VBA_PROJECT  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwyz{|}~k0* pHddb1@= d  @( J< VBIDE> VBIDE *\G{0002E157-:0C  0046}#5.3#0#C:\Program Files\Common Microsoft Shar@ed\VBA6E6EXT.OLB#Visual Basic for Applications Extensibility ?WDAO>DAO5h h5E01fa-h0h;\dao3600.dlle 3.6 Object LibraryHZcbasPatchesG@ basP@tchDe@@LYTHCHFZLRRPEEJGLLUQCSYAF@XVJ28AYTHCFZLR@PzEJGLUQS@ AFXV@MA 1 B,B,Hsy!+BForm_frmNoGoG@FormP_fNG0XUSOZDHSRVRRDEYJZITTJE@ULCLXB0X@(SrZHSU/VRBY*ZU@T@9J@5U@4CMX00"B/(BE2 @util_dzx_mod_BE_U@_2003 0815Gu til@7dzxm6dZB#_.i yQ@20@38 @V5 NSJGQKIVQRPPFEUKGDNSLEGSBFRN N !6QKV`6R`BP 6E` RK`9DaLG5`B R  a) )9b!b!am  *\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 LibraryZ*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3Ke[*\G{00025E01-0000-0000-C000-000000000046}#5.0#0#C:\Program Files\Common Files\Microsoft Shared\DAO\dao360.dll#Microsoft DAO 3.6 Object Library @Z8LYTHCHFZLRRPEEJGLLUQCSYAFXVJ014a64d941basPatchessy 8XUSOZDHSRVRRDEYJZITTJEULCLXB024a64d9413Form_frmNoGo8NSJGQKIVQRPPFEUKGDNSLEGSBFRN034a64d941P@util_dzx_mod_BE_Utility_200308150aP0^7,NGWdIe~yvGX{8[OBG*'20DF /AccessVBAWin16~Win32MacVBA6#db1VBIDEADAO basPatchesq _Evaluate Patch112502GresponseDoCmdƧ SetWarningsMsgBoxR vbInformationn OpenQuery SelectObjects^acTable RunCommand` acCmdCopy26SendKeysN acCmdPaste%(RenameB+Quit9 Form_frmNoGo LCommand12_Click Err_HandlerlExit_Err_HandlerPyErro Description Command4_ClickIZ Form_Open-Cancel ShowToolbarV4 acToolbarNopYMaximizeFyCommand13_Click!Err_Command13_ClickExit_Command13_Clickp, util_dzx_mod_BE_Utility_20030815asd"u Err_EHandle%dzxBackUpInsuranceTable]&4dzx_LINK_TO_FocusBE_InsuranceTable_IN_SAME_DIRECTORYG vbExclamationSKIP Exit_EHandle vbCritical+}Clear xSetLoginTimeL strTableNamestrBackUpTableToXLSNamestrBackUpFullFilePathglstrAppPathAndFileName strAppPath  CurrentDbSInStrRevĈNow%TransferSpreadsheeteacExporth] strTableLINK$xstrMDBDataToLinkTo/!strFULLFileAndPathMDBDataToLinkToMmDFirst DeleteObjectTTransferDatabase)acLinkG%RunSQL`   3 Q 6ot have linked to ZxME ([ZxME R@ +V `dh`fnce `hRa`j`l`n+XKe[ +`f`l`n`z`|`~cB    (T8B   * @P XB`hpx  $ $ 8 0H x   2   B (  0@ `x  ^  ( @ 4P v   H @P X hxTh V' XL -Importing Insurance Rates may not have worked ZPossible Problem...A@dh"Good Job! Insurance Rates Imported Rates ImportedA@kk\^zT :!< `Possible Problem...A@ns :B@bsibi@T]]]]]] p!'l00 l l\$r$ 'n0$tyyyymmddhhmmss$X 'dgr tblInsurance'f f_bak_ d.xls'h n h'j x f jtblInsurance_bak B@v'V^xzpTh,MsgBox Err.Description, vbCritical, APP_NAME :B@b^iT]P]h]]]] p!'l l l\$r$ 'n tblInsurance'f f_LINK'z'GoTo SKIPTEST[Type] MSysObjects[Name]=' z'$Q1 = local; 6 = Linked $ z B@k FocusBE.mdb'| n |'~ Microsoft Access ~ $ f z B@ 'SKIPTEST:DELETE f.* FROM  f; B@P7DoCmd.RunSQL "DELETE tblInsurance.* FROM tblInsurance;" INSERT INTO f SELECT  z.* FROM  z; B@tZDoCmd.RunSQL "INSERT INTO tblInsurance SELECT tblInsurance_Link.* FROM tblInsurance_Link;" $ z B@'X^zT :!< `1May not have linked to Insurance table correctly.A@ :B@b^iFAttribute VB_Name = "util_dzx_mo@d_BE_U O MsgBox "Importing $ Rates may not have worked", vbExclamau, "PossiZProam...0El7Good Job!7D2Infor2HEnd SKIP: Exit_B ԅi +.Descri}?Critical[>rr.ClearCResuNext.!EU() As BooOWDim xSetLoginTi@S@ng strBãB ToXLS FullFilePath(AppAAnd T iI+= CurrentDb.A Left$(,*Rev"\")wK) (FS(Now()@ymmddhhmms6 LLp+`k&&`@x P%@@xX`z{2h@43-11d$(*,66@Ke[t os@d @T @D @ 4 @8$ @P @ @@ p`@$*\Rffff*044093beb2*\R1*#99*\R1*#98*\R1*#25*\R0*#1*\R0*#14*\R1*#a*\R1*#20( B  3(  . +  R0*     d +  *,*, z3  @ 8  (  8 HP`x]@ B@This patch fixes deal numbering in the demo version of F & I Works. This procedure will fix the database even if you've already added new deals. FIW Patch 112502A@46(Fix missing Payment Type in some recordsqryPatch112502a B@ KCopy structure of tblDeals to temp file so that auto number gets reset to 1WS\ $tblDeals B@"C: ( B@&m tblDealsTEMPA@*r{TAB}A@*{UP}A@*l{ENTER}A@*omm , B@&s]Append records from original tblDeals to temp file, letting the system populate DealNo columnqryPatch112502b B@ Rename the tables tblDeals_OLD $tblDeals B@.tblDeals $ tblDealsTemp B@.]All Done! The demo database will now close and you can run the F & I Works demo at any time.  Thank you!A@9Rename the autoexec macro so it doesnt run more than once2DoCmd.Rename "macPatch112502", acMacro, "autoexec"{ENTER}A@* B@0 B@'irAttribute VB_Name = "basPatches" Option Compare Data|e Func8Z112502() As Integer Dim resp0onse8"oCmd.SetWarnings F8alsd?MsgBox "This p fixes deal number7 in themo versof F & I Works.  Droceduiwill&o even if you've already added new p.mdb?< "/I H1a `EMicrosoft AcceX =,qF, Fa ''C RunSQL "DELETE 9[".* 0FROM;" 'RE9;INSERT INTO/  S CT$ le  9_ ce *le SVE_w"P2ee !Xoe_eӱTvbMlRepd tohпcorr`?lyvߤpi hME8> Ke[LLLLS<S<S<<N0{99C1E684-DA0C-48B3-A1AF-83E8D1744574}X 4@ > @ iB.Clo J H %  ," X  x"   (" 08 $@ ,h 2  ("08 @PX`hxxp6`Q Call dzx_DeleteTablesFromWithSpecifiedStringInTableNamePart2Of2("z_DATALog_") B@Bllx8p|h6` :!<A@dd8Ho@@60 'DoCmd.Close(Fi B@0Paymen8|6 :!<A@8o6Call dzxOutputActionToLogFile%Call xLogUser("Opened back End Data")+Call xLogUser("Back End Data Opened", True)Web F B@D B@H8|6 :!<A@8oL B@0N|L :!<A@NoxpAttribute VB_Name = "Form_frmNoGo" Bas0{99C1E684-DA0C-48B3-A1AF-83E8D1744574} |GlobalSpacFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT   O MsgBox "Importing $ Rates may not have worked", vbExclamau, "PossiZProam...0El7Good Job!7D2Infor2HEnd SKIP: Exit_B ԅi +.Descri}?Critical[>rr.ClearCResuNext.!EU() As BooOWDim xSetLoginTi@S@ng strBãB ToXLS FullFilePath(AppAAnd T iI+= CurrentDb.A Left$(,*Rev"\")wK) (FS(Now()@ymmddhhmmssFǦ-tblld3.= & "_bak_" &,< .xls  j4B %.& 1#DoCmd.TsferSpreadshee@t acEx!, 8,*,%I ![%{cH{'?{, APP_N` yIz( ߶̶~zrhoC/Pΰ|MDBaToLi nkݯFULL!6@_p? ??j8; ?;r&.''€i0TEST#p}DFirst("[Type]Pv"MSysObjects[N]='?GeA?'") O6 '1loj; 6Qed =Delete< W<-v > p.mdb?< "/I H1a `EMicrosoft AcceX =,qF, Fa ''C RunSQL "DELETE 9[".* 0FROM;" 'RE9;INSERT INTO/  S CT$ le  9_ ce *le SVE_w"P2ee !Xoe_eӱTvbMlRepd tohпcorr`?lyvߤpi hWQOUTBDYIVATCEUTUPKWCMRHBKYL:>PROJECTKe[!PROJECTwm)AcessVBAData,D  q ]Z`-FFF ڳHtEtCQxCQ-FFFME,SLS S6LLL<0<4<8<<<N0{99C1E684-DA0C-48B3-A1AF-83E8D1744574} 0(% 4p`xk  >`k  @`k iB ` J`k #p0 %2 %F:@x @h @d @T @(D @@4 @X$ @ @ H`0xH:@x @h @d t@T @D @4 @$ @ k@ s:@x @t @ d @8T @PD @h4 @$ @ op@ hP8:@x @t @d @T @D @4 @$ @ @ 0xdX@$*\Rffff*014093be67*\R0*#14*\R0*#19*\R0*#13*\R1*#25*\R1*#98*\R1*#99*\R1*#21 ~48<p@rDtHvLxPzT|X," X  )x<"  < (" 08 $@ ,h 2& < (" Ke[08 @PX`<hxxp06`Q Call dzx_DeleteTablesFromWithSpecifiedStringInTableNamePart2Of2("z_DATALog_") B@Bx8p|h6` :!<A@8Ho@p60 'DoCmd.Close B@08|6 :!<A@8o6Call dzxOutputActionToLogFile%Call xLogUser("Opened back End Data")+Call xLogUser("Back End Data Opened", True)Web F B@D B@H8|6 :!<A@c8oL B@0ryN|L :!<A@{NoxpAttribute VB_Name = "Form_frmNoGo" Bas0{99C1E684-DA0C-48B3-A1AF-83E8D1744574} |GlobalSpacFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT  %Reports&`!^`!^PropData?rScripts%0,`!^P[T-Root Entry GfO7k@RVBA`!^ GfO7VBAProject`!^ fO7VBA`!^ fO71*`!^`!^Blob AjPropData)+C BlobDeltaDirData(-D&PropData.EPropDataCopy Ke[FPropDataGDatabases/41`!^P[T-032`!^`!^Blob DirDataHMSysDbCB0 1CB0 0CB0 9CB0 6CB033!Patch112502x() macPatch112502 1CB0 0CB1 1CB0ji !"#%&'()*+eTKLMNOPQRSWV_XY[i\]b^IUdacfhglmnopqrstvwxyz{|}~PROJECT!PROJECTwm)AcessVBAData, CustomGroups65`!^`!^DataAccessPages `!^`!^ImExSpecsjfO7jfO7"#$%&'(*+/0345789=@B, 0, C util_dzx_mod_BE_Utility_20030815=88, 116, 716, 627, Z basPatchesbasPatchesForm_frmNoGoForm_frmNoGoutil_dzx_mod_BE_Utility_20030815util_dzx l e @ @ghijklmno p q r s tS YNwwY  Y Y  Y < Y < Y Id LValueObjectGuidObjectNameProperty Value<<<wx<<<wy<<<wz<YYYId$ObjectGuidProperty$ObjectNamePropertywHv1b v v v| @ @ @ @ @ @ @ @ @ @ @ @ @ @           !"$%& '#(*+),./0-13452689:7;=>? @<ACDE FBGIJK LHMOPQ RNSUVW T          !!!! !""""" "#####  #$!$#$$$%$ &$"%'%)%*%+%,%-% .%(&/&1&2&3& 4&0'5'7'8'9':';'6(<(>(?(@(A( B(=)C)E)F)G) H)D*I*K*L*M*N*O* P*J+Q+S+T+++ +R,,,,,, , ,- - ------------ ....... .!."./#/%/&/$R{] @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @!! !""""" "#####  #$!$#$$$%$ &$"%'%)%*%+%,%-% .%(&/&1&2&3& 4&0'5'7'8'9':';'6(<(>(?(@(A( B(=)C)E)F)G) H)D*I*K*L*M*N*O* P*J+Q+S+T+++ +R,,,,,, , ,- - ------------ ....... .!."./#/%/&/'/(/)/$0*0,0-0.0/000102030405060 70 80 90 :0 ;0<0=0>0?0@0A0B0}0}0}0}0}0}0}0}0}0} 0} 0 } 0!} 0"} 0#}0$}0%}0&}0'}0(}0)}0*}0+}0,}0-}0.}0+1}1}1}1}1}1} 1}!1}2}"2}$2}%2}&2}'2}(2})2}*2}+2},2}#3}-3}/3}03}13}23}33}43}53}.4}64}84}94}:4};4}<4Z4Z4Z4Z4Z4}75Z5Z5Z5Z 5Z 5Z 5Z 5Z 5Z5Z5Z5Z=Qs  A < @ & 6 @_A#H~P$h }_)j!m/4aymeDescriptionD@ 3' w4aymeType[tblInsuranceAll410].[Type]B w4aymeProviderIDB@1% w4PaymetblInsuranceAll410555 4aymetblInsurance))) O4Payme 4ayme G3 (((tblDeals.DealNo) Is Null))< '3 tblDealsMisctblDealsJ@E9) 3 tblDealsMisc.DealNo2 g3 tblDeals!!! 3 tblDealsMisc))) 3  G3  G3  3  G2 (((tblDeal.StockNo) Is Null))< '2tblDealstblDealD@;/! 2tblDeals.Customer0 g2tblDeals.Tot_Deal_Profit7 g2tblDeals.DealNo. g2 tblDeal 2 tblDeals!!! 2 G2 G2  2 G1tblDealstblDealsMiscJ@E9! 1tblDeals.DealNo. g1tblDealsMisc))) 1tblDeals!!! 1 G1 G1 1 G0.TrucktblDeals.Truck7 w0-DealYeartblDeals.DealYear@! w0,DealMonthtblDeals.DealMonthC# w0+NQD_MemotblDeals.NQD_Memo@! w0*DealPacktblDeals.DealPack@! w0)PaymentSpreadtblDeals.PaymentSpreadO+ w0(CashDowntblDeals.CashDown@! w0'PaymentOuttblDeals.PaymentOutF% w0&PaymentIntblDeals.PaymentInC# w0%Tot_Deal_ProfittblDeals.Tot_Deal_ProfitU/ w0$Tot_FI_ProfittblDeals.Tot_FI_ProfitO+ w0#VehicleProfittblDeals.VehicleProfitO+ w0"MiscProfittblDeals.MiscProfitF% w0!CLDtotaltblDeals.CLDtotal@! w0 DisabilProfittblDeals.DisabilProfitO+ w0LifeProfittblDeals.LifeProfitF% w0CLDtypetblDeals.CLDtype= w0ExtWarrantyProfittblDeals.ExtWarrantyProfit[3 w0ExtWarrantyRetailtblDeals.ExtWarrantyRetail[3 w0ExtWarrantyCosttblDeals.ExtWarrantyCostU/ w0ExtWarrantySourcetblDeals.ExtWarrantySource[3 w0RateSpreadtblDeals.RateSpreadF% w0BuyRatetblDeals.BuyRate= w0RatetblDeals.Rate4 w0ReserveProfittblDeals.ReserveProfitO+ w0BankSourcetblDeals.BankSourceF% w MYNY  Y d Y  Y Y  Y ParameterIDParameterNameTextValueDescriptionShowDeveloperNotes<<<<<<YYPrimaryKeySystemParameterv1