Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx - {N'xeVG84%}kS   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ~VCxS           2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----VCxS     2  ObjectIdSIDACM FInheritablebc ObjectId@D@E>22&&&&&&&$ @Hb@ v@Q70-8aC@D@E?33'''''''% @E@zt@Q70-6C@D@E>22&&&&&&&$ @BBd@@@\}@Q70-5C@D@B>22&&&&&&&$ @?`M@/X@q70-3C@c@B>22&&&&&&&$ @<` @ @Q70-11C@c@B?33'''''''% @9-@ L8@Q70-1C@c@e>22&&&&&&&$ @5ö@ $ö@q5:flight-phxC@ c@eF::......., @2 @ @q37-7C@ c@e>22&&&&&&&$ @/z@@}@q37-4C@c@b>22&&&&&&&$ @,`@b@q37-13C@c@b?33'''''''% @)@"@q37-1C@c@b>22&&&&&&&$ @&@)@@F@q23 multi joinC@]@`G;;///////- @#@@q19:flt-phx-lax-timeC@]@`MAA55555553 @ @@@q16_half_ priceC@ ]@`H<<0000000. @ 2<@H@q14:avgC@]@^@44(((((((& @Z@Z@Q1C@]@^;//#######! @{@I{@multi subselectC@]@^H<<0000000. @,@@/@likeC@ U@ [=11%%%%%%%# @/M{@@V{@groupby havingC@ U@[G;;///////- @#@`@distinct_fareC@U@[F::......., @  6߷@߷@corel_subC@U@[B66*******( @  ҡ@`@Admin@Y2&&&&&&&&&$ VC?S             ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  @eD88,,,,,,,* @3`@@q37-9C@ c@e>22&&&&&&&$ @X1`Qa@Ti@q37-6C@ c@ b>22&&&&&&&$ @0@@@q37-5C@c@ b>22&&&&&&&$ @X.@@@q37-3C@c@b>22&&&&&&&$ @-`o@ @q37-2C@c@b>22&&&&&&&$ @ X+\@f@q37-12C@c@b?33'''''''% @*6>@ G@q37-11C@c@b?33'''''''% @ X(\ @@q3:flightC@c@bB66*******( @'@"@q26:flt-phx-lax-timeC@]@bMAA55555553 @ X%@ @q21:flt-phx-lax-timeC@]@`MAA55555553 @$@Q@ (Q@q2:flightC@]@`B66*******( @ X"@(@=(@q18_add_minC@ ]@`D88,,,,,,,* @!C@@@q17_half_ priceC@ ]@`H<<0000000. @ X:gy@Ngy@q15fare85C@ ]@`B66*******( @u@ cu@q15a_half_ priceC@ ]@^I==1111111/ @X H@H@q11:pass-ticC@]@@^E99-------+ @9@@q10:flt-phx-lax-timeC@]@^MAA55555553 @X%s7@@passenger(@]666*******( @`ޒ@ ꒷@nullC@]@^=11%%%%%%%# @[|@ |@not existsC@]@^C77+++++++) @XVCS             szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationship1;1<1<1<1<1<1<1<ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o jۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o mۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  {qg]SI?5P$BB@ N)ؾ羾@o{ @ @ @ @ @ @ @ @ @ @J7-J7.J7/J70J71J72J73J 74J 75JHJ7)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4D  t  D    D t   flight0<PrimaryKey flight_noPv D08s @  o{ @ @ @ @ @ @ @ @ @ J7-J7.J7/J70J71J72J73J 74J 75JHJ7)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH8RH3SH9SH;SHSH:ZZZZZZZZZZZZZZZZNHNHNHNHOHOH OH!OH"O@@+@ tW[g`uf^[# ?tu}b\vWV]gmjhiwvgurosi|wrm`|afw{ffpYso`pdWX`o#$tu}b\vXV]bpwrgs`vvfphfuva}d`wfhwWs`vvfphfu7tu}b]vXV[gmjhiwv{jwiprs`vvfphfuvrp^ XW7 fv`zhafw{ffpbrufm,vxabrxpwbuf`wfgmjhiwdjvwjpbw,g`ufgmjhiwhurxsa}i`zjph{ifufhurxss`vvbrxpwa}gmjhiwhurxsa}i`zjphhurxsa}i`zjph{ifufkrjphurxsa}vxati`zjphmjlfo`vwfuojpsujbfgmjhiw ov}v`bfvov}vordxmfv!ov}vordxmfvX#ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvoxmwjvxavfmfbw#prwf|jvwv#pxmm#s`vvfphfu#tW#tWV!gmwsi|m`|wjof#tWW!s`vvwjb#tWZ!`zh#tW[`,i`mg,sujbf# tW[g`uf^[# tW\,i`mg,sujbf# tW],i`mg,sujbf# tW^,`dd,ojp# tW_!gmwsi|m`|wjof#tX!gmjhiw#tXW!gmwsi|m`|wjof#tXYoxmwjkrjp#tX\!gmwsi|m`|wjof#tY!gmjhiw#tY]W#tY]WW#tY]WX#tY]WY#tY]X#tY]Y#tY]Z#tY][#tY]\#tY]]#tY]_#tZ!gmjhiwWZ#t[!gmjhiwsi|# t\!gmwsi|m`|#!t]!gmwsi|m`|wjof7t],`dd,ojp7t]VW7t]VWV7t]VWV`7t]VWW7t]VWX7t]VX7t]VY7t]VYb7 t]VZ7 t]V[7 t]V[`7 t]V[a7 t]V\7t]V]7t]V^7t]V^`7t]V^a7t]V_7t^!gmwsi|m`|wjof7t^,vxa,wjof7t_!gmwsi|m`|wjof7t_!krjp7ov}vdao{QGuU%UI p(t\GU%; 3p(uGU; p(GUXGXGA p(wXGUe; `up(GUA p(\GeA p({TGUeuA p(|G%eA p(jG58(HU5W `lp(kPG580H80H"W @p(FG5P `%p(GUX@HX@HeW `rp(lLGEHHHHHHeW Op(GEP p(GueUP p(HGuUeP pp(}GEP p(pGE5P p(~DGP p(Geu%EP p(GP `ip(@G @ @ @ @ @ @ @ @ @ @ @ @ @ @ @          ####  # !# "# ##'#)#*#+#,#-#.#/#0#1#2#3#8797:7<7=7>7?7A7 B7 E7F7G7J7K7Q7T7 U7!V7"WkXkYkZk[Z\k ]k ^k_k`kakbkc"d#e7$f7%ghij#"k$m#$n#%q7(rZsZ tkukwkz { | }~#+!!#%#-'7,#M7Q7k#. H6RH7RH8RH3SH9SH;SHSH:WH@XHCXHEXXHDYYYYZZZZZZ)Use database order for string comparisons@Attribute VB_Name = "Form_FLIGHT" Bas0{02C668C9-C48B-11D0-8B64-444553(540} |Cr@eatablTrue PredeclaId"ExposeFals @TemplateDeriv%Customiz$Option Comp@ DTv ' Uzdorder for sng cisons  {qg]SI?$  t$b-? (     @                        passenger.pass_namepassengerpassenger.@@@ H&&I `R #fENl FYYYYYY YYYYYYYYYYYY Y!Y"Y#Y$Y%Y&Y'Y(Y)Y*Y+ _ _ _ _ _ _ _ _ _ _ _ _ _ _ ________ _!_"_#_$_%_&aaaaaaaaaa a aaadddddddd d dddddddddddddddddd d d! d"!d#!d$!d%"d&"d'"d(#d)#f#f$f$f$f%f%f%f&f&f &f 'f 'f 'f (f(f(f)f)f)f*f*f*f+f+f+f,f,f,f-f-f-f.f .f!.f"/f#/f$/f%0C0C0f&1C1C1C2C2C2C3C3C 3C 4C 4C 4C 5C5C5C6C6C6C7C7CTY,T_T_U_U_U_V_V_V_aaaaaaaa a!a"a#a$dd___a a a aaaa!a!a!a!a,d ,d ,d YYYYYY Y Y Y YYYY( @**1+&23/56989>86:E;2=J>,@PH+A];OdJi$    !"#$% & ' ( ) * +-./0 1 2 3 4,5789:     6            !"# $&'(%)+,-*``@ `jusruwgmjhiwV`jusruwgmjhiwWVgmjhiwufvfuz`wjrpVufgfufpbfVufgfufpbfWVufgfufpbfXVufvfuz`wjrpwjblfwVrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o gmjhiwVgmjhiwVs`vvfphfuVufvfuz`wjrpVwjblfwVwjblfwVwjblfwVte ticket.seat "SH:WH?WHAWHBWH@XHCXHEXXHDYYYYZZZ\ \\\  ticket PrimaryKey  l   @ %Q]uqE:6EDm+CW»BBEASOAfdkJ˭`@ζJ`@m_passeng9@LWF0007@TH66******( dpǘ`@޸`@qryC6S1-09 All information re Swenson passengers [@+b@`uii]QQQQQQO `llS\@llS\@MSysModules,,,,,,,,,,* @J@master@ [333'''''''% @Z@{@ `@qryC6F32 Group by, Having, Where, JoinC@ [@`_SSGGGGGGGE @/M{@o`@qryC6F30 Group by, Havingh C@[@`^RRF::::::8 `ZZi6@Ot6@flight@[333'''''''% @ @ḯ`@qryExample CountC@[@`I==1111111/ @  6߷@`@qryExample Corel_SubselectfoC@`B@`_SSG;;;;;;9 `Z @b{`@qryExample Min, Max, AvgO@[@ mQEE99999997 @  ҡ@xKZ@Admin@-2&&&&&&&&&$ `9.;@ `lS\@ticket@]LWF000@^QE33''''''% ZD@alS\@passenger@]LWF000@\TH66******( Z936@936@SysRel''''''''''% Z336@336@Reports((((((((((& 736@736@Modules((((((((((& x236@x236@Forms&&&&&&&&&&$ MSysRelationships22222222220 MSysQueries,,,,,,,,,,* MSysACEs))))))))))' MSysObjects,,,,,,,,,,* lS\@MSysDbE@;i333'''''''% @Relationships.........., Databases**********( Tables''''''''''% >iVC0TTTTTTTTTTA.[3 mZAj@TA.. @c Gc cc c c c c c c c c c c cc c c c c c c COUNT (itinerary_no), g flight_date# g flight_no! gticket     flight_no! '  flight_date# '  flight_date# g  flight_no! gcount (itinerary_no), g flight_date# g flight_no! gticket     flight_no! '  flight_date# ' COUNT (itinerary_no) > 20 '  flight_date# g  flight_no! gmonth(flight_date) = 7. 'COUNT (itinerary_no), g flight_date# g flight_no! gticket    orig = "PHX" AND dest = "LAX"5 ' COUNT(*) g flight      @ ' flightf1   G     ,@ ' Ticket   G        CLVALǖPP úúÎeeeBæ…((r.confirm_no=[p].[confirm_no]) Aoorig_time > all (select orig_time from flight Where orig = 'PHX'orig_time > all (select orig_time from flight Where orig = 'PHX' and dest = 'LAX')passenger.itinerary_no = ticorig_time > all (select orig_time from flight Where orig = 'PHX'flight.flight_no = reservation.res_flight_norflight.flight_no = reservation.res_flight_no([__itinerary_no] = itinerary_no)orig_time > all (select orig_time from flight Where orig = 'PHX' and dest = 'LAX')passenger.itinerary_no = ticket.itinerary_noflight.flight_no = ticket.flight_no(((passenger.pass_name)="Andy Anderson"))passenger.itinerary_no = ticket.itinerary_no((flight.orig='PHX') AND (flight.dest='LAX') AND (flight.orig_time>#10:10:00 AM#))((t.flight_date=#07/15/92#) AND (p.itinerary_no=[t].[itinerary_no]))not exists (select * from ticket t2 where t1.flight_no = t2.flight_no and t1.flight_date = t2.flight_date and t1.itinerary_no <> t2.itinerary_no)r.confirm_no = p.confirm_no AND res_flight_date = #3/17/92# AND res_flight_no IN (SELECT t.flight_no FROM ticket t, flight f WHERE flight_date = #3/17/92# AND t.flight_no = f.flight_no AND Orig = 'PHX' GROUP BY t.flight_no, flight_date HAVING COUNT (itinerary_no) < 3)month(flight_date) = 7 AND t.flight_no = f.flight_no AND Orig = 'PHX'orig = 'phx' AND dest = 'lax' AND fare = (SELECT MIN (fare) FROM flight f2 WHERE f1.orig = f2.orig AND f1.dest = f2.dest)flight_date BETWEEN #7/15/92# and #8/10/92#VCN            flight_noorigdest orig_time dest_timemealfarew< Q.rC flight_no PrimaryKey@e>22&&&&&&&$ @X1`Qa@Ti@q37-6C@ c@ b>22&&&&&&&$ @0@@@q37-5C@c@ b>22&&&&&&&$ @X.@@@q37-3C@c@b>22&&&&&&&$ @-`o@ @q37-2C@c@b>22&&&&&&&$ @ X+\@f@q37-12C@c@b?33'''''''% @*6>@ G@q37-11C@c@b?33'''''''% @ X(\ @@q3:flightC@c@bB66*******( @'@"@q26:flt-phx-lax-timeC@]@bMAA55555553 @ X%@ @q21:flt-phx-lax-timeC@]@`MAA55555553 @$@Q@ (Q@q2:flightC@]@`B66*******( @ X"@(@=(@q18_add_minC@ ]@`D88,,,,,,,* @!C@@@q17_half_ priceC@ ]@`H<<0000000. @ X:gy@Ngy@q15fare85C@ ]@`B66*******( @u@ cu@q15a_half_ priceC@ ]@^I==1111111/ @X H@H@q11:pass-ticC@]@@^E99-------+ @9@@q10:flt-phx-lax-timeC@]@^MAA55555553 @X%s7@@passenger(@]666*******( @`ޒ@ ꒷@nullC@]@^=11%%%%%%%# @[|@ |@not existsC@]@^C77+++++++) @X{q @@ gmjhiw s`vvfphfuufvfuz`wjrpwjblfw`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`zhafw{ffpbrufm,vxabrxpwbuf`wfgmjhiwov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvov}vdai_VBA_MODULE]xo (SLS S<N0{02C668C9-C48B-11D0-8B64-444553540000}8(\P$Ha`8qI!]5           1llS\@1llS\@flight%%%%%%%%%%% 1llS\@1llS\@distinct_fare,,,,,,,,,,, 1llS\@1llS\@`create flight,,,,,,,,,,,  1llS\@1llS\@count$$$$$$$$$$$  1llS\@1llS\@corel_sub(((((((((((  jlS\@1llS\@between&&&&&&&&&&&  jlS\@jlS\@avg"""""""""""   jlS\@jlS\@Admin$$$$$$$$$$$ jlS\@jlS\@ticket%%%%%%%%%%% jlS\@jlS\@resJI?wwwwww?СSFOPHXD"!qq?qq? LAXPHX!!_qq??СSFOPHX!!_^UUUUUU?qq?PHXSFOL"!\?>>?СPHXSFOB"!X` ` ?88?СPHXSFOB"!؂-؂-?[[?СSFOPHX!!_88?II?zLAXPHX!!_qq?'}'}?zLAXPHX!!_I88?OO?zLAXPHX!!_?qq? SFOPHXB"!hUUUUUU?UUUUUU?fPHXFLGL"!g??MSPPHXL"!f?UUUUUU?PHXMSPL"!e?88?fFLGPHXS"!<??5PHXSFOS"!(88??zPHXLAX!!_#qq?88?zPHXLAXS"!!88??zPHXLAXS"!98?88?zPHXLAXS"!88?98? PHXLAXB"!?88?zPHXLAXB"!n@ @ @ !#(<efg h  I  X\^eUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----n@ @ @ !#(<efg h  I  X\^eUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----NwM%wT1hEuX1 ××××××××××××××Äq^C$§§§§§§§”nUBBB) Y Y Xdflightdflight d d d d d d dd dd d d c Gcorig = 'PHX' and meal <> 'd'4 'cflight Y Xflight X  GX X  seat is null$ 'ticket  G  @ 'tickett1  G  @ ' itinerary_no$ g Res_phone! g Pass_name! gRes_name gPassengerp Reservationr     t.flight_no# '  flight_date# ' COUNT (itinerary_no) > 20 ' dest g orig g  flight_date# g  t.flight_no# gm@ 'COUNT (itinerary_no), gdest gorig g flight_date# g t.flight_no# gflightf tickett     flight_no! '  flight_date# ' COUNT (itinerary_no) > 20 '  flight_date# g  flight_no! gVCN      codenameamount  PrimaryKeyName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  @eD88,,,,,,,* @3`@@q37-9C@ c@e>22&&&&&&&$ @X1`Qa@Ti@q37-6C@ c@ b>22&&&&&&&$ @0@@@q37-5C@c@ b>22&&&&&&&$ @X.@@@q37-3C@c@b>22&&&&&&&$ @-`o@ @q37-2C@c@b>22&&&&&&&$ @ X+\@f@q37-12C@c@b?33'''''''% @*6>@ G@q37-11C@c@b?33'''''''% @ X(\ @@q3:flightC@c@bB66*******( @'@"@q26:flt-phx-lax-timeC@]@bMAA55555553 @ X%@ @q21:flt-phx-lax-timeC@]@`MAA55555553 @$@Q@ (Q@q2:flightC@]@`B66*******( @ X"@(@=(@q18_add_minC@ ]@`D88,,,,,,,* @!C@@@q17_half_ priceC@ ]@`H<<0000000. @ X:gy@Ngy@q15fare85C@ ]@`B66*******( @u@ cu@q15a_half_ priceC@ ]@^I==1111111/ @X H@H@q11:pass-ticC@]@@^E99-------+ @9@@q10:flt-phx-lax-timeC@]@^MAA55555553 @X%s7@@passenger(@]666*******( @`ޒ@ ꒷@nullC@]@^=11%%%%%%%# @[|@ |@not existsC@]@^C77+++++++) @Xa{q @@ @ gmjhiw s`vvfphfuufvfuz`wjrpwjblfw`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`zhafw{ffpbrufm,vxabrxpwbuf`wfgmjhiwdjvwjpbw,g`ufgmjhiwhurxsa}i`zjph{ifufhurxss`vvbrxpwa}gmjhiwhurxsa}i`zjphhurxsa}i`zjph{ifufkrjphurxsa}vxati`zjphov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvov}vda    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   V V@ i'Qu@ l8Gy6.kulS\@.kulS\@master%%%%%%%%%%% ZslS\@.kulS\@like########### ZslS\@ZslS\@groupby subq having33333333333 JqlS\@ZslS\@groupby having where join88888888888 JqlS\@JqlS\@groupby having----------- JqlS\@JqlS\@group pass count by flight99999999999 JqlS\@JqlS\@group by having where44444444444 1llS\@JqlS\@flight%%%%%%%%%%% 1llS\@1llS\@distinct_fare,,,,,,,,,,, 1llS\@1llS\@`create flight,,,,,,,,,,,  1llS\@1llS\@count$$$$$$$$$$$  1llS\@1llS\@corel_sub(((((((((((  jlS\@1llS\@between&&&&&&&&&&&  jlS\@jlS\@avg"""""""""""   jlS\@jlS\@Admin$$$$$$$$$$$ jlS\@jlS\@ticket%%%%%%%%%%% jlS\@jlS\@reservation*********** jlS\@jlS\@passenger((((((((((( jlS\@jlS\@FLIGHT%%%%%%%%%%% jlS\@jlS\@SysRel%%%%%%%%%%% jlS\@jlS\@Scripts&&&&&&&&&&& jlS\@jlS\@Reports&&&&&&&&&&& jlS\@jlS\@Modules&&&&&&&&&&& jlS\@jlS\@Forms$$$$$$$$$$$ jlS\@jlS\@MSysRelationships22222222220 jlS\@jlS\@MSysQueries,,,,,,,,,,* jlS\@jlS\@MSysACEs))))))))))' jlS\@jlS\@MSysObjects,,,,,,,,,,* jlS\@jlS\@MSysDb''''''''''% jlS\@jlS\@Relationships.........., 105jason 104peter 103jane 102joe 101pete  WVWWVXWVYWVZWV[        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----VCEN  __A__               !"#$% & ' ( ) * +-./0 1 2 3 4,5789:     6            FlagMSysQueriesFlag00,!! ExpressionMSysQueriesExpression<<2'' Name2MSysQueriesName222-"" Name1MSysQueriesName122-""AttributeMSysQueriesAttribute::1&&{Qi'Qu@ l8Gy6^@ .kulS\@.kulS\@min price flight/////////// .kulS\@.kulS\@master%%%%%%%%%%% ZslS\@.kulS\@like########### ZslS\@ZslS\@groupby subq having33333333333 JqlS\@ZslS\@groupby having where join88888888888 JqlS\@JqlS\@groupby having----------- JqlS\@JqlS\@group pass count by flight99999999999 JqlS\@JqlS\@group by having where44444444444 1llS\@JqlS\@flight%%%%%%%%%%% 1llS\@1llS\@distinct_fare,,,,,,,,,,, 1llS\@1llS\@`create flight,,,,,,,,,,,  1llS\@1llS\@count$$$$$$$$$$$  1llS\@1llS\@corel_sub(((((((((((  jlS\@1llS\@between&&&&&&&&&&&  jlS\@jlS\@avg"""""""""""   jlS\@jlS\@Admin$$$$$$$$$$$ jlS\@jlS\@ticket%%%%%%%%%%% jlS\@jlS\@reservation*********** jlS\@jlS\@passenger((((((((((( jlS\@jlS\@FLIGHT%%%%%%%%%%% jlS\@jlS\@SysRel%%%%%%%%%%% jlS\@jlS\@Scripts&&&&&&&&&&& jlS\@jlS\@Reports&&&&&&&&&&& jlS\@jlS\@Modules&&&&&&&&&&& jlS\@jlS\@Forms$$$$$$$$$$$ jlS\@jlS\@MSysRelationships22222222220 jlS\@jlS\@MSysQueries,,,,,,,,,,* jlS\@jlS\@MSysACEs))))))))))' jlS\@jVCeN""             FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion")Index1"""73J 74J 75JHJ7)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNi_VBA_MODULEaxo (SLS S<N0{02C668D3-C48B-11D0-8B64-444553540000}8($HME2 @)Use database order for string comparisonsjswv @Attribute VB_Name = "Form_reservation"  Bas0{02C668D3-C48B-11D0-8B64-444553540} |CreatablTrue ]Predecl2aId"ExposeFals @TemplateDeriv%CustomizD$Opx Codmp@ DTv ( 'Uzdorder for Bsng cisons {qggruo,gmjhiweN eNeNeNfNfN fNfN!fN#gNgN gN"gN$hNhN hN hNhNhNININNN\N\N\N^N^N^NN NNN,kS\@,kS\@q37-5$$$$$$$$$$$ /,kS\@,kS\@q37-4$$$$$$$$$$$ .,kS\@,kS\@q37-3$$$$$$$$$$$ -:kS\@,kS\@q37-2$$$$$$$$$$$ ,:kS\@:kS\@q37-13%%%%%%%%%%% +:kS\@:kS\@q37-12%%%%%%%%%%% *:kS\@:kS\@q37-11%%%%%%%%%%% )kS\@kS\@q37-1$$$$$$$$$$$ (kS\@kS\@q3:flight((((((((((( ' kS\@kS\@q26:flt-phx-lax-time33333333333 & kS\@ kS\@q23 multi join----------- % kS\@ kS\@q21:flt-phx-lax-time33333333333 $ kS\@ kS\@q2:flight((((((((((( #kS\@ kS\ @/gƿ;;;EPLEPPLDHDSOCBBPLBHBHHHoooooo  ~]/ `@0qla@_qla@equip_typeE@777+++++++) @%c[la@0Zela@equipment@666*******( @݄`@݄`@~sq_cm_reserv~sq_cs_passeng= *@`@qryC6F13 Flights between 10:00am and 8:00pm C@[@gpddXLLLLLLJ `#@`@qryC6F12 Flights with orig time > 10:00 sC@aB@el``THHHHHHF `Z!C@׬`@qryC6F17 New fare is 1/2 (old + 25 surcharge), >50C@ b@ek__SSSSSSSQ @ Z:gy@uҬ`@qryC6F17 15 and 40 percent discountO@)b@c\PPDDDDDDDB @ H@Q`@qryC6F15 All passengers with flights on 7/15/92 C@b@@cthh\PPPPPPN `,s7@@passenger(@b666*******( @`ޒ@ p`@qryC6F34 Null~ C@FB@cRFF:......, `[|@5`@qryC6F38 Not existsC@b@cL@@44444442 @!llS\@llS\@MSysModules2----------+ ? @ @ @tu}b\gWXgmjhiwv{jwirujhwjof%WV!VV#tu}b\gWYgmjhiwrujh%WV!VVso`pd#^!VVso7tu}b\gWYgmjhiwvafw{ffpWV!VV`o`pd^!VVso#tu}b\gW[`mms`vvfphfuv{jwigmjhiwvrp] W[ _X#tu}b\gW]W[`pdZVsfubfpwdjvbrxpw# tu}b\gW]pf{g`ufjvW XrmdX[vxubi`uhf%[V# tu}b\gW]pf{g`ufjvW Xrmdwifp`ddX[vxubi`uhf%[V# tu}b\gW^gmjhiwv{jwirujhwjoffZ[ojpxwfv7tu}b\gW^rujhjp`wjrpwjofZ[ojpxwfv# tu}b\gX_hurxss`vvbrxpwa}gmjhiwtu}b\gYVhurxsa}i`zjphtu}b\gYWhurxsa}i`zjph{ifuftu}b\gYXhurxsa}i`zjph{ifufkrjptu}b\gYZpxmm#tu}b\gY^prwf|jvwv#tu}b\gY_xvjphvrof7tu}b\gZVxvjph`mm#"tu}b\vWVWgmjhiwvgurogmhwrsi|#tu}b\vWVXsi|gmjhiwvwi`wvfuzf`of`m#tu}b\vWVYgmjhiwvgurosi|wrm`|#tu}b\vWVZgmjhiwvgurosi|wrm`|`gwfuYso#tu}b\vWV[gmjhiwvgurosi|wrm`|afgrufYsoktu}b\vWV\gmjhiwvgurom`|wrsi|afw{ffp^`o`pdWXso#tu}b\vWV]gmjhiwvgurosi|wrm`|afw{ffpYso`pdWX`o#`pdWX`o#pYso`pdWX`o#b\vWWYpf{gmjhiwwjofv{jwid`}mjhiwv`zjphvtu}b\vWWZs`vvfphfumjvwjphgrugmjhiw d`wf!xvfusuroswtu}b\vWW[gmjhiwmjvwjphgrus`vvfphfu!xvfusuroswtu}b\vXVWufvfuz`wjrpgru`pd}`pdfuvrp7tu}b\vXVXgmjhiwjpgruo`wjrpgrusfwfsfwfuvrp7tu}b\vXVYg`ufjpgruo`wjrpgrusfwfsfwfuvrp7tu}b\vXVZwrw`mg`ufva}gmjhiwprgmjhiwd`wf7 tu}b\vXV[gmjhiwv{jwiprs`vvfphfuvrp^ XW7 tu}b\vXV\mr{fvwg`ufvgurosi|wrvgr7tu}b\vXV]bpwrgs`vvfphfuva}d`wfhwWs`vvfphfu7ufgfufpbfX7"ufgfufpbfX7"VC N&&     equip_type equip_dateequip_noH&  PrimaryKey    fW           F   Field1Field2Field3Field4Field5Field6Field7Field8Field9Field10Field11Field12Field13Field14Field15Field16Field17Field18Field19Field20_ID&o  PrimaryKey_{qVCNII            confirm_nores_dateres_name res_phone res_flight_nores_flight_dateKKIK*IL ,.rC confirm_no PrimaryKeyX' and dest = 'LAX')o.itinerary_no = r.itinerary_no AND r.flight_date > dateadd RslS\@slS\@Query1%%%%%%%%%%% QslS\@slS\@Query with some........... PslS\@slS\@query all((((((((((( OslS\@slS\@q9:sub_days*********** NĂlS\@slS\@q9:join&&&&&&&&&&& MĂlS\@ĂlS\@q9:flt-phx-lax-time22222222222 LĂlS\@ĂlS\@q8_sub_time*********** KĂlS\@ĂlS\@q8:flt-phx-lax-time22222222222 JĂlS\@ĂlS\@Q70-9$$$$$$$$$$$ IOlS\@ĂlS\@q70-8b%%%%%%%%%%% HOlS\@OlS\@Q70-8a%%%%%%%%%%% GOlS\@OlS\@Q70-8$$$$$$$$$$$ FOlS\@OlS\@q70-7$$$$$$$$$$$ EOlS\@OlS\@Q70-6$$$$$$$$$$$ D>lS\@OlS\@Q70-5b%%%%%%%%%%% C>lS\@>lS\@Q70-5a%%%%%%%%%%% B>lS\@>lS\@Q70-5$$$$$$$$$$$ A>lS\@>lS\@Q70-4$$$$$$$$$$$ @>lS\@>lS\@q70-3c%%%%%%%%%%% ?>lS\@>lS\@q70-3$$$$$$$$$$$ >k~lS\@>lS\@q70-2$$$$$$$$$$$ =k~lS\@k~lS\@Q70-12%%%%%%%%%%% <k~lS\@k~lS\@Q70-11%%%%%%%%%%% ;k~lS\@k~lS\@Q70-10a&&&&&&&&&&& :m}lS\@k~lS\@Q70-10%%%%%%%%%%% 9m}lS\@m}lS\@Q70-1$$$$$$$$$$$ 8m}lS\@m}lS\@q7_add_min))))))))))) 7m}lS\@m}lS\@q7:flt-phx-lax-time22222222222 ! ȳdzdzdzdzdzdzff8i_VBA_MODULEaxo (SLS S<N0{02C668D3-C48B-11D0-8B64-444553540000}8($" MSysDb#" !MSysDb#   Form_" !MSysDb#   Form_" !MSysDb#   Fo" !MSysDbhMSysDb#hMSysDb# Form_MainmenuB>2.*-Form_m_reserv B>2.*! gruo,o,ufvfuz(gruo,o`jpofpx( ov}vda( ov}vda( ( (ov}vda( (ov}vda( (ov}vda( ov}vda(ongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----+ @ @ @ @ @ @ @ @ @ @   . + , - /                !"#$% & ' ( ) * +-./0 1 2 3 4,5789:     6            ******************``(*3 @ @ @ @.012/35674111111 1 1 11FABCDEG11111111111111111111111111 1# 1% 1& 1' 1( 1) 1* 1$!1+!1-!1.!1/!10!11!12!1,"13"15"16"17"18"2"14#2#2#2#2#2$2$2$2 $2 $2 $2%2 %2%2%2% 2%2 &2&2&2&2&2&2&2&2&2&2&2&2isons VC N--        pass_name itinerary_nofare confirm_noG -/GdGx-0 -WQ'.rD itinerary_no PrimaryKey Reference @ 'tickett1  G  @ 'flight  G  1@ 'flight  G  RES_NAME LIKE 'SWEN*'. 'RESERVATION  G  @ ' itinerary_no$ g Res_phone! g Pass_name! gRes_name gPassengerp Reservationr     t.flight_no# '  flight_date# ' COUNT (itinerary_no) > 20 ' dest g orig g  flight_date# g  t.flight_no# gm@ 'COUNT (itinerary_no), gdest gorig g flight_date# g t.flight_no# gflightf tickett  ޡvlS\@ޡvlS\@null########### .kulS\@ޡvlS\@not exists))))))))))) .kulS\@.kulS\@multi subselect........... !.kulS\@.kulS\@MSysModules2+++++++++++ S{qg @ .012/3564  ntickett1  G  @ 'flight  G  1@ 'flight  G  RES_NAME LIKE 'SWEN*'. 'RESERVATION  G  @ ' itinerary_no$ g Res_phone! g Pass_name! gRes_name gPassengerp Reservationr     t.flight_no# '  flight_date# ' COUNT (itinerary_no) > 20 ' dest @@X, oR5|@@ @ @ gmjhiw s`vvfphfuufvfuz`wjrpwjblfw`dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv`zhafw{ffpbrufm,vxabrxpwbuf`wfgmjhiwdjvwjpbw,g`ufgmjhiwhurxsa}i`zjph{ifufhurxss`vvbrxpwa}gmjhiwhurxsa}i`zjphhurxsa}i`zjph{ifufkrjphurxsa}vxati`zjphmjlfo`vwfuojpsujbfgmjhiw ov}v`bfvov}vordxmfv!ov}vordxmfvX#ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvoxmwjvxavfmfbw#prwf|jvwv#pxmm#ov}vda۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33' /GLORIA ANDERSON  /ANDY ANDERSON  C!TORGIE TORGESON  C!GLORIA ANDERSON  C!ANDY ANDERSON 0PETE SWENSON 0OLGA SWENSON 0SWEN SWENSON h>DAVID PETERSON h>HAZEL PETERSON h>PETE PETERSON  LENA OLSON  OLE OLSON ,@ @ ........ . .  .  .  .   IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----,@ @ ........ . .  .  .  . [9yM#ƹƹƹƹƹƹƦzP&rY6t[8    "d"dateadd"dateadd ('N',45,orig_ti""d"dateadd ('N',45,"dateadd ('N',45,"dateadd ('N',45,"dateadd ('N',45,orig_time)2 g"""d"dateadd ('N"dateadd ('N"dateadd ('N"dateadd ('N',45,o"dateadd ('N',45,o"dateadd ('N',45,""d"dateadd ('N"dateadd ('N"dateadd ('N"dateadd ('N',45,or""dateadd ('N',45,orig_time)2 g" orig_time! g"orig g"flight " " ! fare > 50! '!(fare + 25) / 2' g!fare g!dest g!orig g!flight ! !  ((flight.fare>50))* ' Half Fare [fare]/2+25, o  flight.fare# g  flight.dest# g  flight.orig# g flight       D@  't.seat g t.flight_no# g t.flight_date% g p.pass_name# gtickett passengerp   z[[[[[[[[[[[[[[[[[[[[[[[[[[[[H5" \I6666#mT%ĺĺĺĺĺĺĺħeR?wQ, ¹¹¹¹¹¦bbbbbbbbbbbbbO<)jK([__confirm_no] = confirm_no)5 '__confirm_no Opassengerm_reserv   G  }!@ '}__itinerary_no O}ticketm_passeng }  G} } w1reservation w  Gw1 w1 uticket u  Gu u tAIRLINE_FLIGHT t[MEAL] gt[PRICE] gt [DEST_TIME]# gt [ORIG_TIME]# gt[DEST] gt[ORIG] gt [FLIGHT_NO]# gt t spassenger s  Gs s *flight * max(fare)! g, flight.orig# g,flight.flight_no( g,flight , , +orig = 'PHX' and dest = 'LAX'5 '+ avg(fare)! g+flight + + * * )orig = 'FLG' and dest = 'PHX'5 ')flight ) G) ) 'l@4 ''flight ' G' ' #R@  '#flight # G# # "orig_time >#16:00:00#- '(+6 @ @ @ @ 1# 1% 1& 1' 1( 1) 1* 1$!1+!1-!1.!1/!10!11!12!1,"13"15"16"17"18"2"14#2#2#2#2#2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2&2 &2'2!'2#'2$'2%'2"(2&(2((2)(2*(2+(2,(2-(2')2.)20)21)22)2/*23*25*26*27*24+28+2:+2;+2<+29,2=,2?,2@,2A,5,5,5,2>-5-5-5-5-5.5.5 .5 .5 .5 /5 /5/5/5oLVALgg ƯƯllá~\'Y0000 @ @ @ @ @ 1# oor((flight.orfpassenger.itinerary_no = ticket.itinerary_noflight.flight_no = ticket.flight_nopaspassenger.itinerary_no = ticket.itinerary_noflight.flight_passenger.itinerary_no = ticket.itinerary_noflight.flight_no = ticket.flight_nopassenger.itinerary_no = ticket.itinerary_no(((passenger.pass_name)="Andy Anderson"))fare = (select min(fare) from flight WHERE orig = 'PHX' and dest = 'LAX')orig = 'PHX' and dest = 'LAX' and orig_time >#3:00 PM#orig = 'PHX' and meal in ('B','S','L','D')(((a1.code)=[f1].[orig]) AND ((a2.code)=[f1].[dest]))(((airport.code)=[flight].[orig]))flight.flight_no = ticket.flight_nop.itinerary_no = t.itinerary_no AND f.flight_no = t.flight_no AND p.pass_name Like "Pete P*"p.itinerary_no = t.itinerary_no AND f.flight_no = t.flight_no AND p.pass_name Like "Pete P*"f.orig = 'FLG' and f.dest = 'PHX' and f1.orig = 'PHX' and f1.dest = 'LAX' and f1.orig_time > (f.dest_time + (2/3/24))r.confirm_no = p.confirm_no AND p.itinerary_no = t.itinerary_no AND r.res_name Like "Andy*"p.itinerary_no = t.itinerary_no AND p.pass_name = 'David Peterson' AND exists (Select t1.flight_no FROM passenger p1, ticket t1 WHERE p1.itinerary_no = t1.itinerary_no AND p1.pass_name = 'Olga Swenson' AND t.flight_no = t1.flight_no AND t.flight_date = t1.flight_date)orig = 'PHX' and dest = 'LAX' and orig_time between #3:00 PM# and #12:00 AM#orig = 'LAX' and dest = 'PHX' and orig_time between #8:00 AM# and #12:00 PM#((flight.orig='PHX') AND (flight.dest='LAX'))((flight.orig='PHX') AND (flight.dest='LAX') AND (flight.orig_time Between #10:00:00 AM# And #08:00:00 PM#))ffp]]]]J7$ ƩƩƖpW8%_#s:rY:'‘‘‘‘‘‘‘~kX<<<<<<<<<<<<G3 Greservareservareservareservationpareservationpassereservationpassengreservationpassenger-@reservationpassenger-@reservationpassenger-@reservationpassenger-@,   ~passenger ~  G~ ~ 3 G3^@4 '3flight / G/F@4 '/flight - G-*@4 '-flight 9res_date g9 confirm_no" g9reservation 9 9 8orig_time >#16:00:00#- '8dateadd ('N',45,orig_time)2 g8 orig_time! g8orig g8flight 8 8 3 3 2orig = 'PHX' and dest = 'LAX'5 '2 min (fare)" g2flight 2 2 1\@4 '1flight 1 G1 1 0\@4 '0flight 0 G0 0 / / .orig = 'PHX' and dest = 'LAX'5 '.flight . G. . - - ,-@4 ',Discount Farefare*0.8- o, flight.dest# g)39 @ @ @ @ @ @'2!'2#'2$'2%'2")2.)20)21)22)2/*23*2C*2B*,*24+28+2:+2;+2<+29,2=,2?,2@,2A,5,5,5,2>-5-5H-5F-5G-5.5.5 .5 .5 .5 /5 /5K/5I/5J/5/5/5/5/5/5/5/5/5/5/50505050505151515151525252525 2535!35#35$35%35"45&45(45)45*45'55+55-55.55/55,65065265365465175575775875975685:85<85=85>85?85@85;95A95C95D95E95B)GGuuqGFdd`Fb^EUmm%%d)fqfn`@qW[ϭ`@B1`@s_passeng@]LWF000@ qTH66******( fn`@N`@qryC6S1-11 All Ticket info for Andy A including Airport code[@EB@muui]]]]]][ `efҹ՘`@ `@qryC6S1-10 All Ticket information for Andy Anderson[@0i@gxll`TTTTTTR `V`@`@Reference2++++++++++) U@j@@j@Reference1++++++++++) T`@`@Reference**********( Q:7@ ,@ticket @n333'''''''% @MVY @-F@revenueV@n444(((((((& @' f@\ @reservation@i888,,,,,,,* @Q|@^a`@qryC6F39 Using Some C@7i@mXLL@4444442 `K@ݷ@vK`@qryC6F13 Flight orig > 10:00pm and < 8:00pm )C@8b@jpddXLLLLLLJ `Jq@n`@qryC6S2-09 Round Trip PHX to SFO in 1 day w/ 5 hoursC@i@jmaaUUUUUUUS @GP@0`@qryC6S2-08 Passengers whose duration is LT Avg durationC@i@j|ppdXXXXXXV `ZE@`@qryC6S2-06 Lowest Fares from PHX to SFOC@i@jl``THHHHHHF `BBd@s`@qryC6S2-05 Flights with no Passengers on 8/21 C@B@GrffZNNNNNNL ` k?`M@rOᴬ`@qryC6S2-03 Fare Information for Pete Peterson} ~C@B@GrffZNNNNNNL `Z=y@;`@qryC6S2-12 Flight from FLG to PHX to LAX w/ 40 minHC@"B@Gwkk_SSSSSSQ ` k:`@qd`@qryC6S2-10 Is David P on same flight as Olga SC@i@Dsgg[OOOOOOM ` kZ@W#rF'''''''[1jE {U*i?uK,\CountOfflight_dateCount(ticket.flight_date)C o\ticket.flight_no( g\ \ >p@ 4 '> p.pass_name# g> f.dest_time# g> f.orig_time# g>f.dest g>f.orig g> t.flight_date% g> t.flight_no# g>passengerp >tickett >flightf > > =@ 4 '= f1.dest_time$ g= f1.orig_time$ g=f1.dest g=f1.orig g= f1.flight_no$ g= f.dest_time# g= f.orig_time# g=f.dest g=f.orig g= f.flight_no# g=flightf1 =flightf = = <h@ 4 '<seat g< flight_date# g< flight_no! g< pass_name! g<tickett <passengerp <reservationr < < :C@ 4 ': t.flight_date% g: t.flight_no# g: p.pass_name# g:tickett :passengerp : : 9res_name Like "*And*"- '9res_flight_date' g9 res_flight_no% g9 res_phone! g9res_name g6: @ @ @ @ 0505050505151515151525252525 2535!35N35L35M35"85:85<85=85>85?85@85;95A95C95D95E9898989898989898989898989898989898989898989898989895B:8:8:8:8 :8 :8 :8 :8;8 ;8;8;8;8;8<8<8<8<8<8<8<8<8<8<8=8=8=8 =8!=8"=8#=8$=8%=8&=8'=8(= 8)= 8*=8+=8>8,>8.>8/>80>81>82>83>84>8-9= @ @ @ @ @ @98989895B:8:8:8:8 :8 :8 :8 :8<8<8<8<8<8<8<8<8<8<8=8=8=8 =8!=8"=8#=8$=8%=8&=8'=8(= 8)= 8*=8+=8>8,>8.>8/>80>81>82>83>84>85>86>86>86>86>86>86>86>87>88>8-?;?;?;?;?;?;?;? ;?;@; @; @; @; @;@;@;@;@;@ ;@ ;@; A;A;A;A;A;A;A;A ;A ;A ;A;B; B;"B;#B;$B;!C;%C;'C;(C;)C;&D;*D;,D;-D;.D;+E;/E;0S_* ]1pD1ľľľľľľľľľīP&tUB/ }d:sB  ]M]flight ]flightticket#@4$ ]SumOffareSum(flight.fare)1 o]ticket.flight_date* g]ticket.flight_no( g\ ticket.flight_no( g\ticket ] ] [  flight.dest# g[  flight.orig# g[flight [MaxOffareMax(flight.fare)1 o[ flight.dest# g[ flight.orig# g[ [ F F E@< 'E flight.fare# gEflight.dest_time( gEflight.orig_time( gE flight.dest# gE flight.orig# gEflight.flight_no( gEflight E E B@< 'B flight_no! gBflight B B A  t.flight_date% 'A  t.flight_date% gA  t.flight_no# gAt.flight_no = f.flight_no1 'ASumOffare Sum(f.fare), oA t.flight_date% gA t.flight_no# gAtickett Aflightf A A ?  p.pass_name# g?p@4 '?Total Fare sum (f.fare). o? p.pass_name# g?passengerp ?tickett ?flightf ? ? ?LVALNNNŬ+ĸĸĸĸĸGGw @ @ @ @ @ @ @ @orig_time > some (select orig_tiorig_time > some (select orig_time from flight Where orig = 'MSP' and dest = 'PHX')orig_time > all (select orig_tiorig_time > some (select orig_time from flight Where orig = 'MSP' and dest = 'PHX')orig_time > all (select orig_time forig_time > some oorig = 'PHX' and dest = 'LAX' (((passenger.pass_name)=[Enter Passenger Name]))(((ticket.flight_no)=[Enter Flight Number]) AND ((ticke(((passenger.pass_name)=[Enter Passenger Nam(((passenger.pass_name)=[Enter Passenger Name]))(((ticket.flight_no)=[Enter Flight Num(((passenger.pass_name)=[Enter Passenger(((passenger.pass_name)=[Enter Passenger Name]))(((ticket.flight_no)=[Enter Flight Number]) AND ((ticket.flight_date)=[Enter flight Date]))orig = 'PHX' and dest = 'LAX' and orig_time<#3:00 PM#orig_time > some (select orig_time from flight Where orig = 'MSP' and dest = 'PHX')(flight.orig='PHX') AND (flight.dest='LAX') AND flight.orig_time>=#10:00:00 AM# And flight.orig_time<=#08:00:00 PM#f.orig = 'PHX' and f.dest = 'LAX' and f1.orig = 'LAX' and f1.dest = 'PHX' and f1.orig_time > (f.dest_time + (5/24))((flight.orig="PHX") AND (flight.dest="LAX")) AND (dest_time - orig_time) < (SELECT avg(dest_time - orig_time) from flight WHERE flight.orig="PHX" AND flight.dest="LAX")(((Count(ticket.itinerary_no))>1))flight.flight_no = ticket.flight_noflight.orig="PHX" AND flight.dest="SFO" AND flight.fare In (select min(fare) from flight where orig = 'PHX' and dest = 'SFO')flight_no not in (SELECT f.flight_no FROM flight f, ticket t WHERE f.flight_no = t.flight_no AND t.flight_date = #8/21/92#):@ @ @ @ @>87>88>8-?;?;?;?;?;?;?;? ;?;A;A;A;A;A;A;A;A ;A ;A ;A;B; B;"B;#B;$B;!E;/E;1E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;3E;4E;5E;6E;7E;8E;0F;9F>F>F>F>F>F>F>F >F >F > F;:G> G> G> G>G>G>G>G>G> H>H>H>H>H>H>H>H>H>H>H>I>I> I>!I>"I>#I>$I>%I>&I>'I>J>(J>*J>)W[q^K8[<<<<<<<<<<<<<<<<<<<<<<)mCwLLL9&&&&&&&vL"nD _ f1.orig_time$ g_ f1.flight_no$ g_a2.Phone g_ a2.Location# g_a1.Phone g_ a1.Location# g^flight ^airport ^airport.Elevation) g^ flight.dest# g^ flight.orig# g^flight.flight_no( g] ticket.flight_no( g]ticket ` _ _ ^ ^ J f1.dest_time$ gJ f1.orig_time$ gJf1.dest gJf1.orig gJ f1.flight_no$ gJ f.dest_time# gJ f.orig_time# gJf.dest gJf.orig gJ f.flight_no# gJflightf1 Jflightf J J G@< 'GFlying Time[dest_time]-[orig_time]: oG flight.dest# gG flight.orig# gGflight.flight_no( gGflight G GG G F "@< 'F ticket.flight_date* gF ticket.flight_no( gF#@< 'FCountOfitinerary_noCount(ticket.itinerary_no)E oFticket.flight_date* gFticket.flight_no( gFticket Fflight F GH$@    @@@ @@@ gmjhiw o,s`vvfph$o,ufvfuz#$o`jpofpx#%s`vvfphfuufvfuz`wjrpv,s`vvfph7(v,wjblfwZwjblfwgruoo`burv o`jpofpx sujpwwjblfwv `dojpd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfv1vt,bo,s`vvfph1vt,bv,wjblfw1vt,bo,ufvfuz1vt,bv,s`vvfph#+1vt,bs`vvfphfu1vt,bwjblfwk1vt,bv,wjblfw1vt,bgmjhiw,prk1vt,ggmjhiwk1vt,go,s`vvfph1vt,go,ufvfuzk1vt,gs`vvfphfuk1vt,gv,s`vvfphZ 1vt,gv,wjblfwk`jusruwkftxjs,w}sf#.ftxjsofpw#-gmjhiwgmjhiw,buf{gmjhiw,d`}o`vwfuov}v`bfvov}vordxmfv!ov}vordxmfvX#ov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvprwfvs`vvfphfu#g`uf^[# # tW[g`uf^[# tW[g`uf^[# !gmjhiw#tXW!gmwsi|m`|wjof#tXYoxmwjkrjp#tX\!gmwsi|m`|wjof#tY!gmjhiw#tY]W#tY]WW#tY]WX#tY]WY#tY]X#tY]Y#tY]Z#tY][#tY]\#tY]]#tY]_#tZ!gmjhiwWZ#t[!gmjhiwsi|# t\!gmwsi|m`|#!t]!gmwsi|m`|wjof7t],`dd,ojp7t]VW7t]VWV7t]VWV`7t]VWW7t]VWX7t]VX7t]VY7t]VYb7 t]VZ7 t]V[7 t]V[`7 t]V[a7 t]V\7t]V]7t]V^7t]V^`7t]V^a7t]V_7t^!gmwsi|m`|wjof7t^,vxa,wjof7t_!gmwsi|m`|wjof7t_!krjp7ov}vda=A @ @ @ @E;3E;4E;5E;6E;7E;8E;0F;9F>F>F>F>F>F>F>F >F >F > F;:G> G> G> G>G>G>G>G>G> J>(J>*J>+J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>,J>-J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH)@ @ @J>-J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLHLHLHLHLHLHOHOHOHOHOHOHOHOHOHOHP5P5PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH8RH3SH9SH;SHSH:X@XBXCXAYDYHBYH@YHAYHCYH?ZZZZ[;;[;@[;=[;>[;?[ ;A[ ;B[;<\89\8;\8<\8=\;C\ ;D\ ;E\8:];F];GOLVALbȽǽzz777777777777777777n++bbbŸĸĸĸĸĸĸ]]]]]Ŀÿÿÿÿÿÿÿÿd!!!!££££££££££££££££££` @ @YKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultKKD RecordLocks ODBCTimeoutKKKKD RecordLocks ODBCTimeout  <KKD KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD KeepLocal TKKD KeepLocal TKKD KeepLocal TKKD RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  < ?~ok\MżI:+' xiVGGGGG8lt-phx-lax-- ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   w  n m mۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o m k kۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o k ] \ \ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o \ = < <ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o < : :ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o : 9 9ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 9 8 8ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 8 3 3ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 3 2 2ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 2 1 1ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 1 0 0ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVALXXXXXXǰlIn D^ CnjBBb.{m}6m}lS\@m}lS\@q6:flt-phx-lax----------- 5{lS\@m}lS\@q" " " " . ticket2 m_reserv010" " 5aH% 5aH% &vreservation5UH 1UH _FYYYYYYYYY YYYYYYYYYYYY Y!Y"Y#Y$Y%Y&Y'Y(Y)Y*Y+ _ _ _ _ _ _ _ _ _ _ _ _ _ _ __ _!_"_#_$_%_&aaaaaaaaddddd d dddddd d d! d"!d#!d$!d%"d&"d'"d(#d)#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f#f$f$f$f%f%f%f&f&f &f 'f 'f 'f (f(f(f)f)f)f*f*f*f+f+f+f,f,f,f-f-f-f.f .f!.f"/f#/f$/f%0C0C0f&1C1C1C2C2C2C3C3C 3C 4C 4C 4C 5C5C5C6C6C6C7C7CTY,T_T_U_U_U_V_V_V_aaaaaaaa a!a"a#a$dd___a a a aaaa!a!a!a!a,d ,d ,d YYYYYY Y Y Y YYYYE#f'f 'f 'f )f)f)f*f*f*f+f+f+f,f,f,f-f-f-f.f .f!.f"/f#/f$/f%0C0C0f&1C1C1C2C2C2C3C3C 3C 8C8C8C9C9C9C:C:C:C<C#<C$<C%=C&=h=h>h>h>h?h?h?hAh Ah Ah BhBhBhEhEhEhFhFhFhGhGhGhJh&JlJlKlKlKlKlKlKlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlLlNl Nl Nl Nl Nl Nl OlOlOlPlPlPlQlQlQlRlRlRlSlSlSlTY,T_T_U_U_U_V_V_V_Xd*Xd+Xd,XxYxYxYxYxZxZxZxZx[h'[h([h)\C'\C(\C)]C*]h*]h+^h,^h-^h._h/_h0_h1`h2`h3`h4ah5ax ax aaaaaaaa a!a"a#a$dd___a a a aaaa!a!a!a!a'l'l'l,d ,d ,d Ml Ml!Ml"Ql#Ql$Ql%x x x YYYYYY Y Y Y YYY(& LVAL t$||<HxCr=Xn0Y$tV`@`@V`@`@Reference2++++++++++) U@j5aH% &vf1"  5aH% &vf1.$ZV% &gticket vflight5aH% 5aH% 5aH% 5aH%  gpassenger2vreservation }ticketXpppppppppppppppppppppppppppppppppppppppp]J7wwwwwwwwwwwdQQQQc!@tY!@te e ticke ticket.seat# gee e te ticket.e e e e te ticket.seate ticket.seat# e ticket.seate ticket.seat# ge e e tie ticket.seate ticket.seat# e ticket.seate e e e tie tie ticket.seat# gee ticket.seat# gee ticket.seat# gee ticket.e ticket.e e e te ticket.seate ticket.seat# e ticket.seate ticket.seat# e ticket.e e ticket.seat# geticket.flight_date* geticket.flight_no( geticket.itinerary_no+ gepassenger.pass_name+ ge e Y!@t 'Y__itinerary_no OYticketpassenger Y  GY Qq@< 'Qflight Q GQ Q Ks@ < 'Kflight K GK K J@ < '{q @ @ @ @ @ @ @ @ @J>-J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH3'l9@ @    @@@   @@@tW\,i`mg,sujbf# tW],i`mg,sujbf# tW^,`dd,ojp# tW_!gmwsi|m`|wjof#tX!gmjhiw#tXW!gmwsi|m`|wjof#tXYoxmwjkrjp#tX\!gmwsi|m`|wjof#tY!gmjhiw#tY]W#tY]WW#tY]WX#tY]WY#tY]X#tY]Y#tY]Z#tY][#tY]\#tY]]#tY]_#tZ!gmjhiwWZ#t[!gmjhiwsi|# t\!gmwsi|m`|#!t]!gmwsi|m`|wjof7t],`dd,ojp7t]VW7t]VWV7t]VWV`7t]VWW7t]VWX7t]VX7t]VY7t]VYb7 t]VZ7 t]V[7 t]V[`7 t]V[a7 t]V\7t]V]7t]V^7t]V^`7t]V^a7t]V_7t^!gmwsi|m`|wjof7t^,vxa,wjof7t_!gmwsi|m`|wjof7t_!krjp7t_!vxa,d`}v7txfu}`mm7txfu}{jwivrof7txfu}W7ov}vda۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jl`@f@ANDY ANDERSON602 523 3510."?`@^@TORGIE TORGESON208 222 33330$?@^@ANDY ANDERSON602 523 3510."?`~@e @SWEN SWENSON218 694 8822-!?`~@e@PETE PETERSON218 694 3000."?`~@`~@OLE OLSON218 694 2221*?'@ JJJJJJO        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----'@ JJJJJJVC NNN    codeamtbLNPcodeSsum(amt) gSSGplS\@GplS\@REV""""""""""" 'slS\@GplS\@reservation*********** RslS\@slS\@Query1%%%%%%%%%%% QslS\@slS\@Query with some........... PslS\@slS\@query all((((((((((( OslS\@slS\@q9:sub_days*********** NĂlS\@slS\@q9:join&&&&&&&&&&& MĂlS\@ĂlS\@q9:flt-phx-lax-time22222222222 LĂlS\@ĂlS\@q8_sub_time*********** KĂlS\@ĂlS\@q8:flt-phx-lax-time22222222222 JĂlS\@ĂlS\@Q70-9$$$$$$$$$$$ IOlS\@ĂlS\@q70-8b%%%%%%%%%%% HOlS\@OlS\@Q70-8a%%%%%%%%%%% GOlS\@OlS\@Q70-8$$$$$$$$$$$ FOlS\@OlS\@q70-7$$$$$$$$$$$ EOlS\@OlS\@Q70-6$$$$$$$$$$$ D>lS\@OlS\@Q70-5b%%%%%%%%%%% C>lS\@>lS\@Q70-5a%%%%%%%%%%% B>lS\@>lS\@Q70-5$$$$$$$$$$$ A>lS\@>lS\@Q70-4$$$$$$$$$$$ @>lS\@>lS\@q70-3c%%%%%%%%%%% ?>lS\@>lS\@q70-3$$$$$$$$$$$ >k~lS\@>lS\@q70-2$$$$$$$$$$$ =k~lS\@k~lS\@Q70-12%%%%%%%%%%% <k~lS\@k~lS\@Q70-11%%%%%%%%%%% ;k~lS\@k~lS\@Q70-10a&&&&&&&&&&& :m}lS\@k~lS\@Q70-10%%%%%%%%%%% 9m}lS\@m}lS\@Q70-1$$$$$$$$$$$ 8m}lS\@m}lS\@q7_add_min))))))))))) 7m}lS\@m}lS\@q7:flt-phx-lax-time22222222222 a{q @ @ @ @ @ @ @ @ @J>-J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH8RH3SH9SH;SH-J>.J>/J>0J>1JMGplS\@GplS\@revenue&&&&&&&&&&& SGplS\@GplS\@REV""""""""""" 'slS\@GplS\@reservation*********** RslS\@slS\@Query1%%%%%%%%%%% QslS\@slS\@Query with some........... PslS\@slS\@query all((((((((((( OslS\@slS\@q9:sub_days*********** NĂlS\@slS\@q9:join&&&&&&&&&&& MĂlS\@ĂlS\@q9:flt-phx-lax-time22222222222 LĂlS\@ĂlS\@q8_sub_time*********** KĂlS\@ĂlS\@q8:flt-phx-lax-time22222222222 JĂlS\@ĂlS\@Q70-9$$$$$$$$$$$ IOlS\@ĂlS\@q70-8b%%%%%%%%%%% HOlS\@OlS\@Q70-8a%%%%%%%%%%% GOlS\@OlS\@Q70-8$$$$$$$$$$$ FOlS\@OlS\@q70-7$$$$$$$$$$$ EOlS\@OlS\@Q70-6$$$$$$$$$$$ D>lS\@OlS\@Q70-5b%%%%%%%%%%% C>lS\@>lS\@Q70-5a%%%%%%%%%%% B>lS\@>lS\@Q70-5$$$$$$$$$$$ A>lS\@>lS\@Q70-4$$$$$$$$$$$ @>lS\@>lS\@q70-3c%%%%%%%%%%% ?>lS\@>lS\@q70-3$$$$$$$$$$$ >k~lS\@>lS\@q70-2$$$$$$$$$$$ =k~lS\@k~lS\@Q70-12%%%%%%%%%%% <k~lS\@k~lS\@Q70-11%%%%%%%%%%% ;k~lS\@k~lS\@Q70-10a&&&&&&&&&&& :m}lS\@k~lS\@Q70-10%%%%%%%%%%% 9m}lS\h103 I104 102 p101 p1 P105 `=102 p104 @~103 `=101 M @WOWVWOWVWOWVXOWVXOWVYOWVYO WVZOWVZOWV[O   IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----VC%NRR% %%%        itinerary_no flight_no flight_dateseatRTRU RX, itinerary_no PrimaryKey Reference1 Reference2S{qg Q%ubO;'wdP<(wfUD3  @@@   @@tW\,i`mg,sujbf# tW],i`mg,sujbf# tW^,`dd,ojp# tW_!gmwsi|m`|wjof#tX!gmjhiw#tXW!gmwsi|m`|wjof#tXYoxmwjkrjp#tX\!gmwsi|m`|wjof#tY!gmjhiw#tY]W#tY]WW#tY]WX#tY]WY#tY]X#tY]Y#tY]Z#tY][#tY]\#tY]]#tY]_#tZ!gmjhiwWZ#t[!gmjhiwsi|# t\!gmwsi|m`|#!t]!gmwsi|m`|wjof7t],`dd,ojp7t]VW7t]VWV7t]VWV`7t]VWW7t]VWX7t]VX7t]VY7t]VYb7 t]VZ7 t]V[7 t]V[`7 t]V[a7 t]V\7t]V]7t]V^7t]V^`7t]V^a7t]V_7t^!gmwsi|m`|wjof7t^,vxa,wjof7t_!gmwsi|m`|wjof7t_!krjp7t_!vxa,d`}v7txfu}`mm7txfu}{jwivrof7txfu}W7ufvfuz`wjrp7ufz7ufzfpxf7ov}vda g@  f@  g@  f@  @13B  ^@12B  ^@12C  @8B  ^@12B  @8C @22C \ @13C h@8D e @10C @22B \ @13B h@8C e @10B @22A \ @13A h@8B e @10A h@4B f@10B e@3B h@4C g@15B f@10C e@3C h@4D g@15A f@10D e@3D I~@12E `~@10E I~@12D `~@10D Q@ @ @ @ @ SSSSSSSSSS S S S S SSSSSSSSSSSSS S S S S S S  S! S" S# S$setni  Id ParentIdName        ۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''۱7@alS\@FLIGHT\@LWF000#@VQE33''''۱7@alS\@FLIGHT\@LWF000#@VQE3۱7@alS\@FLIGHT\@LWF000#@VQE33''''''% mllS\@llS\@MSysModules,,,,,,,,,,* jllS\@llS\@MSysModules2----Q@@@@@@@@@SISSISeSfSgShSeSfS gS hS eS fS hSeShS\SSeShS\SSeShS\SS S ^S S ^S ^S S  fS! gS" fS# gS$}7{*reservationticketticketflight_datereservationres_flight_dateI:/$ flightreservationreservationres_flight_noflightflight_noE<6) airportflight1flightdestairportCode0,%! airportflightflightorigairportCode/+$  Reference2ticketitinerary_nopassengeritinerary_no>2) Reference1ticketflight_noflightflight_no5,& Referencepassengerconfirm_noreservationconfirm_no>4) ,@ @ .......... . . . 5@ MSysObjectsCStr(Database)"3Q@ @ @ @ @ SSeSeSeS eSeSeSfSfS fS fS!fS#gSgS gS"gS$hShS hShShShSISISSS\S\S\S^S^S^SS SSSS\@{lS\@q37-4$$$$$$$$$$$ .{lS\@{lS\@q37-3$$$$$$$$$$$ -6zlS\@6zlS\@q37-2$$$$$$$$$$$ ,6zlS\@6zlS\@q37-13%%%%%%%%%%% +6zlS\@6zlS\@q37-12%%%%%%%%%%% *6zlS\@6zlS\@q37-11%%%%%%%%%%% )6zlS\@6zlS\@q37-1$$$$$$$$$$$ (6zlS\@6zlS\@q3:flight((((((((((( '6zlS\@6zlS\@q26:flt-phx-lax-time33333333333 &bMylS\@bMylS\@q23 multi join----------- %bMylS\@bMylS\@q21:flt-phx-lax-time33333333333 $bMylS\@bMylS\@q2:flight((((((((((( #bMylS\@bMylS\@q19:flt-phx-lax-time33333333333 "bMylS\@bMylS\@q18_add_min*********** !xlS\@bMylS\@q17_half_ price...........  xlS\@xlS\@q16_half_ price........... xlS\@xlS\@q15fare85((((((((((( xlS\@xlS\@q15a_half_ price/////////// xlS\@xlS\@q14:avg&&&&&&&&&&& ޡvlS\@xlS\@q11:pass-tic+++++++++++ ޡvlS\@ޡvlS\@q10:flt-phx-lax-time33333333333 ޡvlS\@ޡvlS\@Q1!!!!!!!!!!! ,ޡvlS\@ޡvlS\@passenger((((((((((( ޡvlS\@ޡvlS\@null########### .kulS\@ޡvlS\@not exists))))))))))) .kulS\@.kulS\@multi subselect........... !.kulS\@.kulS\@MSysModules2+++++++++++ I-o`QB qbO@1"s~o`\M>  itinerary_no flight_no flight_dateseatT  ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   1!ȇg:˅====EEÃ?''¬7}ǖ`@Uі`@fn`@sѭ`@ѭ`@~sq_fs_passeng *@JBGGG;//////- `rϭ`@I`@s_ticket@]LWF0002@SG55))))))' {@`@qryC6F31 Group by, Having, Where C@-b@`eYYMAAAAAA? `"@(@*̬`@qryC6F18 Origination time + 45 minutes C@,b@ek__SGGGGGGE `[ǖ`@Bz`@qryC6S2-13 Max Fares for Flights from and to every airportO@%B@Gssg[[[[[[Y `F@r`@qryC6S2-07 Cnt of Passengers by date, GT 1 Passenger C@ B@@jymmaUUUUUUS `>@"˖`@qryC6S2-02 Flight Information for Pete Peterson{C@B@Gthh\PPPPPPN `8F@5R?`@qryC6F18 Flights with orig timee + 45 minutesu C@6b@DrffZNNNNNNL `2 @u>`@qryC6S2-20 Lowest fare from PHX to LAXwC@4b@Dk__SGGGGGGE `-`o@I`@qryC6S1-02 PHX flights that serve a mealy +O@>i@jmaaUIIIIIIG ` @@\x֬`@qryC6F17 New fare is 1/2 old, then add 25 surcharge, > 50v C@*b@e~rrfZZZZZZX `@Y|@K`@qryExample Group by, Subselect, HavingC@ [@`_SSGGGGGGGE @ <{@B `@qryC6F29 Group pass count by flightC@[@`\PPDDDDDDDB @ @\`@qryExample BetweenC@[@\K??33333331 @4u@alS\@reservation"@]LWF000y@^VJ88,,,,,,* ۱7@ G`@flight\@]LWF000#@\QE33''''''% [636@[636@Scripts((((((((((& LVALȽzzǾ{{8]]ww4s.kulS\@.kulS\@MSysModules******.kulS\@.kulS\KKDValidationRuleValidationText ColumnKKDValidationRuleValidationText ColumnWidthKKD KKD RecordLocks ODBCTimeoutKKD RecordLocks ODBCTimeout  <KKD KeepLocal TKKD KeepLocal TKKD RecordLocks ODBCTimeout  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLength DecimalPlaces? code       ? name       g amount    $#,##0.00;($#,##0.00)    0  KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthM flight_no      0  ? orig       ? dest       M orig_time     Short Time  M dest_time     Short Time  ? meal       e fare    $#,##0.00;($#,##0.00)   0  KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <zLVAL:::SI?  5aH% &vflight" 5UH 0cghijwkT passengerPassenger Itinerary d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf`5 FormHeader1d25]7`ab cdText12Passenger Itineraryd257`axb cdText13Passenger Itinerary`yDetail0m7U`axb pass_name pass_named5U`axbcText15 pass_name:m7U`aXb+k itinerary_no itinerary_noGeneral Numberd5U`aXbcText17 itinerary_no:m7U`a8bkfarefare$#,##0.00;($#,##0.00)d5U`a8b@cText19fare:m7U`ab+k confirm_no confirm_noGeneral Numberd5U`abcText21 confirm_no:p3U`apbcdticket Form.ticket itinerary_no itinerary_no` FormFooter2 0cgflightflight d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf`5 FormHeader1d25]7`abcdText12flightd257`axbcdText13flight`/ Detail0m7U`0axb+ flight_no flight_nod5U`axbcText15 flight_no:m7U` axb korigorigd5U` axb@cText17orig:m7U`axb kdestdestd5U`0axb@cText19dest:m7U`@ aXbk orig_time orig_time Short Timed5U`aXbcText21 orig_time:m7U`aXbk dest_time dest_time Short Timed5U`0aXbcText23 dest_time:m7U` a8bkmealmeald5U`Pa8b@cText25meal:m7U`a8bkfarefare$#,##0.00;($#,##0.00)d5U` a8b@cText27fare:` FormFooter2LVAL lÅÅîͬ pdDESTFormHeader1Detail0mFLIGHT_DATEd Text17mSEATd Text19oFLIGHT_NOd Text20FormFooter2 itinerary_noͬ pdDESTForͬ mPdDESTFormHeader1fLine20d Text23d Text24Detail0mPASS_NAMEmITINERY_NOFormFooter2itinerary_no fare CONFIRM_NOͬ pdDESTFormHeader1Detail0mFLIGHT_DATEd Text17mSEATd Text19oFLIGHT_NOd Text20FormFooter2 itinerary_noͬb hdDESTFormHeader1Detail0mitinerary_nod Text13mflight_nod Text15mflight_dated Text17mseatd Text19 FormFooter2ͬbhdDESTFormHeader1Detail0eBox10mpass_named Text12eBox13mitinerary_nod Text15eBox16m fared Text18e Box19m confirm_nod Text21FormFooter2ͬbhdDESTFormHeader1d Text12d Text13Detail0mpass_named Text15mitinerary_nod Text17mfared Text19m confirm_nod Text21p ticket FormFooter2ͬbhdDESTFormHeader1d Text12d Text13Detail0mflight_nod Text15morigd Text17mdestd Text19m orig_timed Text21m dest_timed Text23mmeald Text25mfared Text27FormFooter2cLVALss]uqE:6E[)KMR6ysM.kulS\@.kulS\@M5a%P&vflightflightWpassengerpassenger Xyreservationreservation ticketticket 0c gticket d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf` FormHeader1`Detail0m7U`axb+ itinerary_no itinerary_noGeneral Numberd5U`axbcText13 itinerary_no:m7U`aXb+k flight_no flight_noGeneral Numberd5U`@aXbcText15 flight_no:m7U`a8bHk flight_date flight_date Short Dated5U`a8bcText17 flight_date:m7U`ab kseatseatd5U`ab@cText19seat:` FormFooter2 0c g passenger di1bcghj1bcghm5ghjnhikojkm` FormHeader1`P Detail0e5]`axb cXBox10m7`awb pass_name pass_named5`abcText12 pass_name:e5_`abcXBox13m7`abk itinerary_no itinerary_noGeneral Numberd5`abcText15 itinerary_no:e5_`a(bcXBox16m7`a'bpkfarefare$#,##0.00;($#,##0.00)d5`a7bcText18fare:e5_`abcXBox19m7`abk confirm_no confirm_noGeneral Numberd5`abcText21 confirm_no:` FormFooter2=.~ok\MI:+' ÇÇÇÇÇxteVC4%   o n nۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o d c cۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o c   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o     ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o      ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   V Vۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o V U Uۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o U T Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o VLVALXdddƼ x((((€m+WfU"t.kulS\@.kulS5UH &vRESERVATION" " " 5UH 5UH 5UH 5aH% &gticket5UH 5UH &vflight5UH *~ok\\\\MżI:E6A2 {lۇ e eۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o e d dۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  !ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ! !ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ! ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVAL9ȽǕŕŕŕŕŕŕRRRRRRR(((((__/©©©©N  [.kulS\@.kulS\@MSysModules*********** .kulS\@.kulS\@min price flight///////////KKD8 RecordLocks ODBCTimeout Replicable MaxReKKKD RecordLocks ODBCTimeoutKKD RecordLocks ODBCTimeout  <KKD KeepLocal TKKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD RecordLocks ODBCTimeout  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD KeepLocal TKKD RecordLocks ODBCTimeout  <KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLength DecimalPlacesD pass_name       g itinerary_no       0   General Numbere fare    $#,##0.00;($#,##0.00)    0  e confirm_no       0   General NumberKKD RecordLocks ODBCTimeout  <LVAL ddd$$$$|||||,5UH " "% " " " " " 5UH &gp gt5UH 5aH% &gticketsE`QB>/////// ŞŞŞŞŞŏ |miZK<8))))))) } ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o % } ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o }  }ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o }  q j jۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o j X  Xۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o X  # " "ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o " ! !ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o !    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  , ,ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ,  ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    LVAL d5UH&vr gp5UH&vr gp5UH&vr gp2vf5UH&vr gp2vf&~t5UH 5UH 5UH 5UH &vflightU1~~~~~~~~~~ok\MI:+' xteVRClS\@q6m}lS\@m}lS\@q6:flt-phx-lax0 0 t  s ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o s  sۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o s  r rۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o r q qۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 0 / /ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o / . .ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o . - -ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o - , ,ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o , + +ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o + * *ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o * ) )ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ) ' 'ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ' # #ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o HLVALXXǰ``ŸhpnY%RNg6m}lS\@m}lS\@q6:flt-phx-lax----------- 5{lS\@m}lS\@q5:fl" " " " 1UH 1UH 5UH 1UH 1UH 5UH 5UH -6~ozk\\\\MI:::::::+' ÇÇÇÇÇxiteVRC4a ` `ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ` _ _ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o _ ^ ^ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ^ ] ]ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o [ [ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o [ J G Gۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o G F Fۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o F E Eۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o E B Bۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o B A Aۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o A ? ? ?ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o > >ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o > = =ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o 5LVAL?ȽǽǽǽǽǽǽǽėTTTTTTÞCCCCCCCC¥¥¥`6 KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputKKD8 RecordLKKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD RecordLocks ODBCTimeoutKKD, RecordLocks ODBCTimeout MaxRecords  <KKD KeepLocal TKKD KeepLocal TKKD AccessVersionBuild%  07.53 KKD RecordLocks ODBCTimeout  <KKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthe confirm_no      0   General NumberIres_date      m/d/yyCres_name       D res_phone       h res_flight_no      0   General NumberPres_flight_date      m/d/yyKKD RecordLocks ODBCTimeout  <rLVALX$$$0<<<<ÔDoƁv(5UH &vflight" " " " 5UH &vflight5aH% &vflight5aH% &vflight5aH% &vflight gticket5aH% NȫW!!% ~8@wt -խ`@t -խ`@~sq_fm_reserv*@[:::......., uӭ`@ӭ`@~sq_fs_ticket*@MBFFF:......, `tΓӭ`@Γӭ`@~sq_cs_ticket~sq_cFLIGHT_NO*@KBHHH<<<<<<<: @b`@ݐY`@qryC6S1-05 Flights from PHX to LAX before 3pm [@0B@qrffZNNNNNNL `t`@f7T`@airport;@444(((((((& @a!tۖ`@AI`@qryC6S2-19 Max fares from each orig, GT 100+ [@3b@jpddXLLLLLLJ ``ˮږ`@%`@qryC6S2-18 Max fare for flights from each orig airportG[@(i@ j{oocWWWWWWU `_Jٖ`@񓸬`@qryC6S2-17 Info for flights incl orgin elevation and phone[@n@ cssg[[[[[[Y `^>ؖ`@v)9`@qryC6S2-16 Flights sorted by orig elevation, high to low% [@'i@ G}qqeYYYYYYW `]Kז`@`@qryC6S2-15 Total fares for each flight [@i@ Dk__SGGGGGGE `\GB֖`@^A`@qryC6S2-14 Number of tickets for each flight8[@(B@ jqeeYMMMMMMK `<` @O`@qryC6S2-11 Reservations made by Andy AC@!B@Gk__SGGGGGGE `A@@2`@qryC6S2-04 Total Fares by Flight No, Flight Date C@B@@Guii]QQQQQQO `9-@: T`@qryC6S2-01 Reservation for Andy Anderson yC@b@DmaaUIIIIIIG `ZJ`@J`@~sq_fpassengerw*@nGGG;//////- `Y7I`@EJ`@~sq_cpassenger~sq_cticket u*@nRRRF::::::8 `XeI`@gI`@~sq_fflight *@[DDD8,,,,,,* `W tĎS\@VNZ@AccessLayout*@b.E99-------+ @7~ok\\\\MżI:+' xt @Referencw ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o w  wۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o u ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o u  uۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o u  t ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o t  tۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o h g gۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o g f fۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o f Q Qۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Q M Mۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o M ' 'ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ' Q Qۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Q K Kۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o K J Jۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o DLVAL  dddƼllD{,(Dx6PyD 5UH " 5UH 5UH 2cgheij#kѭ`@ passenger d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf`h FormHeader1f3U`a,bO Line20d25U7` bcd eText23I. No.Ariald5U7`bcd eText24 PassengerArial`Detail0m457U`b PASS_NAME PASS_NAMEm457U` bk ITINERY_NO ITINERY_NO` FormFooter25UH " " " 5aH% &vflightLVAL)ȪĞtJJJJJJJJJJJJJààààQQQQKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnKKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKDKKD8 RecordLocks ODBCTimeout Replicable MaxRecordsKKD8 RecordLocks ODBCTimeout Replicable MaxRecords  <KKD, RecordLocks ODBCTimeout MaxRecords KKD, RecordLocks ODBCTimeout MaxRecords KKD, RecordLocks ODBCTimeout MaxRecords KKD, RecordLocks ODBCTimeout MaxRecords  <KKD, KKD, RecordLocks ODBCTimeout MaxRecords  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKD, RecordLocks ODBCTimeout MaxRecords  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD KeepLocal TKKD KeepLocal TKKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthg itinerary_no      0   General Numberd flight_no      0   General NumberO flight_date     Short Date  ? seat       KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequiredAllowZeroLength DecimalPlaces? code       d amt    $#,##0.00;($#,##0.00)    0  LVAL p<*x!fmx!b%x?h   <@Ot6@flight@#;CK[ks 8@HXhp0000000#;CK[ks                 f1.flight_noflightf1.origf1.destf1.orig_time f1.dest_timef1.mealf1.fare@x`@ #<`x ;<`x C<`x K<`x [<`x k<`x s<`xf1x`xOt6@qryExample Corel_Subselect  8 @ H X h p 8@HXhp#<`x ;<`x C<`x K<`x [<`x k<`x s<`x flight #  ;  C  K  [  k  s  8@HXhp  x0Pp                                                            @` ` ` ` ` ` ` | Lbx@pLVAL p0 @ p 0D@p0`flight PrimaryKey flight_nov v@ xs 8flight  @p !(  P,  @dest'lax',$04@hD origl'phx' pfare  PH (``@ @Hx z @ hx( flight   ,DPT`d  f2.dest  @ f1.dest  f2.orig   f1.orig@h0 iLVALXXXXXǏŏŏ0cgheij#kbAIRLINE_TICKET d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf` FormHeader1`Detail0m7U`a8b FLIGHT_DATE FLIGHT_DATEd5U`%a8b+cText17Date:m7U`ab kSEATSEATd5U`4abcText19Seat:o5U`bc dXen FLIGHT_NO FLIGHT_NO Table/Query^Select [FLIGHT_NO],[ORIG],[DEST],[ORIG_TIME],[DEST_TIME],[PRICE],[MEAL] Fro0cgheij#kbAIRLINE_TICKET d7ee1i14bcgfj14bcgf 029cgh ijkt֭`@ passengerPassenger Information:!L&qflightflightWpassengerpassenger Xtreservationreservation ticketticket2cgheij#kѭ`@ passenger d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjf`h FormHeader1f3U`a,bO Line20d25U7` bcd eText23I. No.Ariald5U7`bcd eText24 PassengerArial`Detail0m457U`b PASS_NAME PASS_NAMEm457U` bck ITINERY_NO itinerary_no` FormFooter2" LVALNQlQlQlTY,T_T_U_U_U_V_V_V_Xd*Xd+Xd,XxYxYxYxYxZxZxZxZx[h'[h([h)\C'\C(\C)]C*]h*]h+^h,^h-^h._h/_h0_h1`h2`h3`h4ah5ax ax bxbxbxc_'ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#!L&qflightflightWpassengerpassenger XtreservationreservationBticketticket1airportairportX;airport_1airportLVAL <h f sbx?ff`f(f <wfffffffpffffffffffffffwfffffff                flight.flight_noflight flight.orig flight.destflight.orig_timeflight.dest_time flight.meal flight.fareHf@ffff`@HfPf wfDx fDx fDx fDx fDx fDx fDx flightfff ffOt6@,qryC6F12 Flights with orig time > 10:00Pf pf`f fhf fpf fxf ff ff ffpfffffff wfDxh fDx fDx fDx fDx fDx fDx flight wf(f f0f f8f f@f fHf fPf fXfpfffffff f8fpff@f`ffff`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`f f`ffPfff@f f pf f pf f @f f @f f pf f @f f |f Xff`f\xPf f ff ff0 f f` f0f f@fLVAL] e1|iVC* ^2qW*n[B#sP(wP-Y Xflight X  GXYticketpassenger Y  GY S code gSsum(amt) gScode gSrevenue S S R orig = 'PHX'$ 'Rmeal gR flight_no! gRorig gRflight R R Qq@< 'Qflight Q GQ Q Pg@< 'Pflight P GP P OV@< 'O,@< gO r.flight_date% gO o.flight_date% gOo.itinerary_no& gOticketr Oticketo O GO O ND@< 'Nt.seat gN t.flight_no# gN t.flight_date% gN p.pass_name# gNtickett Npassengerp NY7I`@EJ`@~sq_cpassenger~sq_cticket::::::::::8 XeI`@gI`@~sq_fflight r*@bDDD8,,,,,,* `W tĎS\@ܦÞ\@AccessLayout*@b@qE99-------+ @R@DP@@Z@Query1C@i@m?33'''''''% @O@)@ @q9:sub_daysC@ i@mD88,,,,,,,* @L@\@\@q8_sub_timeC@ i@mD88,,,,,,,* @I@p@Ycq@q70-8bC@i([__itinerary_no] = itinerary_no)LVAL v< r tlb-? rr0r rrr @rr r"rrrrrrrrrrr r"r        passenger.itinerary_noticket)passenger.flight_nopassenger.flight_datepassenger.seat4r0rrr (rEJ`@@rLr rߌ rߌ  rߌ "rߌ passenger,rr$r r(r ,@~sq_cpassenger~sq_cticketLr rr rr rr rrrrrrrߌ rߌ  rߌ "rߌ ticket rr rr rr "rrrrrrrr0r__itinerary_nor rr r (r,r<rLr\rlr0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0r r0rrrr rr r r r r r  r r |r | rr rጅLr r$r $ r r T r r r r r$ rT r  r8X r` rh rp r r$ rT r r rticket r r r rReference2 Reference1 PrimaryKey itinerary_no rrv rrrrLVAL @ @ @ @ @ @ @ @ @ @ @J>-J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH8RH3SH9SH;SHSrsrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr 0rrrr`rticketr rr r r r rHrr rr rrr Reference2,rr r[__itinerary_no]0rr rTrLr `rlrHrPr<rReference2rrr rxr rr rLVAL <$ t$b-?  (     @                        passenger.pass_namepassengerpassenger.itinerary_nopassenger.farepassenger.confirm_no, (    , J`@D P  ߌ  ߌ  ߌ  ߌ passenger(   \  , @~sq_fpassengerP                  ߌ  ߌ  ߌ  ߌ passenger                     , , < L \ l                                                              4     \    \    \    \   | $   0  tጅP     d    p   ,  |         ,  8              ,  \  passenger`  l   x  Reference PrimaryKey itinerary_no   v  p |   s    =)~ zrcn_P¿L=. taH)}d999999& ~ ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ~  ~ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o ~  | { {ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o { z zۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o z i iۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o i h hۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o b bۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o b  ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  a aۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z  Zۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Z  Y ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Y  Yۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o Y  X ۇ O8V#jKhɂ(bԺV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o LVAL z< <" t<b?" @" T" "  <`(" L" d" |" " " " @" X" p" " " 4" 4" 4" 4" 4" 4" (" L" d" |" " "             reservation.confirm_no reservationreservation.res_datereservation.res_namereservation.res_phonereservation.res_flight_noreservation.res_flight_date" " " " " L8@" " (" N L" N d" N |" N " N " NreservationL" " @" 8 " " \ @Q70-1"  (" "  L" "  d" "  |" "  " "  " " (" L" d" |" " " (" N L" N d" N |" N " N " Nreservation (" <"  L" @"  d" D"  |" H"  " L"  " P" (" L" d" |" " " " "  "  " ," D" \" t" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " T" " " L"  " " 8 "  " 8 "   " 8 "   " 8 "  " 8 "  " 8 "  |" H" " T" hQ"  "  H " @ "  x " L "  " X "  " d "   " p "  " H "  x "   "  "  " @" " $" ," 4" <"  " H " x "  "  " LVAL NP$@B  " 8 " reservationt" " PrimaryKey confirm_no" " v " t" " " s" " " " " " " " " " " " " " " " " " " " " " " " " " " " " "  T" " " t" reservation " "  " "  " | " $" " " " 0" " "  res_name4"  "*And*"\" "  " "  " " X" " " " "  " h"  " 4" 8 " LVAL |< t b@?D      -J>.J>/J>0J>1J>2J>3J >4J >5JHJ>)KHKHKHKHKHLHLHLH LH LH LH LH LHMHMHMHMHMHNHNHNHNHNHNHNHNHNHNHNHOHOH OH!OH"OH#OH$OH%OH&OH'OHPH(PH*PH+PH,PH)QH-QH/QH0QH1QH.RH2RH4RH5RH6RH7RH8RH3SH9SH;SHSH:X@XBXCXAYDYHBYH@YHAYHCYH?ZZZa aaaa!a!a!                                 passenger PrimaryKey               \  jLVALv     0@ P( X |(x x x x x x x x x x x x x x x x x x x x x x x x x x x x x x }(!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!LVAL  &FMicrosoft ClipArt GalleryMS_ClipArt_GalleryMS_ClipArt_Gallery  k       -- --$p $24ASQtaq!,7BMXdp{(5ANYepz   zhXSNG?7-# vfUDh3K"-e@ Ac[23~mKp----$ %+js`%---- $g6._g----$  Ux !D'M---- $D---- $ ~ ---- $=t+=-- MS_ClipArt_GalleryMicrosoft ClipArt Gallery` FormFooter2LVAL <y @r t@b? rrr T r , < rrrrrrrrrr    t.flight_noticket t.flight_date SumOffarerrrrr@@rr rr r r rf rrrrOt6@t`r8rXrr ,@Q70-4rr r r rr rrrrrflightr r ticket rr rr rr rr(0rr,r8rDrPr\rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rr rrrr rrv rrrv rrr0,rr@xrr0rr r rzr r0rxrrr8rrrr r rT r rflightrT rrT rr8rhrticket Reference1r\ rr\ r rtr rrr\ rr rrr Reference1rr  rrrrrReference1+LVAL7]SI?5P$@B @@r rr rr rr r 0rr `rr rr rr|d r r r r r r r r r r r r r r r r r r r r r r r r r r r r r r rr}d rrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr`r0rrLVAL < < t<0bL? D4 L  << ,Ot6@flight, ,@ticket, flight.flight_noflightsj`@ flight( Ot6@-qryC7S2-05 Flights with no Passengers on 8/21  flight 0 d<  4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4 4L  (  |   Ў  ,x   ( flight  PrimaryKey flight_no v v@ 80v@ ddsddddddddddddddddddddddddddddLVAL @ @ @ @ @ @>87>88>8-?;?;?;?;?;?;?;? ;?;@; A;A;A;A;A;A;A;A ;A ;A ;A;B; B;"B;#B;$B;!C;%C;'C;(C;)C;&D;*D;,D;-D;.D;+E;/E;1E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2E;2#Ih$Ih%Jh&JlJlKlKlKlLlLlLlMlMl  4flightL L  0  $ F`< |0 |  L d  ( ((ticketTT 8$h h t.flight_date4@  T flight PrimaryKey\ \` lp| PrimaryKey8 PrimaryKey    flight_no, 8LVAL <n bL tb?DbLbLbL bL +X'uY@'gflight g g f)@4 'fticket fflight fpassenger fpassengerticket,@' fflightticket#@$ fflight.orig_time( gf flight.orig# gfticket.flight_date* gfticket.flight_no( gf ticket.seat# gfpassenger.pass_name+ gfpassenger.itinerary_no. gf f d Gdpass_name LIKE '*swenson*'2 'dpassenger e)@ 'eticket epassenger epassengerticket,@' *orig = 'PHX' and dest = 'LAX'5 'b GbE@< 'bflight b b a Max(flight.fare) > 100. 'a  flight.orig# gaflight aMaxOffareMax(flight.fare)1 oa flight.orig# g`  flight.orig# g`flight `MaxOffareMax(flight.fare)1 o` flight.orig# g_5@4 '_flightf1 _airporta2 _airporta1 _ f1.dest_time$ g^ dairport.Elevation* /^"@4 '] ticket.flight_date* ga a ` Zpassenger Z  GZ Z LVAL <2t0bă? 222 2 022<222,2Ot6@flightD,2w2222p22222222w2222        flight.flight_noflight%flight.origflight.destFlying Time22x222@22 w2 2 2 2 flight2T22p 22Ot6@Q70-82 p2D2 2H2 2L2 2P2p2222w2 2 2 flight w22 22 22p222flight 22 2 2222222 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 22 222`2\2 22p 2  2p 2  2p 2 2p 2 2p 2 |2 222 2 2 2x 2 2 2  2 2 @ 2 2 2  2  228 2(202 2 2 2<2H2t2L2  2 [dest_time] x2 @ 2 [orig_time]282 P2 2|22p 2flight2 2PrimaryKey flight_no22v 222vLVAL @ 2222s222222222222222222222222222222 2222flight 22  22 222222 22 422 d22 2 2 22 22`2022 4p2$222822222 42 flight.dest24"LAX"<2H22L2X22\2 2 flight.orig24"PHX"2 222222 2 dest_time2 d2 orig_time2 p2<22 22 `2H2 2T2 2`2 2l2 2282222 2x2 2D2p 222@t2x2@222|2z2 2@2t2<222p2 2  202flight 22  22 2222 2P2 2t2 224D222222222 2 flight.dest2$"LAX"2$2P2(2 2 flight.origT2 "PHX"x22 22 ,22 22t2222222$@222222 D2 dest_time2 2 orig_time@22 22 2L2 p2X2 2d2|`2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2|2LVAL     gn gn g h Il n \@ ^n ^r r  |2|2|2|2|2|2|2|22}`222222222222222222222222222222222222 p2 2 222 2p222XLVALdOle10Native$AccessObjSiteData&8 C:\MSOFFICE\CLIPART\JET.WMF88  k       -- --$p $24ASQtaq!,7BMXdp{(5ANYepz   zhXSNG?7-# qaP=*vfUDh3K"-eͬpdDESTFormHeader1h Ticketd Text24h ERDetail0mConfirm_No_Confirm No:d Text15mres_dated Text17m res_named Text19m res_phoned Text21p s_passengd Text30rEmbedded8FormFooter2CONFIRM_NOres_flight_nores_flight_dateLVAL #2 " 8@  /H X` h -p  "   J   -   )Use database order for string comparisons08 B@BT  u A@" xlpp&`ZZ s_passeng'( ( * B@,.u& A@".lαAttribute VB_Name = "Form_m_rese rv" Bas0{F570F9FF-DFDE-11D0-8B64-444553540} |Creatabl!True ]Pr@edeclaId"ExposBeFals @TemplateDeriv%Cus`tomiz$Option Codmp@ DTv ( 'Uzdorder for Bsng cisons P=A Sub ER_Click() On ErrGoToF_ DoCmd.Clq Exit:' -rr MsPgBox4$R8esu & XEnd-T,et.I"B/im DocAs S GCDLinkCritfa D@s_paspsengBEOpen, A DL 'MNI ,O__SRP_2rU (a@4a)@8Aippp@ <rrr1@@ttt@ Dvvv@HA xxx@L!Izzz@P!i~~~LVAL <, 6h mb%x? 666H 6 % < 666 6666666    ticket.flight_noticketticket.flight_dateExpr100266666o`@ 6(6 6[x 6[x 6[x ticket6666 ,@qryC6F30 Group by, Having(6 66 66 666666[x 6[x ticket 6p6 6x666 6X 66$6@6P6`6p666 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 66 6666 66v  666X 6Xs 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 6X 66 6066 L60%6H 6 66 66p 66z6 6 666P6 066666ticket6H 66H 66H 6 6P6666@@6p 66p 66p 6LVAL  29cg hi-jk {ͭ`@ Main Menuh5`@ Detail0h1U5"`abcg ReservationCustomer Reservationsform macros.Open Reservarialh1U5"`aHbcgiButton1Schedules (not available)arialh1U5"`abcgiButton2 Print Tickets print ticketsarialh1U5"`abcgiButton3Utility (not available)arialh1U5"`abcgiExitSys Exit System[Event Procedure]arialr47Ua` bc dg Embedded8ࡱ> Root EntryF@ѧds@Ole CompObjlOlePres000LVAL <O@"bt@"bx?<bH"bX b b  $bb<b bbb,b@ passengerb,b ,@ticket4,b"b:bNb b8bLb,bDbDb"b:bNb      p.pass_namepassengert.flight_noticket t.flight_dateDb<b$b b\bc `@tbxb @bDb "b :b Nbpbbb b\b@tbbbb\b ,@.qryC7S2-10 Is David P on same flight as Olga SxbDb bb 8bb Lbb b8bLb"b passenger "bb b:b Nb ticket :bP b NbT b 8bLb bbb \bbbbbbX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX b bX bbbTb  b b bb bb |b \b0bhb xb b|b b`bbXDb L bb | bb  bL b| b4 <bDbLb bL b| b bbpassengerbb bReference PrimaryKey itinerary_noticketbb b,bReferencLVAL e2 Reference1 PrimaryKey itinerary_noDbbv bbbv Pb<bbbv@ bbbv@ bb$!bbbsbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb X b0bb <bbb@bbpassenger bb bbbb bb bb$b(bDbPb|bTb b p.pass_nameb'David Peterson'b@b Xb4b bbbbticket Reference2bbbbbbbb Pbb bb bb b(bbbb bbb Reference2bb @bbbb4bReference2 bb`b$bb db bb dbbb bbbbbbbb 0bb `bb 0bb `bbbbL b"bpassenger bb bb bb$@bpbbbbb b p1.pass_nameb'Olga Swenson'bb b|b bbbbticket Reference2bbbbELVALQ        bb bb b( b b4 bbb b  b b b Reference2@b b L b !b b b@ bReference2,4!b@!b!bD!bP!b!bT!b bt1.flight_date !b b, t.flight_date!b!b!b!b b t1.flight_no !b b t.flight_no"b0!b X!b!b !b$"b !b0"b!b<"bLVAL <ptpbx?Lx   ť <@           p.pass_namepassengert.flight_noticket t.flight_datet.seat @HL       r|pp\ @pl| @td,\ ,@Q70-11 L ` d h l reservation passenger (     ticket          ,<L\l                                                           `       | lxX | $ȑ   4  d    4  d 8@HPX  4 d  passenger Reference PrimLVAL(qg]SI?5P$aryKey itinerary_noticket$0<Reference2 Reference1 PrimaryKey itinerary_noTv v $v D0s   D Lreservation    h$8t  r.res_name "Andy*"   passenger Reference  ( 4  Reference L @Referenceticket Reference2 D t0 <@L Reference2\ |X`Reference2t  $T `$lLVAL < @"Ht@"0bx?H"  `  <,HXh,HXh! <P`x                      f.flight_noflight flight_nof.origorigf.destdestf.orig_timeorig_timef.dest_timedest_time f1.flight_no flight_no f1.origorig f1.destdest f1.orig_time orig_time f1.dest_time dest_time  h`@  p |       f$  Ot6@f1 P  Ot6@ flight_noorigdest orig_time dest_time1qryC7S2-12 Flight from FLG to PHX to LA w/ 40 min p t x |  , H X h /,HXh       flight_noorigdest orig_time dest_timeflight <  @  D  H  L           flight_noorigdest orig_time dest_timeflight /  K  [  k   ,HXh p4 ,T|                             LVAL                              P               | X!`<  , \ | !p    L |  ,\  L|P' (08@H,\L|flightPrimaryKey flight_noflightPrimaryKey flight_nov  v ppspppppppppppppppppppppppppppp!  !! hd!flight `  ` `` ( D t4p$L( D f1.destP$'LAX'LVAL          t  f1.orig 'PHX' ,  `hhshhhhhhhhhhhhhhhhhhhhhhhhhhhh4 T  flight h  h hh   (4X$ f.dest$'PHX'(4\8 f.orig` 'FLG'  < h(Xhh T $     !  t f1.orig_time !!D!! T  f.dest_time H!qq?h!    !t! pp !! !$" !0"!<"LVAL <<r!t<b?H r!r!r! r!  < r!r!r!r!r!r!r!r!r!r!      flight.origflightflight.destMaxOffarer!r!r!r!r!ǖ`@r!r! r!) r!) r!) flightdr!<r!\r!r!Ot6@ qryC7S2-13r! r!0r! r!4r! r!8r!r!r!r!r!) r!) flight r!|r! r!r! r!r! r!r!(,r!r!,r!8r!Dr!Pr!\r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r! r!r!r!r!P r!r!v 8 r!0 r!0r! r!@ r! r!,r!r! r!r!zr!  r!,r! r! 8 r! h r! r!$ r!0 r!r!r!flight r! r!  r! r! r! r!8 r! h r! r! r! r! @ @ r! r! r! r! r! r!r! r! ,r! r! \r!r! r!r! r!r!| r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!} r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r!r! ,r! \r!LVAL]SI?5P$BB yr!LVALN:+' ÇÇÇÇÇxiteVRC4"e-pFa ` `<r#8tb?\r# r#r# r# % <r#r#|r#r#r#r#  ticket.flight_noticketCountOfflight_dater#r#tr#tr#r#B{ ݖ`@r#r# r#) r#) ticketr#r#r#r# ,@ qryC7S2-14r# |r#r# r#r#|r#r#r#)r!!ticket r#r#|r# r#$r#(r#r#,r#4r#<r#Dr#Lr#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r# r#r#r#tr#dr#r#v @ r#8 r#0%r#r#@ r# r# r#r# r# r#zr#  r# r# r#@ r#p r#, r#8 r#H r# r#ticketr#r#r#r#@ r# p r# r#@r# r#r# r#r# r# r# r#  r#x r# H r# r#| r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r# r#r#} r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#$r#r# r#H r#LVAL < Xr% tXb? r%,r% r% l r% , < r%r%r%r%r%r%r%r%r%r%    ticket.flight_noticketticket.flight_date SumOffarer%r%r%r%r%r՞ޖ`@r%r% r%r% r%) r%) r%) flight8r%0r%0r%r%Ot6@ticketxr%Pr%pr%r% ,@ qryC7S2-15r%r% r%$r% r%(r% r%,r%r%r%r%flightr%) r%) ticket r%r% r%r% r%r% r%r%(Hr%r%,r%8r%Dr%Pr%\r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r% r%r%r% r%r%v  r%r%r%v r%r%r%0,r%r%@r%r%Hr%r%8r%8r%zr% r%Hr%r%r%r%Pr%r%r%r%8r% r%l r%$r%flightr%l r%r%l r% r%Pr%r%ticket Reference1r%t r%r%t r% r%r% r% r%r%t r%r% r%r%r% Reference1 r%r% $r%r%r%LVAL]SI?5P$@B yr%r%Reference1@@r%8r%r%8r%r%8r%r%8r% Hr%r% xr%r% r%r% r% r%|| r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%8r%r%}| r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%r%Hr%xr%r%VCN    #    Codelocationphone Elevation  PrimaryKey      F        V   Field1Field2Field3Field4Field5Field6Field7Field8Field9Field10Field11Field12Field13Field14Field15Field16Field17Field18Field19Field20_ID  PrimaryKeybK08p(L5%%EbK0p( L%%bKp( PL%%ebK[p( L%%UEbK0p( LE%%ebKpyp( LL%uEbK@Ep(Lu55e%ebKpep(LeUEebKp(HLE%eeubKPIp(LueebK@Gp(LEEEEUuebKp(DLeebKp(LuUebKp(LEEbK@p(@L5bK@p(L5bK@p(L_{qbKp(@†g`@qryC7S2-02 Flight Information for Pete Peterson{C@B@Gthh\PPPPPPN `8F@@q7_add_minC@B@DC77+++++++) @5ö@ $ö@q5:flight-phxC@+B@DF::......., @2 @ @q37-7C@ B@D>22&&&&&&&$ @/z@e'`@qryC7S1-04> C@n@gOCC7++++++) `-`o@ `@qryC7S1-02$ O@*B@jOCC7++++++) `*6>@ G@q37-11 RDRRRRRRR R R R RD Rt R R Rflight0R<RPrimaryKey flight_noPRRv 8R0RRRsRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR RRRRflight RR  RR RRRR 8R$R hRR RR4RR,R8RR<R HRpRLR R orig_timetR4?,RRRRRRR hRdestR$'LAX'RR,R R 8Rorig0R 'PHX'TR(R PRR R`R RlR RRPRRRR RxR RDR RgFQlQlQlTY,T_T_U_U_U_V_V_V_Xd*Xd+Xd,XxYxYxYxYxZxZxZxZx[h'[h([h)\C'\C(\C)]C*]h*]h+^h,^h-^h._h/_h0_h1`h2`h3`h4ah5ax ax bxbxbxc_'c_(c_)d_*da%da&ea'ea(ea)fl&fl'fl(gl)gl*gl+hl,hxhxixixixjd-jd.jd/kC+kC,kC-mC2mC3mC4nC5n_+n_,qd6qf'qf(rf)rf*rf+sf,sf-sf.sf/tf0tl-tl.tl/ul0ul1ul2ul3wC:wl4wl5wl6zxzxzx{x{x{x|x|8|8}d@}dA}dB}dC~x$~x%~x&~x'C;C<C=C>888888888 8!8"8#aaaaaaaa a!a"a#a$dd___a a a aaaa!a!a!a!a%dD%8%8'l'l'l,d ,d ,d Ml Ml!Ml"Ql#Ql$Ql%x x x 8888 8 8 8 8 8888 8 8 8888YYYYYY Y Y Y YYYmeout  <KKD RecordLocks ODBCTimeout  < @`atgmhhbpm`|osvsi|vgrt`@`@airport@i444(((((((& @a!tۖ`@uۖ`@qryC7S2-19[@n@ jC77+++++++) @`ˮږ`@?ږ`@qryC7S2-18[@n@ jC77+++++++) @_Jٖ`@Jٖ`@qryC7S2-17[@i@ jC77+++++++) @^>ؖ`@"`@qryC7S2-16[@n@ GC77+++++++) @]Kז`@r՞ޖ`@qryC7S2-15 [@i@ DOCC7++++++) `\GB֖`@B{ ݖ`@qryC7S2-148[@(B@ jOCC7++++++) `<` @ H`@qryC7S2-11 Reservations made by Andy AC@!B@Gk__SGGGGGGE `A@@*k8{`@qryC7S2-04 Total Fares by Flight No, Flight Date C@B@@Guii]QQQQQQO `9-@c`@qryC7S2-01 Reservation for Andy Anderson yC@b@DmaaUIIIIIIG `ZJ`@J`@~sq_fpassengerw*@nGGG;//////- `Y7I`@EJ`@~sq_cpassenger~sq_cticket u*@nRRRF::::::8 `XeI`@gI`@~sq_fflight r*@bDDD8,,,,,,* `W tĎS\@RP`@AccessLayout*@b@qE99-------+ @R@DP@@Z@Query1C@i@m?33'''''''% @O@)@ @q9:sub_daysC@ i@mD88,,,,,,,* @L@\@\@q8_sub_timeC@ i@mD88,,,,,,,* @LVAL < LS tLb?HSPSS S SH:X@XBXCXAYDYHBYH@YHAYHCYH?ZZZZ[;;[;@[;=[;>[;?[ ;A[ ;B[;<\DSSSSSSS S S S SD St S S Sflight0S<SPrimaryKey flight_noPSSv 8S0SSSsSSSSSSSSSSSSSSSSSSSSSSSSSSSSSS SSSSflight SS  SS SSSS 8S$S hSS SS4SS,S8SS<S HSpSLS S orig_timetS4?,SSSSSSS hSdestS$'LAX'SS,S S 8Sorig0S 'PHX'TS(S PSS S`S SlS SSPSSSS SxS SDS S<~s{tGGGDzv@+MCma@+MCma@note%%%%%%%%%%# F@`@qryC6S2-22 Highest fare from PHX to LAX;O@$n@ Dl``THHHHHHF `0@@l0`@qryC6S1-06 Flights from LAX to PHX between 8am and 12pmC@B@ gpddXXXXXXXV @LVAL   &FMicrosoft ClipArt GalleryMS_ClipArt_GalleryMS_ClipArt_Gallery  k       -- --$p $24ASQtaq!,7BMXdp{(5ANYepz   zhXSNG?7-# qaP=*vfUDh3K"-e@ Ac[23~mKp----$ %+js`%---- $g6._g----$  Ux !D'M---- $D---- $ ~ ---- $=t+=-- C:\MSOFFICE\CLIPART\JET.WMF<_  PH,PH)QH-QumnKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWid<KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD8 RecordLocks ODBCTimeout MaxRecords Replicable  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout  <KKDValidationRuleValidationText ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredAllowZeroLengthe confirm_no      0   General NumberIres_date      m/d/yyCres_name       D res_phone       h res_flight_no      0   General NumberPres_flight_date      m/d/yyKKD RecordLocks ODBCTimeout  <KKD RecordLocks ODBCTimeout FLGFlagstaff AZ5207747777  GCNGrand Canyon National Park AZ56021824461' ABQAlbuquerque NM5055551111" ?MPSMinneapolis/St Paul MN6124445000*  SFOSan Francisco CA2153457000$ ~LAXLos Angeles CA2136682000" lPHXPhoenix AZ6028886000 LVAL < "D% tbz?|"D"D"D "D , <@"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D         flight.flight_noflight)flight.origflight.destairport.Elevation airport"D"D"D"D"D"`@D"DL"D "D"D "D) "D) "D) "D) airport"D"D"Dp "D"D eb`@flight"Dd"D"DD "D"DOt6@ qryC7S2-16L"D"D "D"D "D"D "D"D "D"D"D"D"D"D"D) airport "D`"D "D"D) "D) "D) flight "D"D "D"D "D"D "D"D"D "D"D"D "D,"D<"DL"D\"Dl"D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D "D"D"D"D"D"DD "D  "DD "D  "DD "D "Dp "D |"D <"D"DD"D0-"D "D "DL "D "DX "D|"D "D`"D "D,L"D  "Dd "D "D  "D  "D "D8"D"D"D"D "D "D "D "Dp "DD "Dairport 0"DPrimaryKeyflightd"Dp"DPrimaryKey flight_no"D"DvLVALNP$t`@ eb`@airport;@444(((((((& @a!tۖ`@)t`@qryC7S2-19[@n@jOCC7++++++) ``ˮږ`@`@qryC7S2-18![@@ jOCC7++++++) `_Jٖ`@xI`@qryC7S2-17[@"i@ cC77+++++++) @^>ؖ`@"`@qryC7S2-16[@n@ GC77+++++++) @]Kז`@r՞ޖ`@qryC7S2-15 [@i@ DOCC7++++++) "D"D"Dv D"D0"D"D0,"D"Ds"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D"D "D0"D"D l"D"D"D"Dflight "D"D "D"D "Dx"D"D"DairportPrimaryKey "D "D "D "D"D "D D"D$"D t"D"D "D"D"D "Dl"D x"D|"D"D PrimaryKey "D"D "D"D"D"D"DPrimaryKeyt"D"D"D"D"D"D"D"D"D 0"D"D `"D"D "D"D `"D"D"D"DLVAL <(Dt(bz?D0D D |D   ؖ`@"`@qryC7S2-16[@n@ GC77+++++++) @]Kז`@r՞ޖ`@qryC7S2-15 [@i@ DOCC7++++++) `\GB֖`@B{ ݖ`@qryC7S2-148[@(B@ jOCC7++++++) `<` @ H`@qryC7S2-11 Reservations made by Andy AC@!B@Gk__SGGGGGGE `A@@*k8{`@qryC7S2-04 Total Fares by Flight No, Flight Date C@B@@Guii]QQQQQQO `9-@c`@qryC7S2-01 Reservation for AndD DDD PrimaryKey DD ,DDDD DPrimaryKeytDDDDDDDDD dDD DD DD dD D DDD$DB  @@ @tu}f|`osmfafw{ffptu}f|`osmfbrufm,vxavfmfbwtu}f|`osmfbrxpwtu}f|`osmfhurxsa}vxavfmfbwi`zjphtu}f|`osmfojpo`|`zhufvfuz`wjrp7ufzfpxf7vf`wvw`ggwjblfw7`bbfvvm`}rxwkov}vda`jusruwgmjhiw`jusruwgmjhiwWgmjhiwufvfuz`wjrpufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"ufvfuz`wjrpwjblfwgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"pbf7 ufgfufpbfW7!ufgfufpbfX7"fgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"}vdaufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"daufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"pbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"}vdaufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"pbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"aufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"fpbf7 ufgfufpbfW7!ufgfufpbfX7"ufgfufpbf7 ufgfufpbfW7!ufgfufpbfX7"r*@bDDD8,,,,,,* `W tĎS\@RP`@AccessLayout*@b@qE99-------+ @R@DP@@Z@Query1C@i@m?33'''''''% @O@)@ @q9:sub_daysC@ i@mD88,,,,,,,* @L@\@\@ :7@ ,@Tablesticket1+%LVALNP$< @bIGt@bx?bI bI(bI t bI  <bIbI|bIbIbIbI   flight.origflight MaxOffarebIbIdbIdbIbItߗ`@bIbI bI) bI) flight bIbIbIbIOt6@1qryC7S2-18 Max fare for flights from each airportbI |bIbI bIbI|bIbIbI)flight bI$bI|bI bIbI(<bIbI,bI4bI<bIDbILbI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bI bI(bIbItbIbIbIv  bI bI0bIt bI@ bI bIx bIbI8 bI,bIzbI H bIx bI bI  bI bI bI bI bIh bIflight bIt bI bIt bI bI bI0 bI @ bI8 bI bI8 bIbI8 bI x bI< bI bIbI bIbI|| bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bI,bIbI}| bIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbIbI x bI bI~A @ @ @ @ @QH-QH/QH0QH1QH.X@XBXCXAYDYHBYH@YHAYHCYH?ZZZZ[;;[;@[;=[;>[;?[ ;A[ ;B[;<\89\;L\8>\8?\ ;M\8:];F];R]>I];N];O];O];O];O];O];O];O];O];O];O];O];O];O];O];O];O];O];Q] >J] ];G^>8^>O^>P^>K^>L^>M^>N^^ ^>9_>@____>Q_>R_>S_>T_>U_>V___>A`>H```` `a a!aa a "a #a b$b+b)b*b%c;cIcGcHc`@qryC6F13 Flights between 10:00am and 8:00pmC@b@gdXXLLLLLLLJ @#@`@qryC6F12 Flights with orig time > 10:00C@b@e`TTHHHHHHHF @Z!C@׬`@qryC6F17 New fare is 1/2 (old + 25 surcharge), >50C@ b@ek__SSSSSSSQ @ Z:gy@uҬ`@qryC6F17 15 and 40 percent discountO@)b@c\PPDDDDDDDB @ H@Q`@qryC6F15 All passengers with flights on 7/15/92 C@b@@cthh\PPPPPPN `,s7@@passenger(@b666*******( @`ޒ@ p`@qryC6F34 Null~ C@FB@cRFF:......, `[|@5`@qryC6F38 Not existsC@b@cL@@44444442 @!llS\@llS\@MSysModules2----------+ LVALNBIEBAAA4@6:{϶@ʉ϶@q6:flt-phx-laxC@B<Z;tb8 ?4ZZpZ Z  <TZTZ Expr1000$Z Z(ZZ`Zx`@HZPZ TZ*flightXZPZPZ`ZOt6@q37-11PZ TZLZ TZflight Z<Z(Z`Z,Z0Z4Z8Z<ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZ ZpZZPZ<ZZv  Z ZW0Z Z@ Z Z<ZZ ZZzZ Z<Z Zl Z Z ZlZ,Zflight ZZ  ZZ ZZ Z < Z Z4l Z Z Z Z( Z Z Z Z Z < Zdest Z$'LAX', Z8 Z\ Z< Z  Zorig` Z 'PHX' Z Z Z Z @ Z Z ZZ ZZ ZZ Z <Z Z lZZ| ZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ} 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<ZZlZxLVALN6p 6 66P6666 6x i46666T6 `66d6 6 66P6h6@6| 66666666666666666666666666666666} 6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L6L66P6 666X 66X 66X 6066`666606`66LVAL < @ m@(bHx?@H  wpw                flight.flight_noflight flight.orig flight.destflight.orig_timeflight.dest_time flight.meal flight.fare0( gI`@HP w`&x `&x `&x `&x `&x `&x `&x flight Ot6@ ~sq_fflightP pH P X ` h p xpw`&x `&x `&x `&x `&x `&x `&x flight w    ( 0 8 @p  X@`H H H H H H H H H H H H H H H H H H H H H H H H H H H H H HPP              | @H`(xP    H x ( 8 LVAL < x[ txb ? [|[ [ [ <@[[[[[[[[[[[[[[[[        flight.flight_noflight%flight.origflight.destDiscount Fare[[[[[b@([0[ [* [* [*[* flight[[[ [[Ot6@q37-130[ [[ [[ [[[[[[[[[* [* [* flight [[ [[ [ [[[[flightfare [[ [ [,[<[L[\[l[ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [ [[[[ [[ [  [ [  [ [ [ [ |[  [@[ [,-0[ [  [ [ D [ [ t [ [ [  [ D [ [8 H [P [X [ [ [D [d [p [ [t [ t [fare [b? [` [x [ [ [flight [ [PrimaryKey flight_no [[v [[[[s[[[[[[[[LVAL     @B )8 [[[[[[[[[[[[[[[[[[[[[0[ [@[$[[flight [ [  [ [ [ [ [ [ 4[[4d[[[[([[[[[ 4[ flight.dest[$'LAX',[8[d[<[ [ flight.origh[ 'PHX'[[ [[ @[[ [ [[d[[[ @[[ @[p[ [VCN  ma     equip_typemfgseats fuel_type`  PrimaryKey[la@0Zela@equipment@666*******( @݄`@݄`@~sq_cm_reserv~sq_cs_passeng, *@[TTTH<<<<<<: `neV˭`@ϥ`@Mainmenu))))))))))' mT˭`@5`@m_reserv))))))))))' jPc`@U`@qryC6F40 Using Allg[@@\WKK?3333331 `Z1`Qa@ذ`@qryC6S1-07 Flights from PHX to LAX between 3pm and 12am@ C@b@ g|ppdXXXXXXV `.@@eѯ`@qryC6S1-03 Flights from PHX to LAXC@B@g[OOCCCCCCCA @Z,`@`@qryC6S1-12 PHX to LAX fares with 20 percent disc C@5B@guii]QQQQQQO `+\@BѺ`@qryC6S2-23 Average fare from PHX to LAXC@B@g`TTHHHHHHHF @'@>`@qryC6F13 Flights between 10:00am and 8:00pmC@b@gdXXLLLLLLLJ @#@`@qryC6F12 Flights with orig time > 10:00C@b@e`TTHHHHHHHF @Z!C@׬`@qryC6F17 New fare is 1/2 (old + 25 surcharge), >50C@ b@ek__SSSSSSSQ @ Z:gy@uҬ`@qryC6F17 15 and 40 percent discountO@)b@c\PPDDDDDDDB @ H@Q`@qryC6F15 All passengers with flights on 7/15/92 C@b@@cthh\PPPPPPN `,s7@@passenger(@b666*******( @`ޒ@ p`@qryC6F34 Null~ C@FB@cRFF:......, `[|@5`@qryC6F38 Not existsC@b@cL@@44444442 @!llS\@llS\@MSysModules2----------+ <LVALH  flight_day@777+++++++) @la@Ula@flight_crewM@888,,,,,,,* @~I`@I`@~sq_fm_passeng*@.bGGG;//////- `}I`@I`@~sq_cm_passeng~sq_cs_ticket *@XBTTTH<<<<<<: `|T٭`@k]V٭`@print ticketsQ@D:........., {S٭`@T٭`@mainmenu{@ D5)))))))))' zS٭`@S٭`@form macros@8,,,,,,,,,* wt -խ`@t -խ`@~sq_fm_rese fPf f  f  f0 f` f  f fDf f(f0f8f@fHf f f f0 f` f f f fflightffPrimaryKey flight_noffv fff8f8sf8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8f8ff `fff(fflightpf(f pf(f @f(f@f(ff`ffXffhf(fxf,ffff fff fflight.orig_time f4qq?, ffff(fXf,f f flight.dest\f'LAX'ffff f flight.origf'PHX'ffff0ffff f(ff(f@f8fffff fLVAL < |a@ t|b-?Haaa a SH:X@XBXCXAYDYHBYH@YHAYHCYH?ZZZZ[;;[;@[;=[;>[;?[ ;A[ ;B[;<\89\;L\8>\8?\ ;M\8:] bDbbbbbbb b b b bD bt b b bflight0b<bPrimaryKey flight_noPbbv 8b0bbbsbbbbbbbbbbbbbbbbbbbbbbbbbbbbbdb btbXbbflight bb  bb bb 8b$b hbb4bbbbTbb b0bb 8borig4b'PHX'Xb dbhbtbbxb hbmealb'd'bb bb |bb bbbbbb tbb tbb bLVAL <  t0b*?\   <@           p.pass_namepassenger t.flight_datetickett.flight_not.seatL`@8<      p @tx  ,@,qryEx All passengers with flights on 7/15/92<     passenger t     ticket P T X  ,  ,<L\l\ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \ \          | (< | L ` P       P    8 P     passenger Reference PrimaryKey itinerary_noticket`l LVAL @ @ @ @ @ @.012/35674>111111 1 1 11 111111 1111xReference2 Reference1 PrimaryKey itinerary_nov v p,,s,,,,,,,,,,,,,,,,,,,,,,,,,,,, \ ticket `0l  t.flight_date4@ x  passenger PrimaryKey$$  $t  PrimaryKey PrimaryKey0,,  L| LLVAL < rot b ?ro roro pro `@qryC6F13 Flights between 10:00am and 8:00pmC@b@gdXXLLLLLLLJ @#@`@qryC6F12 Flights with orig time > 10:00C@b@e`TTHHHHHHHF @Z!C@׬`@qryC6F17 New fare is 1/2 (old + 25 surcharge), >50C@ b@ek__SSSSSSSQ @ Z:gy@uҬ`@qryC6F17 15 and 40 percent discountO@)b@c\PPDDDDDDDB @ H@Q`@qryC6F15 All passengers with flights on 7/15/92 C@b@@cthh\PPPPPPN `,s7@@passenger(@b666*******( @`ޒ@ p`@qryC6F34 Null~ C@FB@cRFF:......, `[|@5`@qryC6F38 Not existsC@b@cL@@44444442 @!llS\@llS\@MSysModules2----------+ LVAL_VBA_PROJECTl 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-00ͬmPdDESTFormHeader1d Text24h RR01Detail0mPASS_NAMEd Text15mITINERY_NOd Text17mPRICEd Text19m CONFIRM_NOd Text21p s_ticket FormFooter2itinerary_nofareͬmPdDESTFormHeader1d Text24h RR01Detail0mPASS_NAMEd Text15mITINERY_NOd Text17mPRICEd Text19m CONFIRM_NOd Text21p s_ticket FormFooter2itinerary_nofareͬ5 pdDESTReportHeader3dText15mField16fLine18PageHeader0GroupHeader0mPASS_NAMEdText21dText22d Text23d Text24d Text25d Text26d Text27dText28mITINERY_NOmCONFIRM_NOdText29dText30fLine31dText32dText33dText34dText36dText37dText38fLine40dText42mField43dText44dText46dText47d Text48d!Text49"Detail1m#FLIGHT_NOm$FLIGHT_DATEmͬmPdDESTFormHeader1d Text24h RR01Detail0mPASS_NAMEd Text15mITINERY_NOd Text17mPRICEd Text19m CONFIRM_NOd Text21p s_ticket FormFooter2itinerary_nofareLVAL < = sLb4y? h0@ @)9 0)9        m_reserv.pass_name passengerm_reserv.itinerary_no m_reserv.farem_reserv.confirm_no`X8 H݄`@`p y y )y 9y m_reservp ` H@~sq_cm_reserv~sq_cs_passengp    0 0y y )y 9y passenger   )  9( 0@h0 __confirm_no@ x  H@P`p                             ( p  @  @  @  | p  yp x  (  X     ( X 8H P X `   ( X   passenger   Reference PrimaryKey itinerary_no v LVAL < 8 m8b &x?8h0 <wpw                flight.flight_noflight flight.orig flight.destflight.orig_timeflight.dest_time flight.meal flight.farePH>`@HP wD\x D\x D\x D\x D\x D\x D\x flight Ot6@+qryC6F13 Flights between 10:00am and 8:00pmP ph p x    pwD\x D\x D\x D\x D\x D\x D\x flight w0 8 @ H P X `p @x@`h h h h h h h h h h h h h h h h h h h h h h h h h h h h h hPH              | `hd^xP   8 (h 8 H( @ @ @ @ @ @ @d3d1d2dKeHNe.e/eHSeHTeHUeHVeHWe-e0eHOf4fHfIfJf?f@fAfBfCfDfEfFfGfKf5gLggggggMhh h!h"hhhhhhh#hi i(i)i$i%i&i'i*ij6j@j>j?j7s2Ls2Ns2Os2Mt2Pt2Yt2Rt2St2Tt2Ut2Vt2Wt2Xt2Qu2Zu2\u2]u2[w2dw2fw2gw2e}2t}2x}2v}2w}2y}2u~5W~5Y~5Z~5X2z2~2|2}22{5[5]5^5\LVAL <  tb<?(h  x `<,Ot6@flightt, #7KW0DP #7KW                flight.flight_noflight(flight.origflight.destflight.orig_timeflight.dest_timeflight.mealflight.fare$t\ cd`@ H-  H- H- #H- 7H- KH- WH- flight4,|\Ot6@qry Using Some     0 D P#0DPH-  H- H- #H- 7H- KH- WH- flight L  P  T  #X  7\  K`  Wd 0DP  \$@h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  0|  |  | | |  | | | /,  \    LVAL]SI?5 P$0   L,  \      LDt|, \    L |flightPrimaryKey flight_nov v@ s h 4flightxx  H 4F``x T  x (|flight      H4x4   x  8 orig_time8DHTxX Hdest|$'PHX' orig 'MSP'   \  LVAL <+TgtTb<?h  x `<,Ot6@flightt, #7KW0DP #7KW                flight.flight_noflight(flight.origflight.destflight.orig_timeflight.dest_timeflight.mealflight.fare$t\?5^j`@ H-  H- H- #H- 7H- KH- WH- flight4,|\Ot6@ qry Using All     0 D P#0DPH-  H- H- #H- 7H- KH- WH- flight L  P  T  #X  7\  K`  Wd 0DP  \$@h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  h  0|  |  | | |  | | | /,  \    yLVAL]SI?5 P$0  L,  \      LDt|, \    L |flightPrimaryKey flight_nov v@ s h 4flightxx  H ``x@ T  x (|flight      H4x4 Hdest4'LAX'8DHTxX orig|D'PHX'T   orig_time x$D( xH"Xdh  orig_time"  \   , l LVAL X     8 h    D (08@HP   8 h    flightPrimaryKey flight_nov @@s@@@@@@@@@@@@@@@@@@@@@@@@@@@@ h`flight0 0 00h`p0,  flight.dest'LAX',(,8h<  flight.origl'PHX' flight.orig_time4? 4?$@0@ 0 0@P( LVAL i_VBA_MODULE pmPdDESTpdDESTmPdDESTx|mPdDESTmPdDESTtt 4p8r<t@vDxHzL~PTX\`dh(SLS S6N0{F570F9FF-DFDE-11D0-8B64-444553540000}3 "*\Rffff*3339a88d9 (P(!$p`(J$`J@C`(x`*t?0p  $P $ $0p $ $  $Lx @h @X @H @8 @( pLp @` P @@ X0 @ @ @ 0ptMELVAL <9 fu mbH&x? f fx ffXf7 < fff fff fff fff      flight.origflightflight.orig_timeExpr1002 fffff5R?`@f fxf xxf xxf xxflightfff ffOt6@-qryC6F18 Flights with orig timee + 45 minutes f ff fffffff f xxf xxflight ff ffffflight orig_time fhf f f@fPf`fpfff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff ff fffff f f f f f"|f  fXf fx fX f f f X f fX f4P fX fX f f d f f f f f f .` dateadd f f f f'N' f f f  f-$ f0 f 4 f  f orig_time\ f` f8 f f` f fflight f fPrimaryKey flight_no ffv fffhfhsfhfhfhfhfhfhfhfhfYIǴǴǴǴǴDž[1NxY*}dEnnnnnnn[HHHHHHH/e6d3d1d2dKeHNe.e/eHSeHTeflightreservation,@)  fare > 50! 'flight Less40 fare * .60( oLess15 fare * .85( ofare gdest gorig gj Gjp@ 'jflight j j  orig = "PHX" AND dest = "LAX"6 ' flight  Avg AVG(fare)$ o Max MAX(fare)$ o Min MIN(fare)$ oi0@< 'iticket ipassenger ipassengerticket,@4' ipassenger.pass_name+ giticket.flight_date* giticket.flight_no( gh[@< 'hticket hpassenger hflight hflightticket#@4$ hpassengerticket,@4' hflight.flight_no( ghticket.flight_date* ghticket.flight_no( ghpassenger.pass_name+ ggflight g'New Time'[orig_time]+(1)1 og flight.dest# gg flight.orig# ggflight.flight_no( gi i h h kLVALwhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfhfHf fXf8ffflightfXffXffh ff(fLf Xff\f f orig_timef4UUUUUU?fHf`f8f fXffffhfXffXff fLVAL <: v tb|,?  7 h x\flight    $(Xt   flight.fare b2HJp d  ( x xp LVAL <e `b t`b? bdbb 4 b <@bbbbbbbbbbbbbbbb        passenger.pass_namepassengerpassenger.itinerary_nopassenger.farepassenger.confirm_noPbLbbb,b]`@DbPb bH- bH- bH- bH- passengerLbb@b b,b@0qryC7S1-09 All information re Swenson passengersPb bb bb bb bbbbbbbH- bH- bH- bH- passenger bb bb bb bbbbbb b<b b ,b,b<bLb\blbb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bb bbbbpb b b b b b b b b b |b H b(bT be`@4$<$et$ҋ8$ҋd  $ҋfere2$ҋnce1rticket$$$D $$ ,@qryExample Null<$ $$ $$ $$ $$$$$$$ҋ|  8$ҋ   $ҋ  \$ҋ ticket $$ $$ $$ $$$$$$ $$| $ $,$<$L$\$l$$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$ $$$$($ $$D $ $D $ $D $  $D $ |$  $$ $ԋ<$ $ $L $ $X $  $d $ $ $ $  $8 $ $ $ $ $ $ $ $ D $ticketT $` $l $x $Reference2 Reference1 PrimaryKey itinerary_no $$v x$p$$bLVALne?$s$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ $$$P$ticket $ $ $ $ x$p $$$$$$$$ x$seat($"8$$ $$ $ $4$$$$ $D$ $$D $LVAL  029cg&hsij"k<t -խ`@ reservationCustomer Reservations d7ee1h5i14bcgfj14bcgfm49cgfn25hfo27fjf` FormHeader1h1U5"` aHc ghTicketPassenger Info:form macros.Minimize Reservariald25U7`:aHb cText24"AW Reservation Information Screen:arialh1U5"`aHc ghiERExit Reservation:form macros.Close Reservarial` Detail0m7U`ab Confirm No: confirm_no Confirm_No_d25U`abcText15 Confirm No:m7U`abHeHkres_dateres_date Short Dated25U7`abcText17Date:m7U` abkres_nameres_named25U7`SabjcText19Name:m7U`abk res_phone res_phoned25U`,abcText21 Phone No:p3U`a*bT csd s_passengForm.s_passeng confirm_no confirm_nod25U7`aKbacText30Detail Information:r47Ua0bHc dg Embedded8ࡱ> Root EntryLVAL &FxFsOle CompObjlOlePres000(  &FMicrosoft ClipArt GalleryMS_ClipArt_GalleryMS_ClipArt_Gallery  k       -- --$p $24ASQtaq!,7BMXdp{(5ANYepz   zhXSNG?7-# qaP=*vfUDh3K"-e@ Ac[23~mKp----$ %+js`%---- $g6.LVAL _g----$  Ux !D'M---- $D---- $ ~ ---- $=t+=--Ole10Native$AccessObjSiteData&8 C:\MSOFFICE\CLIPART\JET.WMF88 &7 k       -- --$p $24ASQtaq!,7BMXdp{(5ANYepz   zhXSNG?7-# qaP=* @ @ @ @ @ @ @];P];Q] >J] ];G^>8^>O^>P^>K^>L^>M^>N^^ ^>9_>@____>Q_>R_>S_>T_>U_>V___>A`>H```` `a a!aa a "a #a b$b+b)b*b%c;cIcGcHcVText24rER ]Detail0, Confirm_No_PText15rres_date{uText17rres_name"-Text19r res_phone| Text21r s_passeng}xText30s Embedded8Z7 FormFooter2 CONFIRM_NOk res_flight_noٓres_flight_dateeClickT1 $dir0* pHd airwest7D20@ = p 3 J<  DAO>BDAO *\G{00025E04-:0C  0046}#3.5#0#C:\PROGRAM FILES\COMMON MICROSOFT SHARED\w\dao2535.tlb#Microsoft 2.5/+ Compatibility Library#Nut >tilty 7*\CNrogram F iles\7Of fice\UTILITY.MDFA..\P!2Form_m_reserv @*_VBA_MODULE2VB@f_M@gDU LE@ HB1w B,"5B(B+BHMa@inmenu|SMO__SRP_0K)^ Form_m_reserv Form_m_reserv7*\CC:\Program Files\Microsoft Office\Office\UTILITY.MDArU~~~~~p mPdDEST  a VCN        flight_no flight_datestaff_nowork_hrs  PrimaryKeyela@equipment@666*******( @݄`@݄`@~sq_cm_reserv~sq_cs_passeng, *@[TTTH<<<<<<: `neV˭`@ϥ`@Mainmenu))))))))))' mT˭`@5`@m_reserv))))))))))' jPc`@U`@qryC6F40 Using Allg[@@\WKK?3333331 `Z1`Qa@ذ`@qryC6S1-07 Flights from PHX to LAX between 3pm and 12am@ C@b@ g|ppdXXXXXXV `.@@eѯ`@qryC6S1-03 Flights from PHX to LAXC@B@g[OOCCCCCCCA @Z,`@`@qryC6S1-12 PHX to LAX fares with 20 percent disc C@5B@guii]QQQQQQO `+\@BѺ`@qryC6S2-23 Average fare from PHX to LAXC@B@g`TTHHHHHHHF @'@>`@qryC6F13 Flights between 10:00am and 8:00pmC@b@gdXXLLLLLLLJ @#@`@qryC6F12 Flights with orig time > 10:00C@b@e`TTHHHHHHHF @Z!C@׬`@qryC6F17 New fare is 1/2 (old + 25 surcharge), >50C@ b@ek__SSSSSSSQ @ Z:gy@uҬ`@qryC6F17 15 and 40 percent discountO@)b@c\PPDDDDDDDB @ H@Q`@qryC6F15 All passengers with flights on 7/15/92 C@b@@cthh\PPPPPPN `,s7@@passenger(@b666*******( @`ޒ@ p`@qryC6F34 Null~ C@FB@cRFF:......, `[|@5`@qryC6F38 Not existsC@b@cL@@44444442 @!llS\@llS\@MSysModules2----------+ hLVALtN  ŞŞŞŞŞŏ |miZK<8)ĺĺĺĺĺĺĺħeR?wQ, \=qO.V}  }ۇ O8V#jK]x͠{|/+O($_AV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o }  q o oۇ O8V#jK]x͠{|/+O($_AV#jKV#jK}I`@I`@~sq_cm_passeng~sq_cs_ticket<<<<<<<<<<: |T٭`@k]V٭`@print tickets  rD<e Form_m_reserv Form_Mainmenu airwest72F=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBA332.DLLVBA  APJ_N? 3C:\Program Files\Microsoft Office\Office\MSACC8.OLBAccess 1Y`^F>C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\dao2535.tlbDAOER 9apmPdDESTmPdDESTpdDESTmPdDEST31?FormSC7? FormHeader1EC7?TicketAC7?Text24Detail0@C7? Confirm_No_res_dateres_name res_phonePC7? s_passengText30MC7? Embedded8 FormFooter2ER_Click Ticket_Click t__SRP_1*rU~~~~~