Standard ACE DBnb` Ugr@?~1y0̝cßFNe7ڜ(@(` {6߱$jC13gy[+|*|n"f_Љ$g'DeFx -bT4.0dvp  Y_ROHOS __ Y  R Y  Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2 Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeFWJ )-YYIdParentIdName        OYS  ^Y Y Y  Y 2ACMFInheritableObjectIdSID( YObjectId YS  Y  Y Y Y  Y  Y IY  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute   -Y S  Y Y Y  Y . Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship9 6N  HtYYYszObject$szReferencedObjectszRelationship v1b N  : k &  @: ;@@  @@@ @   @@ @@@@ @ @ @JmmQbOQQkJmmQbOQQkkoLSdi`Q`f^dvQQkQqQbmSQQkMWQOo^QkoLSdi`QqQbmmvfQkQqQbmk QqQbmkkoLSdi`!SQQkMWQOo^Qk"`vMd`fJbvYbSdi`JmYdb#fJv`Qbm`QmWdOk$fJv`Qbmk%fiYbmYbqdYMQ&iQUYkmiJmYdb'iQfdimOJmQiJbUQ(U^dLJ^MdOQ)JmmQbOQQ^YkmYbU*YbqdYMQ+kJ^QkLvQ`f^dvQQ)kJ^QkLvQqQbmmvfQ)OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MJmmQbOQQk+kh+MJmmQbOQQkkoLSdi`)+kh+MQqQbmk+kh+MQ`f^dvQQYO)+kh+MQqQbmk+kh+MQqQbmSQQkMWQOo^QkoLSdi`)+kh+MQqQbmk+kh+MQqQbmkkoLSdi`)+kh+MQqQbmk+kh+MQqQbmmvfQYO)+kh+MSQQkMWQOo^Qk+kh+MQqQbmYO)+kh+MfJv`Qbmk+kh+MfJv`Qbm`QmWdOYO)+kh+SJmmQbOQQkkoLSdi`) +kh+SQ`f^dvQQk) +kh+SQqQbmmvfQk) +kh+SQqQbmk) +kh+SQqQbmkkoLSdi`) +kh+SSQQkMWQOo^Qk)+kh+S`vMd`fJbvYbSdi`JmYdb)+kh+SfJv`Qbm`QmWdOk)+kh+SfJv`Qbmk)+kh+iJmmQbOQQ^YkmYbU)+kh+iYbqdYMQ)+kh+ikJ^QkLvQ`f^dvQQ)+kh+ikJ^QkLvQqQbmmvfQ)JmmQbOQQMdobmLvQqQbm)JmmQbOQQk)Q`f^dvQQk)QqQbmmvfQk)QqQbmk)S+FHSL6OJ>L:BL>@OQO>MS:FFHSMDFJJ:DBF>F6@6B6>O6+ +;K[+ HLHMBBDLSMHF>8S8LOQ<68<:JFDD>BO<>6<@@:SF+ +;K[+ OHOD6SQDL8FO><>JL8@<@OOL8MM>FFQJ+ +;K[+ OQM8O6>8B8F<6JH6LL:LHD:FFO:MH<:8MOM6S8>D+ +;K[+ Q>QLB8LQ66LJ>JM@LB>6Q8FQ:O+ +;K[+ QHDJQQLF8HL6>DQQHQF::J<6QFSQQHMQO>B6MLQ6:SD@DQ>@+ +;K[  @ @ @ @ @ @ @ @ @ @ @ @      !"#$%&'()*+)))))) )!)")#) $) %) &) ') ()))*)+),)-).)/)0)123456789:;     !#%'/)6);)?)G)N)S)))) )!)")#)$)%)&v1 D - @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!""###$#%$&$'$(%)%*%+&,&-&.'/'0'1(2(3(4)5)6)7*8*9*:+;+<+=,>,?,@-A-B-C.D.E.F/G/H/I0J001112223334445 5!5"6#6$6%7&7'7(8)8*8+9,9-9.:/:0:1;2;3;4CDEFGHI456./0+,-()*%&'!"!#!$## #!%1%2%3'''///666;; ; ? ? ? GGGNNNSSS789:;<=>?@AB       !"#v1 (@T @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @********* *  * ** ***** ****** * * * *  * *!*!* !*!!*"! *#!*"*$"*&"*'"*(" *)"*%#**#*,#*-#*.#*/#*0#*1#*2#*3#*4#*5#*6#*7#*8# *9#*+$*:$*<$*=$*;%*>%*@%*A%*?&*B&*D&*E&*C'*F'*H'*I'*J'*K'*L'*M'*N'*O'*P',',',' ,'*G(,(,(,(,),), ), ), *, *,*,*, +,+,+,+,+,+,,,,,,,,,,,,,,,,,-,-, -,!-,"-,#-,$-,%-,&-,'-,(-,)-,*-,.,+.,-.,..,/.,0.,1.,2.,3.,4.,5.,6.,7.,8.,9.,:.,;.,<.,=.,>. ,?. ,@. ,A. ,B. ,C.,,/,D/,F/,G/,H/,I/,J/./././././././././. /. /. /. / . / ./ ./ ./ ./,E0.0.0.0.0.0.0 .0.1.1.1.1.1.1. 1 .!1.2."2.$2.%2.&2.'2.(2 .)2.#././././. /. /. /. / . / ./ ./,Ev1@ @@@+ 8Q:Q8JLJ:@66>MDFJJ:DBF>F6@6B6>O6+ +;K[+ HLHMBBDLSMHF>8S8LOQ<68<:JFDD>BO<>6<@@:SF+ +;K[+ OHOD6SQDL8FO><>JL8@<@OOL8MM>FFQJ+ +;K[+ OQM8O6>8B8F<6JH6LL:LHD:FFO:MH<:8MOM6S8>D+ +;K[+ Q>QLB8LQ66LJ>JM@LB>6Q8FQ:O+ +;K[+ QHDJQQLF8HL6>DQQHQF::J<6QFSQQHMQO>B6MLQ6:SD@DQ>@+ +;K[  @  QqQbmkQqQbmkSQQkMWQOo^QkfJv`QbmkfJv`QbmkiQUYkmiJmYdbiQUYkmiJmYdbiQUYkmiJmYdbiQUYkmiJmYdb @JmmQbOQQkQ`f^dvQQkQ`f^dvQQkQqQbmmvfQkQqQbmkQqQbmkSQQkMWQOo^QkfJv`Qbm`QmWdOkiQUYkmiJmYdbE,d _ Z  G q  0 =XTG5k40DT+Ao|h7u@|h7u@Invoice........ƾ=@ƾ=@InvoicekF @<<<0000000. @+*=@+*=@Attendee Listingk@NNNBBBBBBB@ @hcÖ=@hcÖ=@Global Codek88888888886 `=@`=@Registrationk6 @FFF:::::::8 @A=@A=@Print Invoicek~@HHH<<<<<<<: @ =@ =@Paymentsk @>>>22222220 @Ɏ=@Ɏ=@Payment Methodsk@LLL@@@@@@@> @P=@P=@My Company Informationk@ZZZNNNNNNNL @;=@;=@Fee Schedulesk&@HHH<<<<<<<: @_=@_=@Eventsk @:::......., @ !=@!=@Event Typesk:@DDD88888886 @ f=@f=@Event Fee Schedule Subformk8@bbbVVVVVVVT @ 갖=@갖=@Employeesk@@@@44444442 @ *=@*=@Attendees SubformkR@PPPDDDDDDDB @ =@=@Attendeesk.@@@@44444442 @ yZ=@yZ=@UserDefinedkA@DDD88888886 @ yZ=@K@SummaryInfok|@DDD88888886 @yZ=@yZ=@SysRelk.........., yZ=@yZ=@Scriptsk0000000000. yZ=@yZ=@Reportsk0000000000. yZ=@yZ=@Modulesk0000000000. yZ=@yZ=@Formsk,,,,,,,,,,* yZ=@yZ=@DataAccessPagesk@@@@@@@@@@> 'zrR@zrR@MSysComplexType_AttachmentTTTTTTTTTTT %zrR@zrR@MSysComplexType_TextHHHHHHHHHHH #zrR@zrR@MSysComplexType_DecimalNNNNNNNNNNN !zrR@zrR@MSysComplexType_GUIDHHHHHHHHHHH zrR@zrR@MSysComplexType_IEEEDoubleTTTTTTTTTTT zrR@zrR@MSysComplexType_IEEESingleTTTTTTTTTTT zrR@zrR@MSysComplexType_LongHHHHHHHHHHH zrR@zrR@MSysComplexType_ShortJJJJJJJJJJJ zrR@zrR@MSysComplexType_UnsignedByteXXXXXXXXXXX zrR@zrR@MSysComplexColumnsDDDDDDDDDDD ;Z=@;Z=@MSysRelationshipsiDDDDDDDDDDB ;Z=@;Z=@MSysQueriesi88888888886 ;Z=@;Z=@MSysACEsi22222222220 ;Z=@;Z=@MSysObjectsi88888888886 ;Z=@Wz@MSysDbkC@. :::......., @;Z=@;Z=@Relationshipsi<<<<<<<<<<: ;Z=@;Z=@Databasesi44444444442 ;Z=@;Z=@Tablesi.........., D YN Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDU`!UTT@(TYYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@ GfY NY  ValuedvfY NY  ValuedvfY NY  ValuedvfY NY  ValuedvfY N  Y  ValuedvfY N""Y  ValuedvfY N$$Y ValuedvfY N&& Y  ValuedvaYN(( Y Y  Y Y  Y  Y UFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b'"Ok M $ Lu JA =J IVRH G*l#CCr9{)j7u@)j7uѫ=@_j7u@Registrationk:iFFF:::::::8 @h=@^j7u@Paymentsk@>>>22222220 @"=@<ɖ=@Payment Methodsk@LLL@@@@@@@> @=@W9ۖ=@My Company Informationk@ZZZNNNNNNNL @RȨ-u@RȨ-u@ MSysResourcesk<<<<<<<<<<: ErR@5eErR@ MSysNavPaneObjectIDsk4MR2KeepLocal  TJJJJJJJH @YrR@QrR@ MSysNavPaneGroupsk4MR2KeepLocal  TDDDDDDDB @S;Z=@;Z=@ MSysAccessStoragekDDDDDDDDDDB NN&=@^j7u@Fee Schedulesk@HHH<<<<<<<: @GRȨ-u@SȨ-u@ f_89FB037064DA4B26B45DED4CF2889F3C_Datakppppppppppn ?-=@_j7u@Eventsk+i:::......., @;z=@Ɩ=@Event Typesk@DDD88888886 @6=@MƖ=@Employeesk@@@@44444442 @/<=@_j7u@Attendeesk- @@@@44444442 @0V}=@r˖=@Attendee Count by EventkW@|@h\\PPPPPPPN @ .=@=@~sq_rSales by Employeek4MR2KeepLocal TNNNNNNNL @-=@=@~sq_rInvoicek4MR2KeepLocal Tzzz:::::::8 @ +ݖ=@ݖ=@~sq_fPaymentsk4MR2KeepLocal T|||<<<<<<<: @*pܖ=@pܖ=@~sq_fPayment Methodsk4MR2KeepLocal TJJJJJJJH @ (ږ=@ږ=@~sq_fFee Schedulesk4MR2KeepLocal TFFFFFFFD @ &Ֆ=@Ֆ=@~sq_fEventsk4MR2KeepLocal Txxx88888886 @ $8Җ=@8Җ=@~sq_fEmployeesk4MR2KeepLocal T~~~>>>>>>>< @#Wі=@z?і=@~sq_fAttendees Subformk4MR2KeepLocal TNNNNNNNL @!ږ=@ږ=@~sq_cFee Schedules~sq_cEventIDk4MR2KeepLocal T^^^^^^^\ @ _Ֆ=@Ֆ=@~sq_cEvents~sq_cEventTypeIDk4MR2KeepLocal TXXXXXXXV @_Ֆ=@_Ֆ=@~sq_cEvents~sq_cEvent Fee Schedule Subformk4MR2KeepLocal Tvvvvvvvt @_Ֆ=@_Ֆ=@~sq_cEvents~sq_cEmployeeIDk4MR2KeepLocal TVVVVVVVT @=@=@Sales by Event Typek@TTTHHHHHHHF @z=@z=@Sales by Employeek@PPPDDDDDDDB @Qp4G u E ' d 4   a C  s U 7  a C  }_A#{4t/Vg7mO%eV', Registration.RegistrationFee; g', Attendees.CompanyName4 g', Attendee Name^@+7++ o', Registration.AttendeeID6 g', Registration.EventID3 g'], Sum Of Payments Query;;; '], Registration))) '], Attendees### ',  G'],  ',  G&ts Events & s  G&ts  &s  G%|Event Types''' % | G%| %| G$|Employees### $ | G$| $| G# ], Registration.RegistrationID: '#, EventsRegistrationF@+A5 #, RegistrationSum Of Payments Query@+_S) #, Registration.AttendeeID6 g#, P@+ g#, Registration.SalesTaxRate8 g#, Events.StartDate/ g#, Events.EventName/ g#, Registration.RegistrationFee; g#, Registration.RegistrationID: g#], Sum Of Payments Query;;; #], Registration))) #], Events #,  G#],  #,  G" |![Payment Methods].PaymentMethod> '"|[Payment Methods].*2 g"|Payment Methods/// "| G"| "| G! Events.EventName/ '! Events.*' g!Events ! G! ! G ], [Event Types].EventType6 ' , [Event Types].*. g ], Event Types'''  ,  G ],   ,  G|([__EventID] = EventID)6 '|Events@+) 7 | G|__EventID### O| | G([__EventID] = EventID)6 'Fee SchedulesEvents77+   G__EventID### O  G ati![LastName] & ", " & [FirstName]> 'ti![LastName] & ", " & [FirstName]> gti[EmployeeID]+ gatiEmployees### ati ti G|([__AttendeeID] = AttendeeID)< '|Attendees@+/# 7 | G|__AttendeeID))) O| | GLVALJ Bn(z@,d Vb [Event Types].EventTypeID=Events.EventTypeIDSum([Sum Of Payments Query].[Total Payments])Sum(Clng(Registration.RegistrationFee*(1+Registration.SalesTaxRate)*100)/100)Employees.LastName & ", " & Employees.FirstNameAttendees.AttendeeID=Registration.AttendeeIDEmployees.EmployeeID=Registration.EmployeeIDEvents.EventID=Registration.EventIDAttendees.AttendeeID=[Total Registrations by Attendee].AttendeeID[Total Registrations by Attendee].[Total Registrations]((Payments.RegistrationID=forms!Attendees![Attendees Subform].form!RegistrationID))[AttendeeLastName] & ", " & [AttendeeFirstName]Attendees.AttendeeID=Registration.AttendeeIDRegistration.RegistrationID=[Sum Of Payments Query].RegistrationID[Sum Of Payments Query].[Total Payments][AttendeeLastName] & ", " & [AttendeeFirstName]Events.EventID=Registration.EventIDRegistration.RegistrationID=[Sum Of Payments Query].RegistrationID[Sum Of Payments Query].[Total Payments]SELECT DISTINCTROW [Registration].[EventID], [Registration].[AttendeeID], [AttendeeLastName] & ", " & [AttendeeFirstName] AS [Attendee Name], [Attendees].[CompanyName], [Registration].[RegistrationFee], [Sum Of Payments Query].[Total Payments] FROM [Attendees] INNER JOIN ([Registration] LEFT JOIN [Sum Of Payments Query] ON [Registration].[RegistrationID] = [Sum Of Payments Query].[RegistrationID]) ON [Attendees].[AttendeeID] = [Registration].[AttendeeID] ORDER BY [AttendeeLastName] & ", " & [AttendeeFirstName];SELECT DISTINCTROW [Registration].[RegistrationID], [Registration].[RegistrationFee], [Events].[EventName], [Events].[StartDate], [Registration].[SalesTaxRate], [Sum Of Payments Query].[Total Payments], [Registration].[AttendeeID] FROM [Events] INNER JOIN ([Registration] LEFT JOIN [Sum Of Payments Query] ON [Registration].[RegistrationID] = [Sum Of Payments Query].[RegistrationID]) ON [Events].[EventID] = [Registration].[EventID] ORDER BY [Registration].[RegistrationID];KjZ< z \  b 8  R  w Y ; { D QmOCD {/o!N}M/Registration))) /Events /Event Types''' /Employees### / G/ / G. D Events.Location. g. D Events.StartDate/ g. D Events.EventName/ g. D [Event Types].EventType6 g. D ^@- g.ID p@- '.D EventsRegistrationF@-A5 .D EmployeesRegistrationX@-G;# .D RegistrationSum Of Payments Query@-_S) .D Event TypesEventsX@+?3' .D Total PaymentsZ@+9-- o.D RegistrationFee@+;// o.D Events.Location. g.D Events.StartDate/ g.D Events.EventName/ g.D [Event Types].EventType6 g.D Employee Name^@+7++ o.ID Sum Of Payments Query;;; .ID Registration))) .ID Employees### .ID Events .ID Event Types''' .D  G.ID  .D  G-s AttendeesRegistrationX@+G;# -s EmployeesRegistrationX@+G;# -s EventsRegistrationF@ +A5 -s  Employees.** g-s  Events.*' g-s Registration.*- g-s  Attendees.** g-ts Registration))) -ts Events -ts Employees### -ts Attendees### -ts  -s  G,AtAttendeesTotal Registrations by Attendee@ +ma# ,Atn@ + g,At Attendees.** g,[AtTotal Registrations by AttendeeOOO ,[AtAttendees### ,At G,[At ,At G+@ + '+ Payments.*) g+Payments!!! + G+ + G*Payment Methods/// *  G* * G)My Company Information=== )  G) ) G(NamFee Schedules+++ ( am G(Nam (am G' ], ^@ + '', AttendeesRegistrationX@+G;# ', RegistrationSum Of Payments Query@+_S) ', P@+ gLVAL|$n   f P >Count(Registration.RegistrationID)Count(Registration.RegistrationID)Employees.LastName & ", " & Employees.FirstName(((Registration.RegistrationDate)>=forms![Report Date Range]![Beginnining Registration Date] And (Registration.RegistrationDate)<=forms![Report Date Range]![Ending Registration Date]))Employees.EmployeeID=Events.EmployeeIDEvents.EventID=Registration.EventIDRegistration.RegistrationID=[Sum Of Payments Query].RegistrationID[Event Types].EventTypeID=Events.EventTypeIDSum([Sum Of Payments Query].[Total Payments])Sum(Clng(Registration.RegistrationFee*(1+Registration.SalesTaxRate)*100)/100)Employees.LastName & ", " & Employees.FirstNameEmployees.LastName & ", " & Employees.FirstName(((Registration.RegistrationDate)>=forms![Report Date Range]![Beginnining Registration Date] And (Registration.RegistrationDate)<=forms![Report Date Range]![Ending Registration Date]))Events.EventID=Registration.EventIDEmployees.EmployeeID=Registration.EmployeeIDRegistration.RegistrationID=[Sum Of Payments Query].RegistrationIDO*u9~6 8 x 5 X :  j  j L  x5D2 Registration.AttendeeID6 g2Total RegistrationsD@-C77 o2Registration.AttendeeID6 g2Registration))) 2 G2 G2 2 G1 Payments.RegistrationID6 g1Total PaymentsSum(Payments.PaymentAmount)V-- o1Payments.RegistrationID6 g1Payments!!! 1 G1 G1 1 G0 NaRegistration.EventID3 g0NaNumber of Registered AttendeesD@-YMM o0NaRegistration.EventID3 g0tNaRegistration))) 0Na G0Na G0tNa 0Na G/ ^@ - g/ Events.Location. g/ Events.StartDate/ g/ Events.EventName/ g/ [Event Types].EventType6 g/p@ - '/EmployeesEventsL@ -;/# /EventsRegistrationF@ -A5 /RegistrationSum Of Payments Query@ -_S) /Event TypesEventsX@-?3' /Total PaymentsZ@-9-- o/RegistrationFee@-;// o/Event Manager^@-7++ o/Events.Location. g/Events.StartDate/ g/Events.EventName/ g/[Event Types].EventType6 g/Sum Of Payments Query;;;  kY N 00Y  Y < Y d Y d Y d Y  Y d Y ( Y  ( Y  (< Y < Y *AttendeeID"AttendeeFirstName AttendeeLastName TitleCompanyNameAddressCityProvincePostalCodePhoneNumberFaxNumber Notestfgoi02Aeasvt03riosmoe0405YYYYY.rE AttendeeLastNameCompanyNamePostalCodePrimaryKey 00 v1b  /G e HariKumarSales ManagerPacific Imports90 Walden Rd.VancouverBritish ColumbiaV2R4T6416-555-1717416-555-5646ug_MB3"   RenePhillipsSales RepresentativeOld World Delicatessen2743 Baring St.EdmontonϲT2R1X8403-555-7584403-555-2880~ph_UD,   JeanFresnireMarketing AssistantMre Paillarde43 rue St. LaurentMontralQubecH1J 1C3514-555-8054514-555-8055ykbZP<,   JaimeYorresOwnerLet's Stop N Shop87 Polk St. Suite 5TorontoOntarioM1E2R3416-555-5938416-555-5939{{m_WNE/   ElizabethBrownSales RepresentativeConsolidated HoldingsBerkeley Square 12 BreweryHalifaxNova ScotiaB4G9Q1902-555-2282902-555-9199ylcE.  /@Lidsb1SiQkbYQiQ1\o`Ji1fWY^^Yfk1vdiiQk1 /@Mdbkd^YOJmQOWd^OYbUk1^QmkkmdfbkWdf1`QiQfJY^^JiOQ1d^Osdi^OOQ^YMJmQkkQb1fJMYSYMY`fdimk1 /  L>UHh81W8[8M<1`8Q:i<1m:i8uF1q:i>mB1 / 11111 'YN77Y  Y d Y d Y d Y < Y l<EmployeeIDFirstNameLastName TitleExtensionWorkPhonete79Ltm7:tYYLastNamePrimaryKeyv1 6i= EchoGarrowayMarketing Director208(403) 555-7777?/* ?OsgoodeWhitesideLegal Counsel207(403) 555-7777>.)?AndreaBainesLAN Administrator206(403) 555-7799>.)?DeborahGeryloHR Manager205(403) 555-77778(#?LanceSwayleSetup Technician204(403) 555-7799<,' ?PeterHollingsTechnical Director203403) 555-7799?0+ ?KarenBussmanMedia Liaison202(403) 555-7777:*% ? 6 @LJYbQk8Lokk`Jb8UJiidsJv8UQiv^d8Wd^^YbUk8ksJv^Q8sWYmQkYOQ8 6 @8888888YN<<Y  Y dEventTypeIDEventType<>YPrimaryKeyv1@ i;Advance SalesCommunication SkillsComputer TrainingLeadership Seminars ;==== Y N@@Y  Y dY  Y ( Y Y Y Y Y  Y  (Y  Y  * Y  D Y  iY ,EventIDEventNameEventTypeID StatusLocationStartDateEndDateStartTimeEndTime RequiredStaffingConfirmedAvailableSpaces EventDescription NotesEmployeeID@C@D@EYY @FYNYYYYY.rE.rFEmployeeIDEventNameEventTypeIDPrimaryKey @@ @@, v1b N @ LVALBBasic computer skills Basic computer skills everyone should master.Cutting-edge strategies for increasing your sales productivity.How to get to a win/win outcome in any negotiating situation.Essential public-speaking skills for business professionals.?@@??2Computer Basics for BusinessChateau St. Mark/@AnnbPP2Y`@`@??dSales, Sales, SalesChateau St. MarkA@AeeYGG2Y@@??2Negotiating ExcellenceChateau St. Mark?@Ahh\JJ2Y`@@??dPublic Speaking SkillsChateau St. Mark>@Ahh\JJ2Y ?BBBB ? Md`fomQiLJkYMkSdiLokYbQkkBbQUdmYJmYbUQuMQ^^QbMQBfoL^YMkfQJ\YbUk\Y^^kBkJ^QkkJ^QkkJ^QkB ?BBBB ?BBBB 1Y%K \NHHYP Y Y  Y JY  Y  Y )7Y5g _DataFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL$MSysResources_Data%TN(*gHKHZL19@HLF$eZO @92HMYYY _Data$IdxFKPrimaryScalar$MSysComplexPKIndexHHHHs v1b &LVAL6. x^Vy4kY&L0%L֒%K \ c'Bמ,Id߲U+C##[Lk_ҕnLq=<|@kqVe4Pp bAimzoYڍ*1Q?Oje";: oKCijJ}gbW$ *ٛ-\LRɳ/˰K6œUb"!_^5#4bÍ̋C|]15I)7%R[jpp-ES5gi# ůk9)=Rפ41m}0RyWzyj]H>>תE[ڀZلC۽s=@ʉ_a [y6'$m{pwuY:˱_å[YLC&_IqoN~NU>5jF*(a0la %sG2jT'nN?( *Qg t ӁڔHZLQ uF]HX1A9]7jl^<@㧛1TJSF$2sD1ס#eZrOg F@o92+-)el=#h%c@^?v+C`yzӡA)NdcMw5y`@ЙGeFiM eH\| ^Ÿ>𳦨c<;Ehu'J TՏKXU})xr=SvhYˮyp<@*WC]$t*PV‡UXXwqGׯэCacl& 6'eO~vr@.:cKxeR#ҍC'ÈRǢ2 NJ3*oI@ -Zԝb>qL@%'ACNnX \+I@a+M!K ] _D"H5]m}6 : 1u-Y--?4=@/o-dTuCiרW #Z& 60Fg#JӔtlgth|0 ӏh=e&SL]:pFC|(5;j/_ k y) w:R)mDc9#ltW5KmMl/oȉ7bd̥5ocH(Nl/D'b[+MB_H$KTA_FdU<0JN{/6Vydqsih 'VZRЖ147m"7m5r VPy!",t,$ PfRԎٺkeo9Ƕ'sc!?&EKSe.g }=Uކ*FeXO}5Jqfǰ^1Nfc| fԄ)8n"QvjEM^0cX/#w}3Eg/w-A\Fw$HjhAO#q5f;Pwխt.=s7+WQQxg*UE>dZ4Sa.n3`-[ =IhlIoEO9r]ܢeKGK_{PMr +1xմS0!2L E[6!`b@%Y)\G|?b;;I2XiQY넫 m(*EmVdoNX[0*/V ԅaK[sW9 nn,Cfv#ysG$(q&8exFDEIH+y|plWǓ/[Z㑫G@gTypeInfo<:62" ;=@ږ=@=2j iBlob<2.*" ;=@ږ=@<7  w=@`ٖ=@:PropData7PLH8 =@`ٖ=@9@gTypeInfo7:62" =@`ٖ=@8h iBlob72.*" =@`ٖ=@76  w_=@yIؖ=@5PropData2PLH8 _=@yIؖ=@4@gTypeInfo2:62" _=@yIؖ=@3Db iBlob22.*" _=@yIؖ=@25  w!=@Ӗ=@0PropData-PLH8 !=@Ӗ=@/@ZTypeInfo-:62" !=@Ӗ=@.@aBlob-2.*" !=@Ӗ=@-4  wf=@0Ӗ=@+PropData(PLH8 f=@0Ӗ=@*@ZTypeInfo(:62" f=@0Ӗ=@) @`Blob(2.*" f=@0Ӗ=@(3  w갖=@NҖ=@&PropData#PLH8 갖=@NҖ=@%@ZTypeInfo#:62" 갖=@NҖ=@$^ iBlob#2.*" 갖=@NҖ=@#2  w*=@і=@!PropDataPLH8 *=@і=@ @ZTypeInfo:62" *=@і=@ [ iBlob2.*" *=@і=@1  w*=@t.@@ZPropData:62" *=@t.@@ZDirData:62" =@Wі=@PropDataPLH8 =@Wі=@@ZTypeInfo:62" =@Wі=@):VhBlob2.*" =@Wі=@0  w1=@B@VBA$  w1=@B@VBAProject2.* wZ=@Z=@MSysDbDirData PLH8 yZ=@yZ=@CustomGroups62. wyZ=@yZ=@ Blob &" wyZ=@yZ=@ 0   wyZ=@Z=@ Databases0,( wyZ=@yZ=@ DataAccessPages<84 w;Z=@;Z=@ Cmdbars,($ w;Z=@B@VBA$  w;Z=@;Z=@Scripts,($ w;Z=@hcÖ=@Modules,($ w;Z=@q=@Reports,($ w;Z=@t.@Forms($  w;Z=@rR@jiPropDataPLH8 ;Z=@;Z=@MSysAccessStorage_SCRATCHPLH w;Z=@rR@MSysAccessStorage_ROOTJFB wLVALhW ^02=5B>a)b*ce gh6i j%&k )?l,-@x  KKMг.roy  UĞ\wA.:O>i͖=@AttendeesT_4_Hͱoϖ=@Attendees Subform/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Queryqz!E%#6Un~LRGa!RegistrationID eZgGZNz6Un~LRGa!RegistrationFee6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Payments[~XI&>u~6Un~LRGa!AttendeeID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID+RH%\9Ğ\wA.:O>AttendeeIDm ЄG,ʠĞ\wA.:O>CompanyNameE]F&Ğ\wA.:O>Addresspn7@}5Ğ\wA.:O>City ?FwOĞ\wA.:O>Provinceu6_BNaaDĞ\wA.:O>PostalCode ,B[zĞ\wA.:O>AttendeeFirstName~}xVAbpĞ\wA.:O>AttendeeLastNameҥ\_A ۱*Ğ\wA.:O>Title1wLچ8!lĞ\wA.:O>PhoneNumbeŗG+:M[8f9dĞ\wA.:O>FaxNumbersO^S2BQOĞ\wA.:O>Notes  Attendees AttendeesW "[Event Procedure] @ Arialp "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`, FormHeaderx ׽ODh1U2R`6Haxb8c,h%i Register &Register...~ "[Event Procedure]" @MS Sans Serifx O('LoDMih1U2P`6axbc,h%iLVALXi Payments &Payments...~ "[Event Procedure]" @MS Sans Serifx T<0Cjh1U2V`6 axbc,h%ii PreviewInvoice &Pre&view Invoice...~ "[Event Procedure]" @MS Sans Serifx #{CGGJ4m847U;C`6@axc,k AttendeeID AttendeeIDx jĄwUB2oId5U7`6axbc,d# e%i  AttendeeID Label AttendeeID" @MS Sans Serif  AttendeeID_Labelx (dd8Gq=>`,  Detailx |ͻuIRq m47U;`6axb c,e  CompanyName CompanyNamex %^INesd25U7`6Haxbc,d# e% "CompanyName Label Company Name" @MS Sans Serif "CompanyName_Labelx U~Jw/ o}m47U;`6ab c,k Address Addressx &.GEZG Wd25U7`6Habc,d# e% Address Label Address" @MS Sans Serif Address_Labelx GSu`_K >Q۳m47U;`6ab c,e k City Cityx cAQEd25U7`6Habc,d# e% City Label City" @MS Sans Serif City_Labelx Ul^B@m47U;`6ab c,ek StateOrProvince Provincex c;!F[ʊd25U7`6HaLVALYbc,d# e% *StateOrProvince Label Province" @MS Sans Serif *StateOrProvince_Labelx B[A{Bk`F5m47U;`6ab c,ek PostalCode PostalCodeH 00000\-9999x LjL bEa?d25U7`6Habc,d# e%  PostalCode Label Postal Code" @MS Sans Serif  PostalCode_Labelx 7pWa)b*cg h6XiJjAk 9?lϖ=@x T_4_Hͱy  U/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Queryqz!E%#6Un~LRGa!RegistrationID eZgGZNz6Un~LRGa!RegistrationFee6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Payments[~XI&>u~6Un~LRGa!AttendeeID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID0֋3@A.T_4_HͱSale Amount[.A,LVAT_4_HͱTotal Payments  TSELECT DISTINCTROW Registration.RegistrationID, Registration.RegistrationFee, Events.EventName, Events.StartDate, Registration.SalesTaxRate, [Sum Of Payments Query].[Total Payments], Registration.AttendeeID FROM Events INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Events.EventID=Registration.EventID ORDER BY Registration.RegistrationID;  Attendeesd27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx )wA*+`,  Detailx  c%@ai7?m47U;C`6b c,e  EventName EventName "[Event Procedure]x gRja?Mٖˑ"qd25U7bc,d# e%LVAL] EventName Label Event Name" @MS Sans Serif EventName_Labelx k׾B9^dm47U;C`6ahb c,eVk StartDate StartDate& Short Date "[Event Procedure]H 99/99/00;0x UQA'\`d25U7ahbc,d# e% StartDate Label Start Date" @MS Sans Serif StartDate_Labelx ?H(Ur8m80G47U;C`6ab c,e7k Sale Amount =[RegistrationFee]+CLng((([SalesTaxRate]*[RegistrationFee])*100))/100& *$#,##0.00;($#,##0.00) "[Event Procedure] Sale_Amountx 0֋3@A.d25U7abc,d# e% "Sale Amount Label Sale Amount" @MS Sans Serif "Sale_Amount_Labelx t0Cׄ m80G47U;C`6a8b c,e7k Total Payments Total Payments& *$#,##0.00;($#,##0.00) "[Event Procedure] Total_Paymentsx [.A,LVAd25U7a8bc,d# e% (Total Payments Label Total Payments" @MS Sans Serif (Total_Payments_Labelx A̹F?Rʳm80G47U;C`6ab c,e7k Amount Due F=[Sale Amount]-nz([Total Payments])& *$#,##0.00;($#,##0.00) "[Event Procedure] Amount_Duex LLf]@jZۥ!Jd25U7abc,d# e%  Amount Due Label Amount Due" @MLVALS Sans Serif  Amount_Due_Labelx )[zNRb}H`,@@ FormFooterx %#xM!׹ LVAL i_ ^02=5B>a)b*ce gh6M ijk [?l0e/-@x ?䴍&zJ~Iy  UuB( /MƖ=@Employees5ZSLn UuB( /EmployeeID5LBL=u~nuB( /FirstName5۹VGzRuB( /LastNameJ;W) L  uB( /TitlelvYNrx-uB( /WorkPhone g.F<]wzuB( /Extension  Employees Employees @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx E=mC@6a`,N   Detailx MrFe=JICm847U;C`68ahbc,e EmployeeID EmployeeIDx 1DґM!Kd25U7`6ahbc,d# e%  EmployeeID Label Employee ID" @MS Sans Serif  EmployeeID_Labelx klF:@m47U;C`68abc,e k FirstName FirstNamex I`.9H-8d25U7`6abc,d# e% FirstName Label First Name" @MS Sans Serif FirstName_Labelx L'Lx(H#m47U;C`68a8bc,e k ULVALeLastName LastNamex e DJG!d25U7`6a8bc,d# e% LastName Label Last Name" @MS Sans Serif LastName_Labelx JISLm47U;C`68abc,e k  Title  Titlex hD1OH=?Hd25U7`6abc,d# e% Title Label  Title" @MS Sans Serif Title_Labelx qdtHmnm47U;C`68abc,e k WorkPhone WorkPhoneH $000\-000\-0000;0;_x .L͋=Aid25U7`6abc,d# e% WorkPhone Label Work Phone" @MS Sans Serif WorkPhone_Labelx D@O\Vm47U;C`68apbc,e k Extension Extensionx 1NS@rR-1d25U7`6apbc,d# e% Extension Label Extension" @MS Sans Serif Extension_Labelx `E@|-[`,@@ FormFooterx  QRPK\QGd-!LVAL ^02=5B>a)b*cgh6XiJjAk ?l܅,@x ZCBP y  U\B/懞NҖ=@Fee Schedules_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞Fee  Fee Schedules  Eventsd27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx >THGQ3-[`,  Detailx 6JMъ(r5Km47U;C`6b c,e  FeeDescription FeeDescriptionx ϷGҞDz d25U7bc,d# e% (FeeDescription Label Fee Description" @MS Sans Serif (FeeDescription_Labelx L{m0G47U;C`6ahb c,e7k Fee Fee& *$#,##0.00;($#,##0.00)x ԡmmK]x_$d25U7ahbc,d# e% Fee Label Fee" @MS Sans Serif Fee_Labelx !vBJJ `,@@ FormFooterx Z D=_DALVALQ ^02=5B>a)b*ce gh6XiJjk ?l0e/-@x }T)@HjrUe>y  URB>G,|Ɩ=@Event Typesh .3NkMRB>G,|EventTypeID)P!6NWLw$+YRB>G,|EventType  Event Types Event Types @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx R[;׍Ah$zw`,F  Detailx !JDmrIm847U;C`68ahbc,e EventTypeID EventTypeIDx /W\FBv?}~d25U7`6ahbc,d# e% "EventTypeID Label Event Type ID" @MS Sans Serif "EventTypeID_Labelx ҮU M&N+m47U;C`68abc,e k EventType EventTypex NOQ`d25U7`6abc,d# e% EventType Label Event Type" @MS Sans Serif EventType_Labelx A,GBX`,@@ FormFooterx .2WKKܽLVAL ic ^02=5B>a)b*c e gh6XiJjA(k R?lO#--@x QaY+F oPy  U/ (H_&x yǖ=@EventsZCBP ]*Ӗ=@Y Event Fee Schedule Subform\B/懞NҖ=@Y Fee SchedulesM]F\p\B/懞EventID(_Mjcb-/ (H_&x EventID6{N4)/ (H_&x EventName/U:9u&JVp / (H_&x EventDescriptionQ5v8A}7J&/ (H_&x Locationdԧoo]EyµN/ (H_&x EventTypeIDRB>G,|Ɩ=@Event Types)P!6NWLw$+YRB>,9L<܈^/ (H_&x EmployeeIDuB( /MƖ=@Employees5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName81RwD]x/ (H_&x Status7[)ANݎ/ (H_&x StartDateӧ\PWGJ/ (H_&x EndDate`[EçNK/ (H_&x StartTime/F3A/ (H_&x EndTime%" QJ~z/ (H_&x AvailableSpaces6vIVQaY+F oPAvailableSpacesφgMIIXZQaY+F oPEvents SubformglW>Ck:řo֖=@>E0Events SubformĞ\wA.:O>i͖=@Attendees6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Query\ LE`V6Un~LRGa!EventID[~XI&>u~6Un~LRGa!AttendeeID~}xVAbpĞ\wA.:O>AttendeeLastName ,B[zĞ\wA.:O>AttendeeFirstNamem ЄG,ʠĞ\wA.:O>CompanyName eZgGZNz6Un~LRGa!RegistrationFee)N39H8SCO~Total Paymentsqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID+RH%\9Ğ\wA.:O>AttendeeID   Events  Events @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,LVALd FormHeaderx Ե`I|{jh1U2V`6axbc,h%i Toggle View $&View Fee Schedule~ "[Event Procedure]" @MS Sans Serif Toggle_Viewx J۴@bH`,`,  Detailx CDrھTm47U;`6Pa<b c,e  EventName EventNamex K HLf 3Id25U7`6Ta<blc,d# e% EventName Label Event Name" @MS Sans Serif EventName_Labelx PwKD@vym47U;`6Pahb c,k  EventDescription  EventDescriptionx /Ln ]d25U7`6Tahblc,d# e% ,EventDescription Label "Event Description" @MS Sans Serif ,EventDescription_Labelx ]H3THtmm47U;`6Pab c,k Location Locationx hOqApX:Kd25U7`6Tablc,d# e% Location Label Location" @MS Sans Serif Location_Labelx *@w2kOݸ-<oC25U9`Fb@ c6Pde f,h nZ ,"";"";"";"";"10";"100"x 6.A![6 EventTypeID EventTypeID] Table/Query[ SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType;   0;2880 "[Event Procedure]x "[Event Procedure]Y $"SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType; ";"Event Types";"";"EventTypeID";"EventType";"PrimaryKey"d25U7`6TaLVALeblc,d# e% "EventTypeID Label Event Type" @MS Sans Serif "EventTypeID_Labelx :pL1LhoC25U9`Fb@ c6Pde f,h nZ ("";"";"";"";"10";"0"x Lry^OAtD EmployeeID EmployeeID] Table/Query[ SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];   0;2880 "[Event Procedure]x "[Event Procedure]Y ~"SELECT [EmployeeID], [LastName] & "", "" & [FirstName] FROM Employees ORDER BY [LastName] & "", "" & [FirstName]; ";"Employees";"";"EmployeeID";"LastName] & "", "" & [FirstName";"PrimaryKey"d25U7`6Tablc,d# e%  EmployeeID Label Event Director" @MS Sans Serif  EmployeeID_Labelx MgEn#Pm47U;`6Pab c,ek  Status  Statusx ҉UVFHXFjd25U7`6Tablc,d# e% Status Label  Status" @MS Sans Serif Status_Labelx &lM$Ábm47U;`6a<bc,k StartDate StartDate& Short DateH 99/99/00;0x ,XWJS靘.d25U7`6a<bc,d# e% StartDate Label Start Date" @MS Sans Serif StartDate_Labelx a$YEUm47U;`6ahbc,k EndDate EndDate& Short DateH 99/99/00;0x ^ZKCd25U7`6ahbc,LVALfd# e% EndDate Label End Date" @MS Sans Serif EndDate_Labelx N6G$hm47U;`6abc,k StartTime StartTime& Medium TimeH 09:00\ >LL;0x n#+:DLXJd25U7`6abc,d# e% StartTime Label Start Time" @MS Sans Serif StartTime_Labelx pBD=H0 $m47U;`6abc,k  EndTime EndTime& Medium TimeH 09:00\ >LL;0x *J[0(&d25U7`6abc,d# e% EndTime Label End Time" @MS Sans Serif EndTime_Labelx eBR"m47U;`6abc,k  AvailableSpaces AvailableSpacesx 6vIVd25U7`6abc,d# e% *AvailableSpaces Label  Available Spaces" @MS Sans Serif *AvailableSpaces_Labelx `0O(Am80G47U;`6abc,k   Spaces Remaining =[AvailableSpaces]-IIf([Events Subform].Form.RecordsetClone.RecordCount=0,0,[Events Subform].Form![Total Attendees])&  Fixed  Spaces_Remainingx &NGXd25U7`6abc,d# e% ,Spaces Remaining Label  Spaces Remaining" @MS Sans Serif ,Spaces_Remaining_Labelx  PGT!p3_`6Hao bc,od  4Event Fee Schedule Subform >Form.Event Fee S LVAL chedule Subform1 EventID2 EventID 4Event_Fee_Schedule_Subformx b¸MIJd5]`6Hapb7c, @Event Fee Schedule Subform Label Fee Schedules: @Event_Fee_Schedule_Subform_Labelx _h}G/Rxp3`6Hao b}c,od  Events Subform &Form.Events Subform1 EventID2 EventID Events_Subformx φgMIIXZd5`6Hapbc, (Events Subform Label Attendees: (Events_Subform_Labelx xE|{8FqAcv`,@@ FormFooterx P7zK@LVALZ L l3ͬ^YN.'/™FormHeaderDetailmRegistrationIDd RegistrationID_LabelRegistrationID LabelmEvent_NameEvent Named Event_Name_LabelEvent Name LabeloPaymentMethodIDd PaymentMethodID_LabelPaymentMethodID LabelmPaymentDated PaymentDate_LabelPaymentDate Labelm PaymentAmountd PaymentAmount_LabelPaymentAmount Labelm CardholdersNamed CardholdersName_LabelCardholdersName LabelmCreditCardNumberd CreditCardNumber_LabelCreditCardNumber LabelmCreditCardExpDated CreditCardExpDate_LabelCreditCardExpDate LabelmCreditCardAuthorizationNumberd CreditCardAuthorizationNumber_LabelCreditCardAuthorizationNumber LabelFormFooterPaymentIDͬ QQH{ {O3/<FormHeaderDetailmPaymentMethodIDd PaymentMethodID_LabelPaymentMethodID LabelmPaymentMethodd PaymentMethod_LabelPaymentMethod LabeljCreditCardd CreditCard_LabelCreditCard LabelFormFooterͬ$-L.@$[FormHeaderDetaild InfomCompanyNamed CompanyName_LabelCompanyName LabelmAddressd Address_LabelAddress LabelmCityd City_LabelCity Labelm StateOrProvinced StateOrProvince_LabelStateOrProvince Labelm PostalCoded PostalCode_LabelPostalCode Labelm Countryd Country_LabelCountry LabelmPhoneNumberd PhoneNumber_LabelPhoneNumber LabelmFaxNumberd FaxNumber_LabelFaxNumber LabelmSalesTaxRated SalesTaxRate_LabelSalesTaxRate LabelmDefaultPaymentTermsd DefaultPaymentTerms_LabelDefaultPaymentTerms LabelmDefaultInvoiceDescriptiond DefaultInvoiceDescription_LabelDefaultInvoiceDescription LabelFormFooterSetupIDProvinceͬ u?KkCc:K]NFormHeaderDetailmFeeScheduleIDd FeeScheduleID_LabelFeeScheduleID LabeloEventIDd EventID_LabelEventID LabelmFeeDescriptiond FeeDescription_LabelFeeDescription LabelmFeed Fee_LabelFee Label FormFooterͬeEhxe@!FormHeadermTotal_AttendeesTotal Attendeesd Total_Attendees_LabelTotal Attendees LabelDetailmAttendeed Attendee_LabelAttendee LabelmCompanyNamed CompanyName_LabelCompanyName LabelmRegistrationFeed RegistrationFee_LabelRegistrationFee Labelm Total_PaymentsTotal Paymentsd Total_Payments_LabelTotal Payments Label FormFooter EventIDAttendeeIDAttendee Nameͬ$9Th9I dNFormHeaderh Toggle_ViewToggle ViewDetailmEventNamed EventName_LabelEventName LabelmEventDescriptiond EventDescription_LabelEventDescription LabelmLocationd Location_LabelLocation Labelo EventTypeIDd EventTypeID_LabelEventTypeID Labelo EmployeeIDd EmployeeID_LabelEmployeeID Labelm Statusd Status_LabelStatus LabelmStartDated StartDate_LabelStartDate LabelmEndDated EndDate_LabelEndDate LabelmStartTimed StartTime_LabelStartTime LabelmEndTimed EndTime_LabelEndTime LabelmAvailableSpacesd AvailableSpaces_LabelAvailableSpaces LabelmSpaces_RemainingSpaces Remainingd Spaces_Remaining_LabelSpaces Remaining LabelpEvent_Fee_Schedule_SubformEvent Fee Schedule Subformd Event_Fee_Schedule_Subform_LabelEvent Fee Schedule Subform LabelpEvents_SubformEvents Subformd Events_Subform_LabelEvents Subform LabelFormFooter EventID!RequiredStaffing"Confirmed#NotesLVAL ii ^02=5B>a)b*cg h6ij>+k R?l֖=@x glW>Ck:řy  UĞ\wA.:O>i͖=@Attendees6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Query\ LE`V6Un~LRGa!EventID[~XI&>u~6Un~LRGa!AttendeeID~}xVAbpĞ\wA.:O>AttendeeLastName ,B[zĞ\wA.:O>AttendeeFirstNamem ЄG,ʠĞ\wA.:O>CompanyName eZgGZNz6Un~LRGa!RegistrationFee)N39H8SCO~Total Paymentsqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID+RH%\9Ğ\wA.:O>AttendeeID P.I1%k#Attendee Name  SELECT DISTINCTROW Registration.EventID, Registration.AttendeeID, [AttendeeLastName] & ", " & [AttendeeFirstName] AS [Attendee Name], Attendees.CompanyName, Registration.RegistrationFee, [Sum Of Payments Query].[Total Payments] FROM Attendees INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Attendees.AttendeeID=Registration.AttendeeID ORDER BY [AttendeeLastName] & ", " & [AttendeeFirstName];   Eventsd27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`, FormHeaderx IkFJ2m847U;C`6a<bc,i Total Attendees (=Count([AttendeeID]) Total_Attendeesx Pa V@TЄd5U7`6<a<LVAL!bc,e%i *Total Attendees Label Total Attendees *Total_Attendees_Labelx >M'`,  Detailx VM16_m847U;C`6b c,e  Attendee Attendee Namex V&JVmd25U7bc,d# e% Attendee Label Attendee" @MS Sans Serif Attendee_Labelx At,N(ᒇm47U;C`6ahb c,e k CompanyName CompanyNamex zpD㰵Wd25U7ahbc,d# e% "CompanyName Label Company Name" @MS Sans Serif "CompanyName_Labelx E' m0G47U;C`6ab c,ek RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x .&jLASpd25U7abc,d# e% *RegistrationFee Label  Registration Fee" @MS Sans Serif *RegistrationFee_Labelx WwCpGR]Zm80G47U;C`6a8b c,e6k Total Payments Total Payments& *$#,##0.00;($#,##0.00) Total_Paymentsx QhpN7rd25U7a8bc,d# e% (Total Payments Label Total Payments" @MS Sans Serif (Total_Payments_Labelx m1[bL`,@@ FormFooterx !e*A;ׅ;LVAL ik ^02=5B>a)b*ce gh6XiJjk e?l/-@x AF LPBYy  U\B/懞NҖ=@Fee SchedulessD<F-q "\B/懞FeeScheduleIDM]F\p\B/懞EventID/ (H_&x yǖ=@Events6{N4)/ (H_&x EventName_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞Fee  Fee Schedules Fee Schedules @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx 6ҹ‚CN9"v`,  Detailx SDtxEYm847U;C`68ahb$ c,e FeeScheduleID FeeScheduleIDx bElD;d25U7`6ahbc,d# e% &FeeScheduleID Label Fee Schedule ID" @MS Sans Serif &FeeScheduleID_Labelx @&DeoC25U9A`Fb@ c68de f,h nZ ,"";"";"";"";"10";"100"x ߲?I=ٟ EventID EventID] Table/Query[ SELECT DISTINCTROW Events.* FROM Events ORDER BY Events.EventName;   0;2880Y "SELECT DISTINCTROW Events.* FROM Events ORDER BY Events.EventName; ";"Events";"";"EventID";"EventName";"PrimaryKey"d25LVALU7`6abc,d# e% EventID Label  Event" @MS Sans Serif EventID_Labelx Ś7.nA93WRm47U;C`68a8b c,e k FeeDescription FeeDescriptionx  4FID'd25U7`6a8bc,d# e% (FeeDescription Label Fee Description" @MS Sans Serif (FeeDescription_Labelx S 4A-ҘI]jm0G47U;C`68ab c,e7k Fee Fee& *$#,##0.00;($#,##0.00)x 5d+N*m@{ld25U7`6abc,d# e% Fee Label Fee" @MS Sans Serif Fee_Labelx #j/3A͇YF1(`,@@ FormFooterx >3T7:BwLVALimZ> ^$F029 =5B>CJa)b*c0!e gh6Fij/+k !?l-,@x lgJʠ$2y H UX57L~ԠEW9ۖ=@My Company Informations?U'M:ɨh@=X57L~ԠECompanyNameoS9@tc!X57L~ԠEAddress1q1yJDJ3X57L~ԠECityM,]QAXV`X57L~ԠEProvinceR[#5N^X57L~ԠEPostalCode_L $X57L~ԠECountryӧﾙ7L X57L~ԠEPhoneNumber.7 P@ -ۇ<X57L~ԠEFaxNumber*G6)X57L~ԠESalesTaxRatea"COḫX57L~ԠEDefaultPaymentTerms+ -ZG{X57L~ԠEDefaultInvoiceDescription  ,My Company Information ,My Company Information @ Arialdd# e%3" @ Ariale23f2 4 3g123I75hg# 3" @ Ariali6 g4h53j6 g4h53k3l3mi# 3" @ Arialnj# 3" @ Arialol# 3" @ Arialp3r45I3zi#j%" @MS Sans Serif`,@@ FormHeaderx wGv']JX(WFX`,  Detailx ԌECu- d5U`6abc, Info Enter your company's name and address information here. You will save the information by closing the form.x 3}OFZَjm7U`6Pab c,e  CompanyName CompanyNamex 3eNq6d5U`6abc, "CompanyName Label Company Name "CompanyName_Labelx dPtx ډI{wVc>m7U`6Pab c,k Address Addressx ?uHKBjB:d5U`6abc,LVALn Address Label Address Address_Labelx wf9vt@:#m7U`6PaDb c,e k City Cityx `L25uOd5U`6aDbc, City Label City City_Labelx ))@8mm7U`6Pab c,ek StateOrProvince Provincex zD( :n!d5U`6ab9c, *StateOrProvince Label Province *StateOrProvince_Labelx pLB#oBj^Xm7U`6Pa b c,ek PostalCode PostalCodeH >L0L\ 0L0x pvFH"[d5U`6a bGc,  PostalCode Label Postal Code  PostalCode_Labelx X:&EN7m7U`6Pa| b c,e k Country Countryx 'N6|D=vDd5U`6a| bc, Country Label Country Country_Labelx |۞N'dȤH=m7U`6Pa b c,e k PhoneNumber PhoneNumberH ,!\(999") "000\-0000;;_x H,md@Qd5U`6a b7c, "PhoneNumber Label Phone Number "PhoneNumber_Labelx pQ#{F}*Um7U`6PaLb c,e k FaxNumber FaxNumberH ,!\(999") "000\-0000;;_x JAtqN狧d5U`6aLbGc, FaxNumber Label Fax Number FaxNumber_Labelx [oAkցdm7U`60abc,k SalesTaxRate SalesTaxRate& Percentx -S6^@Fs;Ưd5U`6sabFc, $SalesTaxRate Label Sales Tax Rate $SalesTaxRate_Labelx DQO:@hQ3(m7U`60a LVAL bc,k  &DefaultPaymentTerms &DefaultPaymentTermsx NRJ7vd5U`6sabc, 2DefaultPaymentTerms Label Payment Terms 2DefaultPaymentTerms_Labelx jo*?N`$f /m7U`60aTbc,k  2DefaultInvoiceDescription 2DefaultInvoiceDescriptionx telJud5U`6saTbc, >DefaultInvoiceDescription Label Invoice Descr >DefaultInvoiceDescription_Labelx [aNH'w`,@@ FormFooterx  ZfMI) _0S4j%u@ K  ! Z } 0 U  Xc;Xc0z1{8o,֖=@`ٖ=@BlobDelta70,( wՖ=@yIؖ=@BlobDelta20,( w۬Ӗ=@Ӗ=@BlobDelta-0,( wqҖ=@0Ӗ=@BlobDelta(0,( w8Җ=@NҖ=@BlobDelta#0,( wϖ=@і=@BlobDelta0,( w<ϖ=@Wі=@BlobDelta0,( whcÖ=@hcÖ=@DirDataCopy62. whcÖ=@hcÖ=@ Global CodeDirDataZVRB hcÖ=@hcÖ=@PropDataCopy62. whcÖ=@hcÖ=@ 0CB0PropDataIEA1 hcÖ=@hcÖ=@ PropDataGC?/ hcÖ=@hcÖ=@0  w=@<=@xPropDatauPLH8 =@<=@w}@TypeInfou:62" =@<=@v'@iBlobu2.*" =@<=@u3  wz=@rl=@sPropDatapPLH8 z=@rl=@r}@TypeInfop:62" z=@rl=@q?iBlobp2.*" z=@rl=@p2  wƾ=@D=@nPropDatakPLH8 ƾ=@D=@m @TypeInfok:62" ƾ=@D=@lYiBlobk2.*" ƾ=@D=@k1  w=@q=@j0 0CB0 1CB0 2CB0 3CB0PropDatajfbR =@q=@i@ZDirData:62" +*=@=@gPropDatadPLH8 +*=@=@fQ@xTypeInfod:62" +*=@=@e+,iBlobd2.*" +*=@=@d0  w9=@z=@]PropDataZPLH8 9=@z=@\}@xTypeInfoZ:62" 9=@z=@[NiBlobZ2.*" 9=@z=@Z13" w`=@3=@XPropDataUPLH8 `=@3=@W@xTypeInfoU:62" `=@3=@V]RyiBlobU2.*" `=@3=@U12" wA=@ߖ=@SPropDataPPLH8 A=@ߖ=@R8@xTypeInfoP:62" A=@ߖ=@QviBlobP2.*" A=@ߖ=@P11" w2I=@Eޖ=@NPropDataKPLH8  =@Eޖ=@M9@gTypeInfoK:62"  =@Eޖ=@L/riBlobK2.*"  =@Eޖ=@K10" wɎ=@+ܖ=@IPropDataFPLH8 Ɏ=@+ܖ=@H*@gTypeInfoF:62" Ɏ=@+ܖ=@G piBlobF2.*" Ɏ=@+ܖ=@F9  wP=@1ܖ=@DPropDataAPLH8 LVALiq ^02=5B>a)b*ce gh6M ijk ! ?l[G.-@x Ҷ'oGhņy @ U,,eG<7<ɖ=@Payment Methods^41HX5,,eG<7PaymentMethodIDDU#t,,eG<7PaymentMethod">8>x&T,,G<7CreditCard  Payment Methods Payment Methods @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx x0[}A"Y`,  Detailx u 7R)̇A$m847U;C`68ahbc,e PaymentMethodID PaymentMethodIDx ~HAV-d25U7`6ahbc,d# e% *PaymentMethodID Label Pymt Method ID" @MS Sans Serif *PaymentMethodID_Labelx nqLR|U?m47U;C`68abc,e k PaymentMethod PaymentMethodx 7\JAHd25U7`6abc,d# e% &PaymentMethod Label Payment Method" @MS Sans Serif &PaymentMethod_Labelx kz gO4V]j12U`68a8i CreditCard CreditCardx :ءa)b*c(e gh6XiJjk R?lݖ=@x m:D6`~y  UkXHAՏ6'd̖=@Payments/(G_ƍTkXHAՏ6'RegistrationID KKMг.roWі=@AttendeesjN<ʅ KKMг.roAttendees SubformPaymentMethodID,,eG<7<ɖ=@Payment MethodsDU#t,,eG<7PaymentMethodPaymentDatePaymentAmountCardholdersNameCreditCardNumberCreditCardExpDateCreditCardAuthorizationNumber  SELECT DISTINCTROW Payments.* FROM Payments WHERE ((Payments.RegistrationID=forms!Attendees![Attendees Subform].form!RegistrationID));  Paymentsz "[Event Procedure]M "[Event Procedure] @ Arialp "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx .AEuW(`,  Detailx Q5MBa1 m847U;C`6ahb c,e RegistrationID RegistrationID x=forms![Attendees]![Attendees Subform].form![RegistrationID]x  P zGg49d25U7`6ahbc,d# e% (RegistrationID Label Registration ID" @MS Sans Serif (RegistrationILVALtD_Labelx j ^029 =5B>a)b*c,e g h6 ij+ k ?l.-@x rC-Í7y . U  Print Invoice @ Ariald27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx ~Rh~CF ٛ ň`,   Detailx ktC<+m847U;C`68ab c,e Registration ID x=Forms![Attendees]![Attendees Subform].form![RegistrationID] Registration_IDx 5!^GOGd25U7`6abc,d# e% *Registration ID Label Registration ID" @MS Sans Serif *Registration_ID_Labelx 3>ѦBH?Nmm847U;C`68ab c,eVk Invoice Date& Short Date =Date()H 99/99/00 Invoice_Datex q~@RNd25U7`6abc,d# e% $Invoice Date Label Invoice Date" @MS Sans Serif $Invoice_Date_Labelx vdiI؟Um80G47U;C`68ab c,e7kLVAL& Invoice Amount& *$#,##0.00;($#,##0.00) p=Forms![Attendees]![Attendees Subform].form![Amount Due] Invoice_Amountx A 6|JnUOd25U7`6abc,d# e% (Invoice Amount Label Invoice Amount" @MS Sans Serif (Invoice_Amount_Labelx 팾( ~M: m47U;C`68ab c,k &Invoice Description =Dlookup("[DefaultInvoiceDescription]","My Company Information") &Invoice_Descriptionx ⛁ԇH_9d25U7`6abc,d# e% 2Invoice Description Label Invoice Descr" @MS Sans Serif 2Invoice_Description_Labelx ry@y"@zm47U;C`68aDb c,k Payment Terms t=Dlookup("[DefaultPaymentTerms]","My Company Information") Payment_Termsx ʼn0"IId25U7`6aDbc,d# e% &Payment Terms Label Payment Terms" @MS Sans Serif &Payment_Terms_Labelx `6R6EbRh1U`6a bc,h%ii OK OK~ "[Event Procedure]" @MS Sans Serifx |SMgh1U`6a bc,h%ii  Cancel  Cancel~ "[Event Procedure]" @MS Sans Serifx ?-WN]G`,@@ FormFooterx Ű&>C0ɪ0TLVAL 8 jͬ \JOq!B0ReportHeaderdLabel14PageHeaderdAttendee_Name_LabelAttendee Name LabeldCompanyName_LabelCompanyName LabeldCity_State_Province_LabelCity/State/Province LabeldPhoneNumber_LabelPhoneNumber LabeldFaxNumber_LabelFaxNumber LabeldAttended_LabelAttended Labelf Line1f Line2 Detailm Attendee_NameAttendee Namem CompanyNamemCity_State_ProvinceCity/State/ProvincemPhoneNumbermFaxNumbermAttendedPageFootermText15mText16ReportFooterAttendeeIDAttendeeFirstNameAttendeeLastNameTitleAddressCityProvincePostalCodeNotesTotal Registrationsͬf#6/XJx㨋FormHeaderDetailmBeginnining_Registration_DateBeginnining Registration Dated Beginnining_Registration_Date_LabelBeginnining Registration Date LabelmEnding_Registration_DateEnding Registration Dated Ending_Registration_Date_LabelEnding Registration Date Labelh PreviewFormFooterͬ! Y#@Ke߼FormHeaderDetailmAttendeeIDd AttendeeID_LabelAttendeeID LabelmRegistrationIDd RegistrationID_LabelRegistrationID LabelmRegistrationDated RegistrationDate_LabelRegistrationDate LabelmAttendeed Attendee_LabelAttendee Labelo EmployeeIDd EmployeeID_LabelEmployeeID Labelm PurchaseOrderNumberd PurchaseOrderNumber_LabelPurchaseOrderNumber LabeloEventIDd EventID_LabelEventID LabeloFeeScheduleIDd FeeScheduleID_LabelFeeScheduleID LabelmRegistrationFeed RegistrationFee_LabelRegistrationFee LabelmRemaining_SeatsRemaining Seatsd Remaining_Seats_LabelRemaining Seats LabelmSalesTaxRated SalesTaxRate_LabelSalesTaxRate LabelmSales_TaxSales Taxd Sales_Tax_LabelSales Tax LabelmTotal_ChargesTotal Chargesd Total_Charges_LabelTotal Charges LabelmTotal_PaidTotal Paidd Total_Paid_LabelTotal Paid LabelmAmount_DueAmount Dued Amount_Due_LabelAmount Due Label FormFooterͬJqY'ٙFormHeaderDetailmRegistration_IDRegistration IDd Registration_ID_LabelRegistration ID LabelmInvoice_DateInvoice Dated Invoice_Date_LabelInvoice Date LabelmInvoice_AmountInvoice Amountd Invoice_Amount_LabelInvoice Amount LabelmInvoice_DescriptionInvoice Descriptiond Invoice_Description_LabelInvoice Description Labelm Payment_TermsPayment Termsd Payment_Terms_LabelPayment Terms Labelh OKh CancelFormFooterLVALiz ^02=5B>a)b*c`e gh6XiJj'k R?{ "[Event Procedure]lu~6Un~LRGa!AttendeeID KKMг.roWі=@AttendeesjĄwUB2oI KKMг.roAttendeeIDĞ\wA.:O>i͖=@Attendees+RH%\9Ğ\wA.:O>AttendeeIDRegistrationIDRegistrationDateEmployeeIDuB( /MƖ=@Employees5ZSLn UuB( /EmployeeID5۹VGzRuB( /LastName5LBL=u~nuB( /FirstNamePurchaseOrderNumberEventID/ (H_&x yǖ=@Events(_Mjcb-/ (H_&x EventID6{N4)/ (H_&x EventName%" QJ~z/ (H_&x AvailableSpacesFeeScheduleID\B/懞NҖ=@Fee SchedulesM]F\p\B/懞EventIDRegistrationsD<F-q "\B/懞FeeScheduleID_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞FeeRegistrationFee(W:1A~4$]MSJEventIDSalesTaxRate&pyUG]d$]MSJSalesTaxRate!| D!Jg$]MSJRegistrationFeeW\RfEZ}-D@$]MSJSales Tax #I e$]MSJRegistrationIDYN/Bn$]MSJTotal ChargesC L@ZYW$]MSJTotal Paid  nSELECT DISTINCTROW Registration.* FROM Attendees INNER JOIN Registration ON Attendees.AttendeeID=Registration.AttendeeID WHERE ((Registration.AttendeeID=forms!Attendees!AttendeeID));  RegistrationW "[Event Procedure]M "[Event Procedure] @ Arialp "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2LVAL{" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx ^9H=AӦ-Q`,   Detailx ;Q,L|%>)m847];C`6ab4c, AttendeeID AttendeeID >=forms![Attendees]![AttendeeID]x gmQ-As8Td25]7`6abc,d# e%  AttendeeID Label AttendeeID" @MS Sans Serif  AttendeeID_Labelx 'J@{Q hm847;C`6abc,k RegistrationID RegistrationIDx  #I ed257`6abc,d# e% (RegistrationID Label Registration ID" @MS Sans Serif (RegistrationID_Labelx dPx"K1.lk m47U;C`6abc,k  RegistrationDate  RegistrationDate& Short Date =Date()H 99/99/00;0x 3RCWBSJfE(v<d25U7`6abc,d# e% ,RegistrationDate Label "Registration Date" @MS Sans Serif ,RegistrationDate_Labelx 173vJ3cm847U;C`6ab c,e k Attendee =Forms!Attendees!AttendeeFirstName & " " & Forms!Attendees!AttendeeLastNamex Ӏ~F7,Ȳxd25U7`6abc,d# e% Attendee Label Attendee" @MS Sans Serif Attendee_Labelx &bAϐ$LVAL|<oC25U9A`Fb@ c6de f,h nZ ("";"";"";"";"10";"0"x ]IuG#δ EmployeeID EmployeeID] Table/Query[ SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];   0;2880 "[Event Procedure]x "[Event Procedure]Y ~"SELECT [EmployeeID], [LastName] & "", "" & [FirstName] FROM Employees ORDER BY [LastName] & "", "" & [FirstName]; ";"Employees";"";"EmployeeID";"LastName] & "", "" & [FirstName";"PrimaryKey"d25U7`6abc,d# e%  EmployeeID Label Salesperson" @MS Sans Serif  EmployeeID_Labelx bW@WCzwMm47U;C`6aTb c,e k &PurchaseOrderNumber &PurchaseOrderNumberx ALF5d25U7`6aTbc,d# e% 2PurchaseOrderNumber Label PO Number" @MS Sans Serif 2PurchaseOrderNumber_Labelx Ϭ8 Aev-ǭoC25U9A`Fb@ c6de f,h nZ 8"";"";"";"";"";"";"10";"100"x (W:1A~4 EventID EventID] Table/Query[ SELECT DISTINCTROW Events.EventID, Events.EventName, Events.AvailableSpaces FROM Events ORDER BY Events.EventName;  0;2880;0V "[Event Procedure] "[Event Procedure]x "[Event Procedure]Y H"SELECT DISTINCTROW Events.EventID, Events.EventName, Events.AvailableSpaces FROM Events ORDER BY Events.EventName; ";"Events";"";"EventID";"EventName";"PrimaryKey"d25U7`6abc,d# e% LVAL}EventID Label  Event" @MS Sans Serif EventID_Labelx B"_E"w2o25U9A`Fb@ c6d$ e f,h nZ 6"";"";"";"";"";"";"10";"60"x Dծ7|Ev&jփI FeeScheduleID FeeScheduleID] Table/Query[ rSELECT DISTINCTROW [Fee Schedules].FeeScheduleID, [Fee Schedules].FeeDescription, [Fee Schedules].Fee FROM [Fee Schedules] WHERE (([Fee Schedules].EventID=forms!Registration!EventID));  0;1500;960V "[Event Procedure] "[Event Procedure]x "[Event Procedure]d25U7`6a$ bc,d# e% &FeeScheduleID Label Fee Schedule" @MS Sans Serif &FeeScheduleID_Labelx șɀ@=om0G47U;C`6a b c,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x !| D!Jgd25U7`6a bc,d# e% *RegistrationFee Label  Registration Fee" @MS Sans Serif *RegistrationFee_Labelx usAEDU7m847U;C`6a b c,k  Remaining Seats 8=IIf(isnull([EventID]),0,EventID.Column(2)-DLookup("[Number of Registered Attendees]","Attendee Count by Event","[EventID]=forms![Registration]![EventID]")) Remaining_Seatsx  cWO>8(Ud25U7`6a bc,d# e% *Remaining Seats Label Remaining Seats" @MS Sans Serif *Remaining_Seats_Labelx @g.JQ5m47U;C`6ab@c,k  SalesTaxRate SalesTaxRateLVAL~& Percent f=Dlookup("[SalesTaxRate]","My Company Information")x &pyUG]dd25U7`6abc,d# e% $SalesTaxRate Label Sales Tax Rate" @MS Sans Serif $SalesTaxRate_Labelx %?oլK꜡ ?m80G47U;C`6ab@c,k  Sales Tax n=CLng((([SalesTaxRate]*nz([RegistrationFee]))*100))/100& *$#,##0.00;($#,##0.00) Sales_Taxx W\RfEZ}-D@d25U7`6abc,d# e% Sales Tax Label Sales Tax" @MS Sans Serif Sales_Tax_Labelx 1rD@+Bm80G47U;C`6ab@c,k  Total Charges <=[RegistrationFee]+[Sales Tax]& *$#,##0.00;($#,##0.00) Total_Chargesx YN/Bnd25U7`6abc,d# e% &Total Charges Label Total Charges" @MS Sans Serif &Total_Charges_Labelx MCHjxxm80G47U;C`6ab@c,k  Total Paid =IIf(isnull([RegistrationID]),0,Dsum("[PaymentAmount]","Payments","[RegistrationID]=" & [RegistrationID]))& *$#,##0.00;($#,##0.00) Total_Paidx C L@ZYWd25U7`6abc,d# e%  Total Paid Label Total Paid" @MS Sans Serif  Total_Paid_Labelx CKB6m80G47U;C`6aTb@c,k Amount Due B=[Total Charges]-nz( LVAL' [Total Paid])& *$#,##0.00;($#,##0.00) Amount_Duex 4NE6#yzd25U7`6aTbc,d# e%  Amount Due Label Amount Due" @MS Sans Serif  Amount_Due_Labelx _aDX@=K`,@@ FormFooterx 5^Cf*aHLVALiZ> ^029 =5B>a)b*ce gh6 ijk ?l/-@x ==.L$Ezy . U  "Report Date RangeM "[Event Procedure] @ Ariald27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx sc>F4Di`,  Detailx \}CSQ=#m47U;C`6abVc,eV :Beginnining Registration Date& Short DateH 99/99/00 :Beginnining_Registration_Datex HQWJl1'd25U7`6abcc,d# e% FBeginnining Registration Date Label  Begin. Reg. Date" @MS Sans Serif FBeginnining_Registration_Date_Labelx lG~\Вem47U;C`6abVc,eVk 0Ending Registration Date& Short DateH 99/99/00 0Ending_Registration_Datex p gV/CeVbd25U7`6abcc,d# e% <Ending Registration Date Label  Ending Reg. Date" @MS Sans Serif <Ending_Registration_Date_Labelx Eo%SvA Ta"h1U2V`6@ atbc,h%iLVALi Preview Pre&view...~ "[Event Procedure]" @MS Sans Serifx ̇C u(`,@@ FormFooterx &ܪM:dF+2MLVALi ^0:<=5B>a)b*c2e gh6ij0*k ?y "[Event Procedure]l%=@x h B+DщRy \ UĞ\wA.:O>i͖=@AttendeesE/eeIq4=@Total Registrations by AttendeeT<"NE_Y&E/eeITotal Registrations+RH%\9Ğ\wA.:O>AttendeeID[~XI&>u~E/eeIAttendeeID~}xVAbpAttendeeLastName ,B[zAttendeeFirstNamem ЄG,ʠCompanyNamepn7@}5City ?FwOProvince1wLچ8!lPhoneNumbeŗG+:M[8f9dFaxNumber  SELECT DISTINCTROW Attendees.*, [Total Registrations by Attendee].[Total Registrations] FROM Attendees LEFT JOIN [Total Registrations by Attendee] ON Attendees.AttendeeID=[Total Registrations by Attendee].AttendeeID;   Attendee Listing @ Arial 82hh (\ SdXXLetterTPRIV ''''2 dArial@ENGLISHBRS1MF1A.EXEBRRBATOM_8500opt_8500.inicop_8500.iniMF850ini.datMF850def.datBRS1MF1A.EXEZCONFIDENTIALHArialdLVALArialSunMonTueWedThuFriSatJanFebMarAprMayJunJulAugSepOctNovDecdEOSC .(BMFC:d27d# e%" @ Ariale24 fg3I75jg4h5m5I<Ci# " @Times New Romann7=Ij# " @Times New Romano3I:Al# " @Times New Romanp4I  AttendeeLastName  AttendeeLastName "AttendeeFirstName "AttendeeFirstNameK`, ReportHeaderx m&H}Ad28`6Ha<bm c,d#e% Label14  Attendee Listing" @Times New Romanx xE*DK1`, PageHeaderx P(tOػd`6Ha<bpc,d# e% &Attendee Name Label Attendee Name  DetachedLabel &Attendee_Name_Labelx TeQHif|d`6 a<bpc,d# e% "CompanyName Label Company Name  DetachedLabel "CompanyName_Labelx 1/=AEkDyd`6a<bpc,d# e% 2City/State/Province Label &City/State/Province  DetachedLabel 2City_State_Province_Labelx mK:P+@:_Fd`6pa<bpc,d# e% "PhoneNumber Label Phone Number  DetachedLabel "PhoneNumber_Labelx |wIaΗid`6(#a<bpc,d# e% FaxNumber Label Fax Number  DetachedLabel FaLVALxNumber_Labelx _(>0A76+<bxc,d# e% Attended Label Registrations  DetachedLabel Attended_Labelx OR/Ozx!ۿf2 `6Hb2  Line1x >gjICY]f2 `6Hab2  Line2x D ^^I 0EuK`,h  Detailx > uK2&{m`6Hbpc,, Attendee Name `=[AttendeeLastName] & ", " & [AttendeeFirstName] Attendee_Namex P/0@4ۀrTm`6 bpc,,k CompanyName CompanyNamex  Ap(0JƦa\m`6bpc,,k &City/State/Province 6=[City] & ", " & [Province] &City_State_Provincex ו]I*m`6pbpc,,k PhoneNumber PhoneNumberH &!\(999") "000\-0000x y!OCH 9m`6(#bpc,,k FaxNumber FaxNumberH &!\(999") "000\-0000x 읛OB"m`6+bxc,,k Attended &Total Registrationsx _ .lBŞGP"`, PageFooterx 7 D.m;`6Habc,,i# j%  Text15  =Now()& Long Datex W^*F5m;`6abc,,i# j%k  Text16 H="Page " & [Page] & " of " & [Pages]x ՀD5MMFg*kK`, ReportFooterx .1MPILVALi ^0:<=5B>a)b*c$e g2h6ij0*k ?y "[Event Procedure]l=@x tuELXy  UĞ\wA.:O>i͖=@AttendeesuB( /MƖ=@Employees/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID5ZSLn UuB( /EmployeeIDs5K~u=G#6Un~LRGa!EmployeeID+RH%\9Ğ\wA.:O>AttendeeID[~XI&>u~6Un~LRGa!AttendeeIDrC-Í7ߖ=@Print Invoiceq~@RNrC-Í7Invoice Date[Attendees].[AttendeeID]qz!E%#RegistrationID u[tMkRRRegistrationDateNC_PurchaseOrderNumberʼn0"IIrC-Í7Payment Terms ,B[zAttendeeFirstName~}xVAbpAttendeeLastNamem ЄG,ʠCompanyNameE]F&Addresspn7@}5City ?FwOProvinceu6_BNaaDPostalCode6{N4)EventNameQ5v8A}7J&Location7[)ANݎStartDateӧ\PWGJEndDate`[EçNKStartTime/F3AEndTime eZgGZNzRegistrationFeeq|[N61fSalesTaxRateK~GJUӂKtuELXRegistrationFee"'gHML tuELXSales Taxá)Jm%NutuELXRegistrationIDtuELX=@Invoicel Lz"tuELXTotal#i~o:IhtuELXTotal Payments⛁ԇH_9rC-Í7Invoice Description  (SELECT Attendees.*, Registration.*, Events.*, Employees.* FROM Attendees INNER JOIN (Employees RIGHT JOIN (Events INNER JOIN Registration ON Events.EventID=Registration.EventID) ON Employees.EmployeeID=Registration.EmployeeID) ON Attendees.AttendeeID=Registration.AttendeeID;  InvoiceM "[Event Procedure]N "[Event Procedure] @ Arial 8$h (\ SdXXLetterTPRIV LVAL''''2 dArial@ENGLISHBRS1MF1A.EXEBRRBATOM_8500opt_8500.inicop_8500.iniMF850ini.datMF850def.datBRS1MF1A.EXEZCONFIDENTIALHArialdArialSunMonTueWedThuFriSatJanFebMarAprMayJunJulAugSepOctNovDecdEOSC .(BMFC:d27d# e%" @ Ariale24 fg3I75jg4h5m5I<Ci# " @Times New Romann7=Ij# " @Times New Romano3I:Al# " @Times New Romanp4I RegistrationIDK`, ReportHeaderx N7w1cKg@d28`6Ha<b7c,d#e% Label47 Invoice" @Times New Romanx ?kNUP`, PageHeaderx ͔DҀ*C3K`, GroupHeader0xLVAL >2K@3m5I`6Hbc,, CompanyName d=Dlookup("[CompanyName]","My Company Information")x .JLJ#C-Yxm5I`6Hahbc,,k CompanyAddress \=Dlookup("[Address]","My Company Information")x  @sL2顣m5I`6Habc,,k  CompanyCityState t=Dlookup("[City]","My Company Information") & ", " & Dlookup("[StateOrProvince]","My Company Information") & " " & format(Dlookup("[PostalCode]","My Company Information"),"!&&&&&-&&&&")x ܵaZIh[5m5I`6Ka8bc,,k CompanyPhoneFax \="Phone: " & Format(Dlookup("[PhoneNumber]","My Company Information"),"(&&&) &&&-&&&&") & " Fax: " & Format(Dlookup("[FaxNumber]","My Company Information"),"(&&&) &&&-&&&&")x b֏@|H6m5I`6a4bc,,k Invoice Date J=forms![Print Invoice]![Invoice Date]& Short Date Invoice_Datex { _NrV|$X_d`6Ha4bDc, $Invoice Date Label Invoice Date $Invoice_Date_Labelx ԛ4TGepSm5I`6a bc,,k Attendee ID 0[Attendees].[AttendeeID] Attendee_IDx вRH<Gtd`6Ha bDc, "Attendee ID Label Attendee ID "Attendee_ID_Labelx \CCV)'m5I`6a bc,,k RegistrationID RegistrationIDx á)Jm%Nud`6Ha bDc, (RegistrationID Label Registration ID (RegistrationID_Labelx 9+@iFLkm5I`6a4bec,,k  RegistrationDate  RegistrationDate& Short DateH 99/99/00;0x VnIԐd`6a4bDc, ,RegistrationDate Label "RegistLVALration Date ,RegistrationDate_Labelx 6S$1Fϳj@m5I`6a b c,,k &PurchaseOrderNumber &PurchaseOrderNumberx +'L.d`6a bDc, 2PurchaseOrderNumber Label PO Number 2PurchaseOrderNumber_Labelx UtH$}fm5I`6a b c,,k   Terms L=forms![Print Invoice]![Payment Terms]x MGM Dq(Kd`6a bDc, Terms Label  Terms Terms_Labelx JfFҦ]e`66a"bc,   Box17x b OsLwd`6a bc, Attendee Attendee:x U,%hB%hvm5I`6a bc,,k  Attendee1 ^=[AttendeeFirstName] & " " & [AttendeeLastName]x 79;HZ m5I`6abc,,k  CompanyName1 CompanyNamex ,ќFf3m5I`6ahbc,,k  Address Addressx NGL.m5I`6abc,,k  Address2 =[City] & ", " & [Province] & " " & Format([PostalCode],"!&&&&&-&&&&")x NG"EK`,  Detailx M+ 6nD2OoGN>] m5I`6 ahbc,, EventName EventNamex ni@+9d`6ahbPc, EventName Label Event Name EventName_Labelx C:hL(Vm5I`6 abc,,k Location Locationx ymATl3d`6abPc, Location Label Location Location_Labelx z#"6DQEʾ m5I`6 a8bc,,k StartDate StartDate& Short DateH 99/99/00;0x LVAL '/ Iy#"`d`6a8bPc, StartDate Label Start Date StartDate_Labelx 0flLL;0x ]JAs&=d`6abPc, StartTime Label Start Time StartTime_Labelx kBNrx/ m5I`6 apbc,,k EndTime EndTime& Medium TimeH 09:00\ >LL;0x *SFܛd`6apbPc, EndTime Label End Time EndTime_Labelx OTnm0G5I`6 a bc,,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x K~GJUӂKd`6a bPc, *RegistrationFee Label  Registration Fee *RegistrationFee_Labelx riPhoneNumber?FaxNumber@Attendees.NotesARegistration.AttendeeIDBRegistration.EmployeeIDCRegistration.EventIDDSalesTaxRateEFeeScheduleIDFEvents.EventIDGEventTypeIDHStatusIRequiredStaffingJConfirmedKAvailableSpacesLEventDescriptionMEvents.NotesNEvents.EmployeeIDOEmployees.EmployeeIDPFirstNameQLastNameREmployees.TitleSExtensionTWorkPhoneLVALi ^0:<=5B>a)b*c2e gh6iXj0*k R?y "[Event Procedure]l5=@x 炃+HG y  U6Un~LRGa!r˖=@Registration u[tMkRR6Un~LRGa!RegistrationDate==.L$Ezz=@Report Date RangeHQWJl1'==.L$EzBeginnining Registration Datep gV/CeVb==.L$EzEnding Registration DateRB>G,|Ɩ=@Event Types/ (H_&x yǖ=@EventsuB( /MƖ=@Employees8SCO~͖=@Sum Of Payments Query5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName)P!6NWLw$+YRB>G,|EventType6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateQ5v8A}7J&/ (H_&x Location eZgGZNz6Un~LRGa!RegistrationFeeq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Paymentsh .3NkMRB>G,|EventTypeIDdԧoo]EyµN/ (H_&x EventTypeIDqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID5ZSLn UuB( /EmployeeIDs5K~u=G#6Un~LRGa!EmployeeID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventIDEmployee Name[I }炃+HG Employee NameMM\6炃+HG RegistrationFee  SELECT DISTINCTROW Employees.LastName & ", " & Employees.FirstName AS [Employee Name], [Event Types].EventType, Events.EventName, Events.StartDate, Events.Location, Sum(Clng(Registration.RegistrationFee*(1+Registration.SalesTaxRate)*100)/100) AS RegistrationFee, Sum([Sum Of Payments Query].[Total Payments]) AS [Total Payments] FROM ([Event Types] RIGHT JOIN Events ON [Event Types].EventTypeID=Events.EventTypeID) INNER JOIN (Employees RIGHT JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Employees.EmployeeID=Registration.EmployeeID) ON Events.EventID=Registration.EventID WHERE (((Registration.RegistrationDate)>=forms![Report Date Range]![Beginnining Registration Date] And (Registration.RegistrationDate)<=formLVALs![Report Date Range]![Ending Registration Date])) GROUP BY Employees.LastName & ", " & Employees.FirstName, [Event Types].EventType, Events.EventName, Events.StartDate, Events.Location;  "Sales by EmployeeM "[Event Procedure]N "[Event Procedure] @ Arial 8 h (\ SdXXLetterTPRIV ''''2 dArial@ENGLISHBRS1MF1A.EXEBRRBATOM_8500opt_8500.inicop_8500.iniMF850ini.datMF850def.datBRS1MF1A.EXEZCONFIDENTIALHArialdArialSunMonTueWedThuFriSatJanFebMarAprMayJunJulAugSepOctNovDecdEOSC .(BMFC:d27d# e%" @ Ariale24 fg3I75jg4h5m5I<Ci# " @Times New Romann7=Ij# " @Times New Romano3LVALI:Al# " @Times New Romanp4I Employee Name EventNameK`, ReportHeaderx m8vF@Zm`6Habc,, "Report Date Range z="For Registrations Between: " & format(forms![Report Date Range]![Beginnining Registration Date],"m/d/yy") & " and " & format(forms![Report Date Range]![Ending Registration Date],"m/d/yy") "Report_Date_Rangex %VtGT\-o?d28`6Ha<b c,d#e% Label20 "Sales by Employee" @Times New Romanx rsVKE+`, PageHeaderx &!K f5\zd`6Ha<bc,d# e% &Employee Name Label Employee Name  DetachedLabel &Employee_Name_Labelx krErfLv|'`d`6 a<bc,d# e% EventType Label Event Type  DetachedLabel EventType_Labelx fK:@ۆd`6a<b c,d# e% EventName Label Event Name  DetachedLabel EventName_Labelx ,p`OjPd7`6`a<b8c,d# e% StartDate Label Date  DetachedLabel StartDate_Labelx GJnLfOEb/d`6"a<b c,d# e% Location Label Location  DetachedLabel Location_Labelx \]BO6&d7`6,a<bc,d# e% *RegistrationFee Label Total Sales  DetachedLabel *RegistrationFee_Labelx  RegistrationFee Grand Total Sum .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00) >RegistrationFee_Grand_Total_Sumx Īx XJDWcvd`6HbGc, LVALLabel15 Grand Totalx y0{F]|LVALi ^0:<=5B>a)b*c2e gh6iXj0*k R?y "[Event Procedure]li=@x &LUf#Oy  U6Un~LRGa!r˖=@Registration u[tMkRR6Un~LRGa!RegistrationDate==.L$Ezz=@Report Date RangeHQWJl1'==.L$EzBeginnining Registration Datep gV/CeVb==.L$EzEnding Registration DateuB( /MƖ=@EmployeesRB>G,|Ɩ=@Event Types/ (H_&x yǖ=@Events8SCO~͖=@Sum Of Payments Query)P!6NWLw$+YRB>G,|EventType6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateQ5v8A}7J&/ (H_&x Location5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName eZgGZNz6Un~LRGa!RegistrationFeeq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Paymentsh .3NkMRB>G,|EventTypeIDdԧoo]EyµN/ (H_&x EventTypeIDqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID5ZSLn UuB( /EmployeeID9NNL<܈^/ (H_&x EmployeeIDEvent Managerᄵ;XMPS&LUf#OEventTypePO0jB6X&LUf#ORegistrationFee  SELECT DISTINCTROW [Event Types].EventType, Events.EventName, Events.StartDate, Events.Location, Employees.LastName & ", " & Employees.FirstName AS [Event Manager], Sum(Clng(Registration.RegistrationFee*(1+Registration.SalesTaxRate)*100)/100) AS RegistrationFee, Sum([Sum Of Payments Query].[Total Payments]) AS [Total Payments] FROM Employees RIGHT JOIN (([Event Types] RIGHT JOIN Events ON [Event Types].EventTypeID=Events.EventTypeID) INNER JOIN (Registration LEFT JOIN [Sum Of Payments Query] ON Registration.RegistrationID=[Sum Of Payments Query].RegistrationID) ON Events.EventID=Registration.EventID) ON Employees.EmployeeID=Events.EmployeeID WHERE (((Registration.RegistrationDate)>=forms![Report Date Range]![Beginnining Registration Date] And (Registration.RegistrationDate)<=forms![Report LVALDate Range]![Ending Registration Date])) GROUP BY [Event Types].EventType, Events.EventName, Events.StartDate, Events.Location, Employees.LastName & ", " & Employees.FirstName;  &Sales by Event TypeM "[Event Procedure]N "[Event Procedure] @ Arial 8 h (\ SdXXLetterTPRIV ''''2 dArial@ENGLISHBRS1MF1A.EXEBRRBATOM_8500opt_8500.inicop_8500.iniMF850ini.datMF850def.datBRS1MF1A.EXEZCONFIDENTIALHArialdArialSunMonTueWedThuFriSatJanFebMarAprMayJunJulAugSepOctNovDecdEOSC .(BMFC:d27d# e%" @ Ariale24 fg3I75jg4h5m5I<Ci# " @Times New Romann7=Ij# " @Times New Romano3ILVAL:Al# " @Times New Romanp4I EventType EventNameK`, ReportHeaderx a,r~SBYlB/m`6Habc,, "Report Date Range z="For Registrations Between: " & format(forms![Report Date Range]![Beginnining Registration Date],"m/d/yy") & " and " & format(forms![Report Date Range]![Ending Registration Date],"m/d/yy") "Report_Date_Rangex *cJA#d28`6Ha<b c,d#e% Label20 &Sales by Event Type" @Times New Romanx ڽ-ջL=`, PageHeaderx ڜp5A:)AAd`6Ha<bpc,d# e% EventType Label Event Type  DetachedLabel EventType_Labelx …PC׋d`6a<b c,d# e% EventName Label Event Name  DetachedLabel EventName_Labelx AN7I2;d7`6a<b8c,d# e% StartDate Label Date  DetachedLabel StartDate_Labelx 2ݗgcKX J;mmd`6a<b c,d# e% Location Label Location  DetachedLabel Location_Labelx Fk Gd)0c[d`6#a<bpc,d# e% &Event Manager Label Event Manager  DetachedLabel &Event_Manager_Labelx EPAǯd%d7`6p,a<bc,d# e% *RegistrationFee Label Total Sales  DetachedLabel *RegistrationFee_Labelx ZޱAf2 `6Hb2  Line1x ImD{K`, GroupHeader0x B;8@/KAm5I`6Ha<bpc,, EventType EventLVALTypex ᄵ;XMPSf2 `6Hb2  Line2x  >0PBEY\K`,h  Detailx Ax8m`6b c,, EventName EventNamex xeHL'9k"m`6b8c,,k StartDate StartDate& Short DateH 99/99/00;0x d#$Ns>D5ɛ$m`6b c,,k Location Locationx $ڔ4JU m`6#bpc,,k Event Manager Event Manager Event_Managerx 5 LBV4ȼm`6p,bc,,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x PO0jB6XK`, GroupFooter1x 70Fx'gm<"`6Hb2i#j%  Text12 ="Summary for " & "'EventType' = " & " " & [EventType] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"" @ Arialx $2CcOd`6Habc,d# Label13 Sumx ί~N0m<"`6p,abi#j%k ,Sum Of RegistrationFee .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00)" @ Arial ,Sum_Of_RegistrationFeex [>/RE/`, PageFooterx ݦYEE]-hE~m;`6Habc,,i# j%  Text21  =Now()& Long Datex (i5PGCm;`6abc,,i# j%k  Text22 H="Page " & [Page] & " of " & [Pages]x -.yAs ~K`,h ReportFooterx fkiEdn٭m`6p,bc,,i# j% >RegistrationFee Grand Total Sum .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00) >RegistrationFee_Grand_Total_Sumx * IIǺ0@d`6HbeLVALuGc, Label15 Grand Totalx g5JLtE} LVAL Attendees&Attendees SubformEmployees8Event Fee Schedule SubformEvent TypesEvents Events SubformFee Schedules0My Company Information"Payment Methods Payments Print Invoice Registration &Report Date Range Switchboardͬ=+x GzXReportHeadermReport_Date_RangeReport Date RangedLabel20PageHeaderdEventType_LabelEventType LabeldEventName_LabelEventName LabeldStartDate_LabelStartDate LabeldLocation_LabelLocation LabeldEvent_Manager_LabelEvent Manager Labeld RegistrationFee_LabelRegistrationFee Labelf Line1 GroupHeader0m EventTypef Line2DetailmEventNamemStartDatemLocationmEvent_ManagerEvent ManagermRegistrationFeeGroupFooter1mText12dLabel13mSum_Of_RegistrationFeeSum Of RegistrationFeePageFootermText21mText22ReportFootermRegistrationFee_Grand_Total_SumRegistrationFee Grand Total SumdLabel15Total PaymentsSTz7n+ b  u 2 222222222222222222222222222222222222222222\rɈɞ)ȴ?Ukā,ÚOOOOOOOOu@u@JPROJECTwm0,( wu@u@JPROJECTwm0,( wu@5u@<VCLBEYCGu@u@JPROJECTwm0,( wu@5u@<VCLBEYCGu@u@JPROJECTwm0,( wu@5u@<VCLBEYCGu@u@JPROJECTwm0,( wu@5u@<VCLBEYCGu@u@JPROJECTwm0,( wu@5u@:VCZKMWJKu@u@JPROJECTwm0,( w~l7u@~l7u@6@PROJECT840" ~l7u@~l7u@5@PROJECTwm<84" jl7u@~l7u@4 @dir0,(" jl7u@~l7u@3# yi_VBA_PROJECTB>:" jl7u@~l7u@2@JVRHKUFKHNLSEEMPLUFGLQOMDFNIb^Z" jl7u@~l7u@1@WTVEIIDVMOZTHEUHPWJQFIIGCQDGb^Z" jl7u@~l7u@0@WEPTEIBDBWNWAELQMWMWFCMXUGILb^Z" jl7u@~l7u@/~@SCQADWIWXNIBAENPNIAXIPKQQVMNb^Z" jl7u@~l7u@.@GRNREBFOHURREEBMRFRVEQMTOXWDb^Z" jl7u@~l7u@-7 @SSIOXHNDLIDYSDUHMVKPFVLZPKKCb^Z" jl7u@~l7u@,iiLUGXBSBRAELAAENQMNVEICRYWIPIb^Z" jl7u@~l7u@+@HZUHPICHTRLNAEQNCZWKEFKGMUOCb^Z" jl7u@~l7u@*iiAGTUQNNPJGHBTDLWTLPBCRQJYVCHb^Z" jl7u@~l7u@)@BZKDTZMKOHGEXDVWGTBXGVEFYOBIb^Z" jl7u@~l7u@(@QNBRXBKGHYIVAEEHATINDZOXJRPEb^Z" jl7u@~l7u@'iiNTFLMMCVHRVWFEPOJIEMKTBPKHY_b^Z" jl7u@~l7u@&@BVWRFG_OGWJAXDWXEUNOEUEXFQFKb^Z" jl7u@~l7u@%@RZULXIBXZBGZEEXOUJIT_XSWZVYGb^Z" jl7u@~l7u@$G @RSJCPPKEYUMRWDTXJFEIMHXDZWUKb^Z" jl7u@~l7u@#iiLRDYPHKOUQBSUDYBYUZYBAJKDGI_b^Z" jl7u@~l7u@" AcessVBADataNJF. XrR@XrR@ImExSpecs0,( wt.@t.@ @DirDataCopyB>:" t.@t.@ @ZPropDataCopyB>:" i=@<=@BlobDeltau0,( w5=@rl=@BlobDeltap0,( w=@D=@BlobDeltak0,( w%=@=@BlobDeltad0,( wWC=@z=@BlobDeltaZ0,( w`=@3=@BlobDeltaU0,( wiޖ=@ߖ=@BlobDeltaP0,( wݖ=@Eޖ=@BlobDeltaK0,( wpܖ=@+ܖ=@BlobDeltaF0,( wۖ=@1ܖ=@BlobDeltaA0,( w@ږ=@ږ=@BlobDelta<0,( wFLVALиFV  ixME (S<S<S<<N0{EB5B2874-1184-4B7A-8AB7-56CD2D0A9A6E}x $@ . > P \h@%@@G "(HP"X`h x "F @` hp x"F x@  "T(H    08@ Pxp "($& CompanyName *B@,_4.k0o(@0 "2B@46|x0p :!<A@806XoP@@ "($&;Enter attendee information before registering for an event.A@8d D F H J *B@B Registration *B@LkN|@ :!<A@8Nho`RP "2!T!V!X<Register attendee for an event before viewing payments form.A@8d D F H J *B@BPaymentsY[Payments]![RegistrationID] = Forms![Attendees]![Attendees Subform].form![RegistrationID] *B@Lk@Z8|0R( :!<A@8Zo^ "2!T!V!XJEnter attendee and registration information before previewing the invoice.A@8dx D F H J *B@BInvoice b[RegistrationID]= d"f"2!T"h *B@`kj|^ : xMR :!<A@8RkjoAttribute VB_Name = "Form_endees" Bas0{EB5B2874-1184-4B7A-8AB7-56CD2D0A9A6E} |GlobalSpacFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT  `ActivG>On Error {A_~C %s1f].Requery8ExiztK:A  rrMsgBox.DescriVResu8Register_C_kS8d` +"En@ att in%Dabee Br"ing  an ev}.jBlvDoMenuItem aBcAbBar,RecordsSave, Ver703Open "=rB(LR7"78 848Paym$s98k&8T U"(etCloneCount@0l<< 9 =view Exit: 6=/@MsgBox7.DescriB3pResundC21q_DblC"    028p  " > (" 08@ HXh p 0   ("0&8`p " xp !GotoNew "$&f-9 D J *B@BALko@4Double-click this field to add an entry to the list.A@8- 'o0 ]  "$& "(dd "' )k Event Types GotoNew *B@L "B@4 G  )jX|PH :!<A@80o(84Double-click this field to add an entry to the list.A@8 'o] "$& "(dd "' )kh Employees GotoNew *B@L "B@4 G  )j| :!<A@8o0 "!&View Fee Schedule "( "(&View Attendees "(dX "( "(&View Fee Schedule "(koAttribute VB_Name = "Form_Events" Bas0{54103994-3968-49E7-9B0A-06C964EE4EC0} |@GlobalSpacFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT  0Un Ck)ExitR1: aibrrY$P<.Descriv@Ku b8oyeS$П*@ V l # 9 OhB@B@`@PROJECT840" B@B@_@PROJECTwm<84" B@B@^ @dir0,(" B@B@]$иF_VBA_PROJECTB>:" B@B@\ @OIBXFXJYUIOSRDCKDCIVDXVCWOYEb^Z" B@B@[@ECXEJTDBGILXGEATDNNLKOYOGUAFb^Z" B@B@Z@IPBKTUFHOOEVCEDXBYKTCGZOUDBFb^Z" B@B@Y@TKKQFKDERCORSDEKTPVVNTSTGANCb^Z" B@B@X:@CAKZTFIGXRMHFEBDMVVCBMJSDICFb^Z" B@B@Ws@DBQXRWIXQEAMYDCHLNXFDLTAPYJNb^Z" B@B@VиFMXGXWLNEKSUCODYIWNKJDOKOUCILb^Z" B@B@U@TOTSUACHPLPEVDFLHEAGHIGHUSPLb^Z" B@B@T{иFYESJUCJYYLBWUDZCNZUNNMKRCBLEb^Z" B@B@S@VEKNYIHSPNQAUDDPHGVFBHVIPYKNb^Z" B@B@R@JAYNJWEFXEYXFEPLUJXABWXVSUIEb^Z" B@B@QиFUBYDRNBSBJERQDTJAYKBDAUQKMLIb^Z" B@B@P@REYSEDMAFBYVEERCAYANCAVDEUELb^Z" B@B@O@WLUWLWHYDVVNHEWEAXGMBDITQBMFb^Z" B@B@NC @NGFRYIMFCYGFAEAPDXUVLFRLLMUGb^Z" B&B@B@MиFMWHILTKQFFQQPDIOXSAGLNFCBLYJb^Z" B&B@B@L AcessVBADataNJF.  LVALV] OxME(S<S<S<<N0{0C801977-B010-4F6D-8B04-2042F4F7016C} tP zi| ~0i| i| i| `i| ] %@! " @H PXhp" x" " " " 0H Xxpv` Registration 0B@Rx8|0v( @!BA@>xoPA@topA@toX0A@to@ J L N P 0B@HenPayments 0B@Ro J L N P 0B@HPayments 0B@RoxAttribute VB_Name = "Form_endee@s SubfD"D Bas0{0C801977-B010-4F6D-8B04-2042F4F@7016C} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  Exit: 6=/@MsgBox7.DescriB3pResundC21q_DblCx" *8@ HP X`px "    6 0 PX `hx xp Attendees$GOpen the Payments form using the Payments button on the Attendees form.A@8nx'vkho``0P B@4@68|00( :!<A@8c6o Z ) d"f"2!T" )| :!<A@8o4Double-click this field to add an entry to the list.A@8 'o8( "$& "% d"f"  d"f" )'kk| :!<A@8op]  "$& "(dd@ "' )U{kPayment Methods GotoNew *B@L "B@4 G  )j| :!<A@8oxpAttribute VB_Name = "Form_Paymen ts" Bas0{C918595E-861A-4E7F-BF2E-27F11D2FC0C2} |Global!SpacFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  0Me.RequerByIExitK :σ O rrB.DescriBhResu@ 3BePeInsxertjT8 Me![fe]Amount[Js]![hBw]. Due]Q"R{) )T*MethodID_ \InList(New!a`Sng, 5po/Coc"Dou- clk\is field to add an ry\l [ 0= ac!@FCopntinA[AfterUpdV]>f|Null(;D$]M} .Column(2)D,wCardholdersALFirst#&$ " & RLaiC|#T??V#V8 hWmDblCAO"c%Dim lnga_Long!z!(? 0b1X6`?vT\_o* pD?*apIFj_& * S5u@u@<1!VCLBEYCGOLJKPDBSWJBW_LNQVBKDb^Z"  S5u@u@=@MWTYFAGFBKGMHEEPOMBQNOGBNNJLb^Z" ! LVAL1 DK@xME (S<S<S<<N0{16921BF0-A0A5-4AE4-B5E2-71D259A627D9} @ %H@  " ("0 8X hxp (1-5oP@  Print Invoice *B@Bo BAttribute VB_Name = "Form_Print Invoice"D Bas0{16921BF0-A0A5-4AE4-B5E2-71D259A@627D9} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  H"    00@ `h px" >"  0@H " PX` hx  , (0 8@PX" `>h""    0@4H   xp "This event is fully booked.A@8Rk(o @ Attendees$OOpen the Registration form using the Registration button on the Attendees form.A@8004'vko "B@4| :!<A@8o0 Attendees$ !B@4ck B@4d to a d"f"2!T!V!X RegistrationID *B@,( d"f"2!T"h *B@kk6| S5u@u@>@WOWIYIFOSDVXRDVAGGSGMGABIMABb^Z" + S @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ UUUUUUUU U U  U  U  U U UUUUUUUUUUU U!U#U$U%U&U(U)U *U!+U"-U#.U$/U%0U&2U'3U(4U)5U*7U+8U,9U-:U.<U/=U0>U1?U2AU3BU4CU5DoFoGoHoIoKoLoMoNoPo Qo Ro So Uo VoWoXoZo[o\o]odoeofogoiojokolomonopoqo ro!so"uo#vo$wo%xo&o'o(o)o*o+o,o-o.o/o0o1o2o3     LMNOPQRSTUVWXYZ[\] ^!_"`#jS@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@UUUUUUU U U  U U  UUUUU#U(U-U#2U'7U+<U/AU3FoKoPo Uo Zo  doiojokopouo#o'o)o*o+o,UL  U  U  U U_"`#MNOPQRSTUVWXYZ[\] ^!UUUo-U U!Uo.#$U#%U#&U#o/()U (*U!(+U"(o0-.U$-/U%-0U&-o123U(24U)25U*2o278U,79U-7:U.7o3<=U0<>U1<?U2<ABU4ACU5ADoAFGoFHoFIoFKLoKMoKNoKPQo PRo PSo PUVoUWoUXoUZ[oZ\oZ]oZdeodfodgodklokmoknokpqo pro!pso"p uvo$uwo%uxo&u o(FS@@@@ @@@    @@@  @ @@@  @ @@M`OLJikUMokmd`UidofkU OJmJJMMQkkfJUQkU OJmJLJkQkU Sdi`kUY`QukfQMk `dOo^QkU`kvkJMMQkkkmdiJUQ+iddmUfidfOJmJUiQfdimkUkMiYfmkUqLJU`kvkJMMQkkkmdiJUQ+kMiJmMWU6U8U86o88o 8:o 8<o:U<U>U#@U'BU+DU/FU3HoOYiOJmJUOYiOJmJMdfv fidfOJmJUfidfOJmJMdfv 6o8o:o<o#OYiOJmJofidfOJmJo6o'OYiOJmJo+OYiOJmJMdfvo,fidfOJmJo)fidfOJmJMdfvo*JMQkkqLJOJmJqLJfid[QMmU 6U  OYiOJmJU L^dLU fid[QMm#fid[QMms`"qLJU+qLJ+fid[QMm MJ\xmSYUui`WSQLO`qqML`[kOYMSOLhuisYuhQJ`vOMW^buSO^mJfv[bOYi!QMuQ[mOLUY^uUQJmObb^\dvdUoJSYfL\moSWddQqMQOuLv\mMUxdoOLS[Jvb[sQSuQvuSQf^o[uJLsuqkoYQ`sWY^m\hSShhfOYdukJU^bSML^v[`uUus^bQ\koMdOvYsb\[Od\doMY^bUSivY`SMvUSJQJfOuoq^Si^^`oUdYLuSu[voYdkiOM\OMYqOuqMsdvQiQvkQO`JSLvqQQiMJvJbMJqOQoQ^m\\hS\OQiMdikOQ\mfqqbmkmUJbMmdmkoJMWf^fQqOS^WQJUWYUWokf^oLvOibLkL[QihOm[Jv\LOJoh\`^YqQ\bvYWkfbhJoOOfWUqSLWqYfv\bs^os^sWvOqqbWQsQJuU`LOYmhL`SvQk[oM[vv^LsoOxMbxobb`\iML^QL^dLUL^dLOQ^mJo-fidfOJmJUmvfQYbSdUL^dLUL^dLOQ^mJo.fidfOJmJUmvfQYbSdU#L^dLU#L^dLOQ^mJo/#fidfOJmJU#mvfQYbSdU(L^dLU (L^dLOQ^mJo0(fidfOJmJU"(mvfQYbSdU!-L^dLU$-L^dLOQ^mJo1-fidfOJmJU&-mvfQYbSdU%2L^dLU(2L^dLOQ^mJo22fidfOJmJU*2mvfQYbSdU)7L^dLU,7L^dLOQ^mJo37fidfOJmJU.7mvfQYbSdU-<L^dLU0<L^dLOQ^mJ<fidfOJmJU2<mvfQYbSdU1AL^dLU4AL^dLOQ^mJAfidfOJmJoAmvfQYbSdU5FL^dLoFL^dLOQ^mJFfidfOJmJoFmvfQYbSdoKL^dLoKL^dLOQ^mJKfidfOJmJoKmvfQYbSdoPL^dLo PL^dLOQ^mJPfidfOJmJo PmvfQYbSdo UL^dLoUL^dLOQ^mJUfidfOJmJoUmvfQYbSdoZL^dLoZL^dLOQ^mJZfidfOJmJoZmvfQYbSdodL^dLodL^dLOQ^mJdfidfOJmJodmvfQYbSdokL^dLokL^dLOQ^mJkfidfOJmJokmvfQYbSdopL^dLo pL^dLOQ^mJ pfidfOJmJo"pmvfQYbSdo!uL^dLo$uL^dLOQ^mJ ufidfOJmJo&umvfQYbSdo%fidfOJmJo(o(o(o(>YN Y Y Y  Y Y Y Y t Filter FlagsIdNamePosition SelectedObjectIDTypeeYIdv1auCustom ^TablesC"w V RY N  Y Y Y  Y Y Y Y g FlagsGroupCategoryIDIdName"Object Type GroupObjectIDPositionYGuayIYYGroupCategoryIDIdv1@ / yL|O  wCustom Group 162.*  w w w w w w w  @  @  YEINEEEY Y Y Y  Y Y Y g FlagsGroupIDIconIdNameObjectIDPositionjtsGuDYYGroupIDIdv1GEyLk> ] 0  | O " n A  ` 3   R % qDc6 U(tGf9 I oH oG oF  oE  oD oC oB oA o@ o?? o>; o=/ o< o; o:B o9A o8@ o7? o69 o57 o46 o35  o24  o13  o08  o/2  o.1 o-0 o,/ o+. o*- o)+ o(* o'( o&' o% o$ o# o" o o  o  o  o  o  o o o o o  o  o  o oW oN o B o = o 6 o 1  o )  o$  o  o  o o o o o o  @ @ @ @ @ @ @ @      6789:;<=>?"#$%&'()*+,-./012345@A BC!D  @ @ @ @ @ @ @ @       "#$% &!'"(#)$*%+&,'-(.)/*0+1,2-3.4/5061728394:5;6<7=8>9?:;<B=C>D?E@FAGBHCIDRY5ata NY  Y Y IdNameTypedv 'LVAL70 :!<A@86o 4Double-click this field to add an entry to the list.A@8 'ohX] "$& "(dd( "' )k Employees GotoNew *B@L "B@4 G  )j| :!<A@8poh4Double-click this field to add an entry to the list.A@8 'o "$&R]R "B@4R )R]R )R]Rko]8 "$& "(ddp "' ]R )R]RkHEvents GotoNew *B@L "B@4 G  )j "B@4 | :!<A@8 oP4Double-click this field to add an entry to the list.A@8 'oH % )o ]p "$& "(dd "' )k Fee Schedules GotoNew *B@L "B@4 G  )jH|@8 :!<A@8 oAttribute VB_Name = "Form_Registration" " Bas0{23DC590A-40E2-4BCA-ACFA-9A6589A1 DFBC} |GlobalSpacIFalse dCreatablTru Pre declaId"Expose_TemplateDerivCustomizD$Op Codmp@ DT   \ DoCmd.6Controld "KIDB]  FindRea mao?'a eMi 4FB-yBl]B BeBEoye@V_@vInLa(Newa{S!ng, Mpo@}"Dou4-c k yield to ad d an jry;vl t = ac!]a6inᶇ!(DblCґw05Dim lngaLongs7baN(}].Text!NE! aK="'I aLXAS " 0s", %,ialo;"Goto>d v <7] "N1/ _u՟/ _k/t$FQk_0QF EpID/0! /0n/0c/0/0/0r/0x0F Updd]1%x***kk11!;'%U]J*q 9< i@PY NY  Y dY PaymentMethodIDPaymentMethodCreditCard{h x YPrimaryKeyv1@ Cash Debit CardCredit CardCheque  Y \N    Y Y Y Y  Y  < Y  dY  Y  <Y  PaymentIDRegistrationIDPaymentAmountPaymentDate CreditCardNumberCardholdersName"CreditCardExpDate:CreditCardAuthorizationNumberPaymentMethodIDVYYYYL{FA0A8BD4-9CED-460C-B39E-14E02F757E45}PaymentMethodIDPrimaryKeyRegistrationIDv1 Ne3 p@@&&&& `@@&&&& `S@@&&&& p@@&&&& p @&&&& `S @-@34455645Elizabeth Brown0112GA0& ` @&&&& @KL@&&&& @KL@&&&&  @KL@`@34455644Hari Kumar0111B<0&  @   @    @   , Y N  Y Y Y Y  Y  Y <Y Y  Y $RegistrationIDAttendeeIDEmployeeIDEventID RegistrationDate&PurchaseOrderNumberSalesTaxRateFeeScheduleIDRegistrationFeeridRefnCfApeEnrieEle@C@DYY/Y?YYYYYY.rIL{9B9C667B-FC98-41F1-BDE3-038162828582}L{E1326185-AAFD-4728-8D2C-9321CDC0F147}AttendeeIDEmployeeIDEventIDFeeScheduleIDPrimaryKey RegistrationDate v1b  ^(P x B @ `.. @`.. @p.. @@KL.. @ D.. @@KL.. @@KL.. @`S.. `@ `.. `@@KL.. `@p.. @@ `.. @@`S.. @@p..  @ @       @ @       @ @       @ @         @ @      j @ @@@@```䴀䴀䴀䴀 䴠 䴠 䴠 䴠 Uي:7Ն$mWA;–=@–=@{FA0A8BD4-9CED-460C-B39E-14E02F757E45}knnnnnnnnnnl :!–=@!–=@{E97AEEB8-19B0-47EE-9E82-2A30E8FEE3AD}knnnnnnnnnnl 9–=@–=@{E4EB61BE-00BA-4AC5-B640-3BEC84E18E2D}knnnnnnnnnnl 8j–=@j–=@{E1326185-AAFD-4728-8D2C-9321CDC0F147}knnnnnnnnnnl 7–=@–=@{DEC1D036-D064-4161-830A-90BB2B938C00}knnnnnnnnnnl 6!–=@!–=@{D9D70FE7-B18D-434A-B153-5DDB1CC488EA}knnnnnnnnnnl 5!–=@!–=@{A6EB293B-F895-4132-A877-46D3403552F8}knnnnnnnnnnl 4–=@–=@{9B9C667B-FC98-41F1-BDE3-038162828582}knnnnnnnnnnl 3D%Ö=@D%Ö=@{1E2E1ABA-2500-4C78-AA27-6848050604D0}knnnnnnnnnnl (}rR@(}rR@ MSysNavPaneGroupToObjectsk4MR2KeepLocal  TTTTTTTTR @rR@rR@ MSysNavPaneGroupCategoriesk4MR2KeepLocal  TVVVVVVVT @/E=@i=@~sq_rSales by Event Typek4MR2KeepLocal TRRRRRRRP @,%=@%=@~sq_rAttendee Listingk4MR2KeepLocal TLLLLLLLJ @){wۖ=@{wۖ=@~sq_fMy Company Informationk4MR2KeepLocal TXXXXXXXV @'Ӎؖ=@Ӎؖ=@~sq_fEvents Subformk4MR2KeepLocal THHHHHHHF @%۬Ӗ=@۬Ӗ=@~sq_fEvent Typesk4MR2KeepLocal TBBBBBBB@ @"hݖ=@hݖ=@~sq_cPayments~sq_cPaymentMethodIDk4MR2KeepLocal Tdddddddb @!Ֆ=@!Ֆ=@~sq_cEvents~sq_cEvents Subformk4MR2KeepLocal T^^^^^^^\ @Ζ=@Ζ=@~sq_cAttendees~sq_cAttendees Subformk4MR2KeepLocal Tjjjjjjjh @9=@9=@Report Date Rangek~@PPPDDDDDDDB @=@=@Events Subformk8@JJJ>>>>>>>< @ RY=@ Gj@AccessLayoutk4MR2KeepLocal T.@zz:::::::8 @­=@.˖=@Venuesk.@:::......., @2z=@q4=@Total Registrations by Attendeek@|@xll```````^ @1z=@͖=@Sum Of Payments Queryk@|@dXXLLLLLLLJ @uYNCTRN Y dY Y Y VenueNameCapacityRaisedStageBeverageServicesaoaYPrimaryKeyv1~Northern Room7Canada RoomBanff Room #Algonquin Room @J^UdbhoYbidd`LJbSSidd`MJbJOJidd`bdimWQibidd`'GDataQQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k n n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k n n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k n k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k LVALʾ Create table in Design viewCreate query in Design viewdeeCreate form in Design viewCreate report in Design viewCreate data access page in Design viewGlobal Code \^3LVALЄCMR2 GUIDNameMap. T_4_Hͱ   U/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Queryqz!E%#6Un~LRGa!RegistrationID eZgGZNz6Un~LRGa!RegistrationFee6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Payments[~XI&>u~6Un~LRGa!AttendeeID/(G_ƍT8SCO~RegistrationID(_MjMR2 GUIDNameMap. T_4_Hͱ   U/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Queryqz!E%#6Un~LRGa!RegistrationID eZgGZNz6Un~LRGa!RegistrationFee6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Payments[~XI&>u~6Un~LRGa!AttendeeID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID0֋3@A.T_4_HͱSale Amount[.A,LVAT_4_HͱTotal Payments MR2 GUIDNameMap   KKMг.ro  UĞ\wA.:O>i͖=@AttendeesT_4_Hͱoϖ=@Attendees Subform/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Queryqz!E%#6Un~LRGa!RegistrationID eZgGZNz6Un~LRGa!RegistrationFee6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Payments[~XI&>u~6Un~LRGa!AttendeeID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID+RH%\9Ğ\wA.:O>AttendeeIDm ЄG,ʠĞ\wA.:O>CompanyNameE]F&Ğ\wA.:O>Addresspn7@}5Ğ\wA.:O>City ?FwOĞ\wA.:O>Provinceu6_BNaaDĞ\wA.:O>PostalCode ,B[zĞ\wA.:O>AttendeeFirstName~}xVAbpĞ\wA.:O>AttendeeLastNameҥ\_A ۱*Ğ\wA.:O>Title1wLچ8!lĞ\wA.:O>PhoneNumbeŗG+:M[8f9dĞ\wA.:O>FaxNumbersO^S2BQOĞ\wA.:O>Notes MR2( ReplicateProject MR20 Title AuthorCompanyH. &Access Conference 4 DCFLVAL t MR2 GUIDNameMapZ rC-Í76 . U MR2 GUIDNameMap  QaY+F oP  U/ (H_&x yǖ=@EventsZCBP ]*Ӗ=@Y Event Fee Schedule Subform\B/懞NҖ=@Y Fee SchedulesM]F\p\B/懞EventID(_Mjcb-/ (H_&x EventID6{N4)/ (H_&x EventName/U:9u&JVp / (H_&x EventDescriptionQ5v8A}7J&/ (H_&x Locationdԧoo]EyµN/ (H_&x EventTypeIDRB>G,|Ɩ=@Event Types)P!6NWLw$+YRB>,9L<܈^/ (H_&x EmployeeIDuB( /MƖ=@Employees5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName81RwD]x/ (H_&x Status7[)ANݎ/ (H_&x StartDateӧ\PWGJ/ (H_&x EndDate`[EçNK/ (H_&x StartTime/F3A/ (H_&x EndTime%" QJ~z/ (H_&x AvailableSpaces6vIVQaY+F oPAvailableSpacesφgMIIXZQaY+F oPEvents SubformglW>Ck:řo֖=@>E0Events SubformĞ\wA.:O>i͖=@Attendees6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Query\ LE`V6Un~LRGa!EventID[~XI&>u~6Un~LRGa!AttendeeID~}xVAbpĞ\wA.:O>AttendeeLastName ,B[zĞ\wA.:O>AttendeeFirstNamem ЄG,ʠĞ\wA.:O>CompanyName eZgGZNz6Un~LRGa!RegistrationFee)N39H8SCO~Total Paymentsqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID+RH%\9Ğ\wA.:O>AttendeeID MR2 GUIDNameMap }T)@HjrUe>  URB>G,|Ɩ=@Event Typesh .3NkMRB>G,|EventTypeID)P!6NWLw$+YRB>G,|EventType MR2 GUIDNameMap ZCBP  U\B/懞NҖ=@Fee Schedules_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞Fee MR2 GUIDNameMap ?䴍&zJ~I  UuB( /MƖ=@Employees5ZSLn UuB( /EmployeeID5LBL=u~nuB( /FirstName5۹VGzRuB( /LastNameJ;W) L  uB( /TitlelvYNrx-uB( /WorkPhone g.F<]wzuB( /Extension BLVAL zZMR2 GUIDNameMap m:D6`~  UkXHAՏ6'd̖=@Payments/(G_ƍTkXHAՏ6'RegistrationID KKMг.roWі=@AttendeesjN<ʅ KKMг.roAttendees SubformPaymentMethodID,,eG<7<ɖ=@Payment MethodsDU#t,,eG<7PaymentMethodPaymentDatePaymentAmountCardholdersNameCreditCardNumberCreditCardExpDateCreditCardAuthorizationNumber MR2 GUIDNameMapl Ҷ'oGhņH @ U,,eG<7<ɖ=@Payment Methods^41HX5,,eG<7PaymentMethodIDDU#t,,eG<7PaymentMethod">8>x&T,,G<7CreditCard MR2 GUIDNameMapt lgJʠ$2P H UX57L~ԠEW9ۖ=@My Company Informations?U'M:ɨh@=X57L~ԠECompanyNameoS9@tc!X57L~ԠEAddress1q1yJDJ3X57L~ԠECityM,]QAXV`X57L~ԠEProvinceR[#5N^X57L~ԠEPostalCode_L $X57L~ԠECountryӧﾙ7L X57L~ԠEPhoneNumber.7 P@ -ۇ<X57L~ԠEFaxNumber*G6)X57L~ԠESalesTaxRatea"COḫX57L~ԠEDefaultPaymentTerms+ -ZG{X57L~ԠEDefaultInvoiceDescription MR2 GUIDNameMap AF LPBY  U\B/懞NҖ=@Fee SchedulessD<F-q "\B/懞FeeScheduleIDM]F\p\B/懞EventID/ (H_&x yǖ=@Events6{N4)/ (H_&x EventName_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞Fee MR2 GUIDNameMap glW>Ck:ř  UĞ\wA.:O>i͖=@Attendees6Un~LRGa!r˖=@Registration8SCO~͖=@Sum Of Payments Query\ LE`V6Un~LRGa!EventID[~XI&>u~6Un~LRGa!AttendeeID~}xVAbpĞ\wA.:O>AttendeeLastName ,B[zĞ\wA.:O>AttendeeFirstNamem ЄG,ʠĞ\wA.:O>CompanyName eZgGZNz6Un~LRGa!RegistrationFee)N39H8SCO~Total Paymentsqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID+RH%\9Ğ\wA.:O>AttendeeID P.I1%k#Attendee Name LVALLMR2 GUIDNameMap h B+DщRd \ UĞ\wA.:O>i͖=@AttendeesE/eeIq4=@Total Registrations by AttendeeT<"NE_Y&E/eeITotal Registrations+RH%\9Ğ\wA.:O>AttendeeID[~XI&>u~E/eeIAttendeeID~}xVAbpAttendeeLastName ,B[zAttendeeFirstNamem ЄG,ʠCompanyNamepn7@}5City ?FwOProvince1wLچ8!lPhoneNumbeŗG+:M[8f9dFaxNumber MR2 GUIDNameMapZ ==.L$Ez6 . U MR2 GUIDNameMap  $]MSJ  U6Un~LRGa!r˖=@Registration[~XI&>u~6Un~LRGa!AttendeeID KKMг.roWі=@AttendeesjĄwUB2oI KKMг.roAttendeeIDĞ\wA.:O>i͖=@Attendees+RH%\9Ğ\wA.:O>AttendeeIDRegistrationIDRegistrationDateEmployeeIDuB( /MƖ=@Employees5ZSLn UuB( /EmployeeID5۹VGzRuB( /LastName5LBL=u~nuB( /FirstNamePurchaseOrderNumberEventID/ (H_&x yǖ=@Events(_Mjcb-/ (H_&x EventID6{N4)/ (H_&x EventName%" QJ~z/ (H_&x AvailableSpacesFeeScheduleID\B/懞NҖ=@Fee SchedulesM]F\p\B/懞EventIDRegistrationsD<F-q "\B/懞FeeScheduleID_ͽI \B/懞FeeDescription>#ZFHǻs8sg\B/懞FeeRegistrationFee(W:1A~4$]MSJEventIDSalesTaxRate&pyUG]d$]MSJSalesTaxRate!| D!Jg$]MSJRegistrationFeeW\RfEZ}-D@$]MSJSales Tax #I e$]MSJRegistrationIDYN/Bn$]MSJTotal ChargesC L@ZYW$]MSJTotal Paid KvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[H0k / k / b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp / k . k . b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp . k - k - b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp - k , k , b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp , k + k + b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp + k * k * b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp * k ) k ) b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ) k ( k ( b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ( k ' k ' b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ' k & k & b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp & k % k % b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp % k $ k $ b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp $ k # k # b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp # k " k " b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp " k ! k ! b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ! k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k  k  b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp  k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp LVALMR2 GUIDNameMap"  tuELX  UĞ\wA.:O>i͖=@AttendeesuB( /MƖ=@Employees/ (H_&x yǖ=@Events6Un~LRGa!r˖=@Registration(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID5ZSLn UuB( /EmployeeIDs5K~u=G#6Un~LRGa!EmployeeID+RH%\9Ğ\wA.:O>AttendeeID[~XI&>u~6Un~LRGa!AttendeeIDrC-Í7ߖ=@Print Invoiceq~@RNrC-Í7Invoice Date[Attendees].[AttendeeID]qz!E%#RegistrationID u[tMkRRRegistrationDateNC_PurchaseOrderNumberʼn0"IIrC-Í7Payment Terms ,B[zAttendeeFirstName~}xVAbpAttendeeLastNamem ЄG,ʠCompanyNameE]F&Addresspn7@}5City ?FwOProvinceu6_BNaaDPostalCode6{N4)EventNameQ5v8A}7J&Location7[)ANݎStartDateӧ\PWGJEndDate`[EçNKStartTime/F3AEndTime eZgGZNzRegistrationFeeq|[N61fSalesTaxRateK~GJUӂKtuELXRegistrationFee"'gHML tuELXSales Taxá)Jm%NutuELXRegistrationIDtuELX=@Invoicel Lz"tuELXTotal#i~o:IhtuELXTotal Payments⛁ԇH_9rC-Í7Invoice Description LVALMR2 GUIDNameMap 炃+HG   U6Un~LRGa!r˖=@Registration u[tMkRR6Un~LRGa!RegistrationDate==.L$Ezz=@Report Date RangeHQWJl1'==.L$EzBeginnining Registration Datep gV/CeVb==.L$EzEnding Registration DateRB>G,|Ɩ=@Event Types/ (H_&x yǖ=@EventsuB( /MƖ=@Employees8SCO~͖=@Sum Of Payments Query5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName)P!6NWLw$+YRB>G,|EventType6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateQ5v8A}7J&/ (H_&x Location eZgGZNz6Un~LRGa!RegistrationFeeq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Paymentsh .3NkMRB>G,|EventTypeIDdԧoo]EyµN/ (H_&x EventTypeIDqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID5ZSLn UuB( /EmployeeIDs5K~u=G#6Un~LRGa!EmployeeID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventIDEmployee Name[I }炃+HG Employee NameMM\6炃+HG RegistrationFee LVALMR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLQ <       uY4E?r Ⱥf U6Un~LRGa!r˖=@Registration\ LE`V6Un~LRGa!EventIDqz!E%#6Un~LRGa!RegistrationID MR2 GUIDNameMap &LUf#O  U6Un~LRGa!r˖=@Registration u[tMkRR6Un~LRGa!RegistrationDate==.L$Ezz=@Report Date RangeHQWJl1'==.L$EzBeginnining Registration Datep gV/CeVb==.L$EzEnding Registration DateuB( /MƖ=@EmployeesRB>G,|Ɩ=@Event Types/ (H_&x yǖ=@Events8SCO~͖=@Sum Of Payments Query)P!6NWLw$+YRB>G,|EventType6{N4)/ (H_&x EventName7[)ANݎ/ (H_&x StartDateQ5v8A}7J&/ (H_&x Location5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName eZgGZNz6Un~LRGa!RegistrationFeeq|[N61f6Un~LRGa!SalesTaxRate)N39H8SCO~Total Paymentsh .3NkMRB>G,|EventTypeIDdԧoo]EyµN/ (H_&x EventTypeIDqz!E%#6Un~LRGa!RegistrationID/(G_ƍT8SCO~RegistrationID(_Mjcb-/ (H_&x EventID\ LE`V6Un~LRGa!EventID5ZSLn UuB( /EmployeeID9NNL<܈^/ (H_&x EmployeeIDEvent Managerᄵ;XMPS&LUf#OEventTypePO0jB6X&LUf#ORegistrationFee JvcO<)   x e R > +    z g T @-}iVC/ lXE2 n[k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k %k %b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp %k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k !k !b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp !k #k #b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp #k 'k 'b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 'k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k Tb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k Sk Sb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp Sk Nk Nb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp Nk Gk Gb7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp Gk ?k ?b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ?k ;k ;b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ;k 6k 6b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 6k /k /b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp /k 0k 0b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp xLVAL  ά(h&xRegistrationά(h&xPaymentsά(h&xRegistrationLVALMR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControl$UnicodeCompressionIMEModeIMESentenceModeInputMaskValidationRuleValidationText FilterOrderByNameMapGUIDDescription FormatSmartTagsDefaultValue   L D UĞ\wA.:O>Ė=@Attendees݋OcoĞ\wA.:O>AttendeeIDW!RN8>'fY&Ğ\wA.:O>AttendeeFirstName%Gl}h^Ğ\wA.:O>AttendeeLastNameCCIxBĞ\wA.:O>TitleP`/QȳEý;mԡĞ\wA.:O>CompanyName/M!TJ*ў5Ğ\wA.:O>AddressncBz.$Ğ\wA.:O>CityʻQKr`=0eĞ\wA.:O>Province9y}Nĥ. Ğ\wA.:O>PostalCodeVy0p@M\QĞ\wA.:O>PhoneNumbertҬ>FTE Ğ\wA.:O>FaxNumber2F.݈;\KWNsϺĞ\wA.:O>Notes  Ğ\wA.:O>("AttendeeFirstName   First Name     m        ,B[z& AttendeeLastName   Last Name     m       ~}xVAbp Title       m       ҥ\_A ۱*CompanyName    Company Name     m       m ЄG,ʠAddress   b    m       E]F&City       m       pn7@}5Province   Province     m        ?FwOPostalCode   Postal Code >L0L\ 0L0     m       u6_BNaaDPhoneNumber    Phone Number     m       1wLچ8!lFaxNumber   Fax Number     m       ̧G+:M[8f9d| Notes            sO^S2BQO~AttendeeID AttendeeID     +RH%\9xLVAL MR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenValidationRuleValidationText FilterOrderByNameMapGUIDDescription FormatSmartTagsInputMaskDefaultValueDisplayControlIMEModeIMESentenceMode$UnicodeCompression1    URB>G,|TŖ=@Event Types셢 @e֑RB>G,|EventTypeID,.e[fA%S4 RB>G,|EventType  RB>G,|EventType   Event Type    m    )P!6NWLw$+Y}EventTypeID" Event Type ID    h .3NkMMR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControl$UnicodeCompressionIMEModeIMESentenceModeInputMaskValidationRuleValidationText FilterOrderByNameMapGUIDDescription FormatSmartTagsDefaultValue     UuB( /;Ė=@Employees^DHuB( /EmployeeID~BuG,|Ɩ=@Event Types)P!6NWLw$+YRB>G,|EventTypeJOٖD:?J#/ (H_&x EventTypeID!iʤOj+*/ (H_&x Status54_H#'V/ (H_&x LocationEkhHOj#Q/ (H_&x StartDate:ULw:*2/ (H_&x EndDateɥAiIr䁁 / (H_&x StartTimeJ$&KnXÀ`/ (H_&x EndTimeZt*OQAUy/ (H_&x RequiredStaffingSăFkM= V/ (H_&x ConfirmedI" ?LaDh/ (H_&x AvailableSpaces `zuvyEǬV/ (H_&x EventDescription)tK"jz~/ (H_&x NotesuB( /MƖ=@Employees)eD715b/ (H_&x EmployeeID5۹VGzRuB( /LastName5LBL=u~nuB( /FirstName  / (H_&x EventName   Event Name     m     6{N4)EventTypeID " Event Type ID  o Table/Query SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType;       0;2880  2880twip  r   ! dԧoo]EyµN Status       m     81RwD]xLocation       m     Q5v8A}7J&StartDate  Start Date Short Date 99/99/00;0      7[)ANݎEndDate  End Date Short Date 99/99/00;0      ӧ\PWGJStartTime  Start Time Medium Time  09:00\ >LL;0      `[EçNKEndTime  End Time Medium Time  09:00\ >LL;0      /F3A& RequiredStaffing * "Required Staffing    !  m (ZOAx&q~ConfirmJ LVALZ ed   Yes/No     m ~ %JHB#D$AvailableSpaces (  Available Spaces    !  m %" QJ~z& EventDescription  * "Event Description        /U:9u&JVp | Notes          3~NaLEmployeeID  Employee ID  o Table/Query SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];       0;2880  2880twip     ! 9NNL<܈^kEventID Event ID    (_Mjcb-\LVALlMR2OrientationOrderByOnDefaultViewRequiredCaptionDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListColumnWidthColumnOrderColumnHiddenAllowZeroLength FormatDecimalPlacesValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsInputMaskDefaultValueIMEModeIMESentenceMode$UnicodeCompression     U\B/懞VƖ=@Fee Schedules\Z @,߃\B/懞FeeScheduleID/ (H_&x yǖ=@Events6{N4)/ (H_&x EventNameu+CK\B/懞EventID|9GV\B/懞FeeDescription an\woGGqT\B/懞Fee  \B/懞EventID  Event ID o Table/Query SELECT DISTINCTROW Events.* FROM Events ORDER BY Events.EventName;      0;2880   2880twip  $    M]F\p¾"FeeDescription  & Fee Description    m    ! _ͽI  Fee 0 ($#,##0.00;-$#,##0.00     >#ZFHǻs8sg FeeScheduleID& Fee Schedule ID    sD<F-q "5vcO<)   x e R > +  {  g T A -}jVC0 ;k ;b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ;k :k :b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp :k 9k 9b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 9k 8k 8b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 8k 7k 7b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 7k 6k 6b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 6k 5k 5b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 5k 4k 4b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 4k 3k 3b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 3k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k 2k 2b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 2k 1k 1b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp 1k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp k k b7;Aq(&4V 檻+ǧ9VTv:ɪD܍Qn⪌qrt'K9ЄB]0`tc)~!= Ptp ELVALUMR2BOrientationOrderByOnDefaultViewRequiredCaption FormatDefaultValueValidationRuleValidationTextColumnWidthColumnOrderColumnHiddenDecimalPlacesDisplayControlAllowZeroLength$UnicodeCompressionIMEModeIMESentenceModeInputMask FilterOrderByNameMapGUIDDescriptionSmartTags     UX57L~ԠE=Ȗ=@My Company InformationC5X57L~ԠESetupID>qZ!aDWSX57L~ԠESalesTaxRateFrQH 5$ X57L~ԠECompanyNamezNy%ڕX57L~ԠEAddressBuGjsSX57L~ԠECityɮ&RlGgy;X57L~ԠEProvince1_H_\EtX57L~ԠEPostalCode ?L8X57L~ԠECountry Q`F]۹mX57L~ԠEPhoneNumber'3x' BzvyYrX57L~ԠEFaxNumberRC@D&S X57L~ԠEDefaultPaymentTermsʶG!B[}`MznX57L~ԠEDefaultInvoiceDescription  X57L~ԠESalesTaxRate $ Sales Tax Rate Percent  0  <1L DThis value must be less than 100%.          m *G6)CompanyName    Company Name        m    s?U'M:ɨh@=Address          m    oS9@tc!City          m    1q1yJDJ3Province   Province        m    M,]QAXV`PostalCode   Postal Code >L0L\ 0L0        m    R[#5N^ՊCountry          m    _L $PhoneNumber    Phone Number, $000\-000\-0000;0;_        m    ӧﾙ7L FaxNumber   Fax Number, $000\-000\-0000;0;_        m    .7 P@ -ۇ<,&DefaultPaymentTerms  2 *Default Payment Terms        m    a"COḫ82DefaultInvoiceDescription  > 6Default Invoice Description          + -ZG{iSetupID SetupID       MA_-oL}X LVALh MR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHidden FormatValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsInputMaskDefaultValueDisplayControlIMEModeIMESentenceMode$UnicodeCompression   H @ U,,eG<7Ȗ=@Payment Methodsq JhB5|,,eG<7PaymentMethodIDS'E.G[)U,,eG<7PaymentMethodA+[G_=sP,,eG<7CreditCard  ,,eG<7 PaymentMethod  $ Payment Method    m    DU#tCreditCard   Credit Card? Yes/No    m ">8S>@x&CTᓍ$PaymentMethodID* "Payment Method ID    ^41HX5/LVAL?MR2OrientationOrderByOnDefaultViewRequiredCaptionColumnWidthColumnOrderColumnHidden FormatDecimalPlacesInputMaskAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsDefaultValueIMEModeIMESentenceMode$UnicodeCompression     UkXHAՏ6'<ɖ=@PaymentsswTBXԑBkL89kXHAՏ6'PaymentIDPW8Hً;kXHAՏ6'RegistrationIDCIlRVkXHAՏ6'PaymentAmountbZ!:qKARrkXHAՏ6'PaymentDateV]HJkXHAՏ6'CreditCardNumber7lHdLŒn~>X޴6'4ð;g³X޴6'9䰭{Gu~EmployeeID  Employee ID o Table/Query SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];     0;2880   2880twip       s5K~u=G#EventID  Event ID o Table/Query SELECT DISTINCTROW Events.EventID, Events.EventName, Events.AvailableSpaces FROM Events ORDER BY Events.EventName;    0;2880;0   2880twip       \ LE`V& RegistrationDate * "Registration Date Short Date 99/99/00;0        u[tMkRR,&PurchaseOrderNumber   PO Number    m    ! NC_SalesTaxRate $ Sales Tax Rate Percent  0  <1L DThis value must be less than 100%.     m q|[N61f FeeScheduleID & Fee Schedule ID     m :-uD[D!^)$RegistrationFee (  Registration Fee0 ($#,##0.00;-$#,##0.00      eZgGZNzŇ"RegistrationID& Registration ID    qz!E%#  ~ v U6Un~LRGa!Wɖ=@Registration]GU0Aޒ6Un~LRGa!RegistrationIDJ21bBDȣfQ6Un~LRGa!AttendeeIDuB( /MƖ=@EmployeesF (Show Navigation Pane Search Bar    09.50 ~ w             F   Office Theme MR2BOrientationOrderByOnDefaultViewColumnWidthColumnOrderColumnHiddenDescriptionRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesDefaultValue FormatValidationRuleValidationText FilterOrderByNameMapGUIDInputMaskCaptionSmartTags   j b UhdUJ,n.˖=@Venues_}3K[~JhdUJ,nVenueNameר"&I@JhdUJ,nCapacity17K<hdUJ,nRaisedStageEPv? LʛHkhdUJ,nBeverageService  hdUJ,nVenueName   < 4The room or facility name.    m      Capacity   N FCapacity is the fire code capacity.    0   mjRaisedStage     Yes/No   jr$BeverageService     Yes/No   jMR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLW <       E/eeI U6Un~LRGa!r˖=@Registration[~XI&>u~6Un~LRGa!AttendeeIDqz!E%#6Un~LRGa!RegistrationID J,&Total Registrations T<"NE_Y&MR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLU <       8SCO~ UkXHAՏ6'd̖=@Payments/(G_ƍTkXHAՏ6'RegistrationID9tEP kXHAՏ6'PaymentAmount @"Total Payments )N39HE  U 0 ] . e {FA0A8BD4-9CED-460C-B39E-14E02F757E45}PaymentsRegistrationIDRegistrationRegistrationIDjZ{E97AEEB8-19B0-47EE-9E82-2A30E8FEE3AD}RegistrationFeeScheduleIDFee SchedulesFeeScheduleIDrZ{E4EB61BE-00BA-4AC5-B640-3BEC84E18E2D}EventsEventTypeIDEvent TypesEventTypeID|fZ{E1326185-AAFD-4728-8D2C-9321CDC0F147}RegistrationEventIDEventsEventIDrZ{DEC1D036-D064-4161-830A-90BB2B938C00}PaymentsPaymentMethodIDPayment MethodsPaymentMethodIDjZ{D9D70FE7-B18D-434A-B153-5DDB1CC488EA}RegistrationEmployeeIDEmployeesEmployeeIDrZ{A6EB293B-F895-4132-A877-46D3403552F8}EventsEmployeeIDEmployeesEmployeeIDzfZ{9B9C667B-FC98-41F1-BDE3-038162828582}RegistrationAttendeeIDAttendeesAttendeeIDrZ{1E2E1ABA-2500-4C78-AA27-6848050604D0}Fee SchedulesEventIDEventsEventIDtZ}LVALdk3-xME (S<S<S<<N0{00362366-042F-4A58-8A9C-CA789CE3A88B} `@iv %(` " ("08:P,  : ,H P`hp xp ! (oP` $& $&/You must enter both beginning and ending dates.A@8Beginnining Registration Date *B@,d8   0Ending date must be greater than Beginning date.A@84Beginnining Registration Date *B@,d (0kko6Attribute VB_Name = "Form_Report DalRange" Bas0{00362366-042F-4A58-8A9C-CA789CE3A88B} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplqDerivCustomizD$Option Comp@dab  [V5 5AM6 -!8be ger@ than +g I6t7K8AကVisiğ) IffB  LVAL WxME+@i$79@&L8\@(Lpeh B  R  p    xpK Returns True if the specified form is open in Form view or Datasheet view.9-1]`]xlick ,  $$* &y to t $$d!. ('k(k iuAttribute VB_Name = "Global Code" Option4mpare Database`Explicit FuncZIsLoad@ed(ByVs@trFormAs Sng) Integer ' Returns True if the specified f@ is open in P view orsheetE.N Const conObjStateClosO= 0 DesignV)If SysCmd(acGet'ect), acG, t) <>;The6n*Q ,s( .CurrentE"M "そ.End0 An& LVAL6 $+[xME (S<S<S<<N0{5C08E5DC-4AEA-4FD2-8C71-A1A721428430} 2@iv79`%h``  " @ Xh xxp5There is no data for this report. Canceling report...A@8'v@oeAttribute VB_Name = "Report_endee Listi ng" Bas0{5C08E5DC-4AEA-4FD2-8C71-A1A721428430} |Global!sSpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT   ,IfA LVALxME (S<S<S<<N0{7F5D19C7-A6C3-4BCF-92D0-90B1D317F1F5}8 2`@ivSo 6 8iv(% " @ Xh"p$x" 4  (xp5There is no data for this report. Canceling report...A@8'vt viewo` Report Date Range *B@B00oXReport Date Range  ! *B@L\5Report Date Range$'vkoAttribute VB_Name = "Report_Sales by Employee"  Bas0{7F5D19C7-A6C3-4BCF-92D0-90B1D317F1F5} |GlobaltSpacAIFalse dCreatablTru PredeclaId"Expose _TenateDerivCus`tomizD$Option Codmp@ DT   stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\Sys@WOW64\e2.tlb#OLE Automation0hADODB> AADOBuDDE5!D10-8DAA006D2EA4D5DProgram Files (x86)\C`ommon Ptem\ado\ms25QMicrosoft ActiveX Data Objects 2.5 LibraryKDAO">DA^  \4AC9E1DA-5BAD-7-86E3-24F4CDCECA28}#cP^.(Shared\OFFICE16\ACEA@".DLL# Offi@16.0 4d4base engineD7 6fVBIDEfVBIfEf67a2E1D57f00-P5 .3$f7VBA\6E6EXT.OLB7Visual Basic for Applic˜s Extensibility @!@-@@Form_At@ deesG rm_@vten"esBMWHILTKQFFQQPDIOXSAGLNFCBL YJ28MWHOLTKQF QP)IEXS GLN C-LYJ @1yx"Ea,i"(+! Sub#mG,,a ubfdNGFRYIMFCYGFAEAPDXUVLFRLLMUGNGR`(IM"Y"AEXUVQFRLU ,! O6EmplToy6E7p@o$y6e6WLUWLWHYDVVNHEWEAXGMBDITQBTMFW`U`7LU7Y5VN 2E aXM5D;T :BU6Eve@nt Typ!Q Q*6Ev nQ 1 JypREYSEDMAFBYVEERCAYANCAVDEUTELR1Y eport_Sals bDyEvnQ Tp OIBXFXJYUIOSRDCKDCIVDXVCWOYE28[OIBXQXJUOcRDC(IV XCJWEySy:LVALиFa  ,*\G{000204EF-0000-0000-C000-000000000046}#4.2#9#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL#Visual Basic For Applications(*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files (x86)\Microsoft Office\Root\Office16\MSACC.OLB#Microsoft Access 16.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\SysWOW64\stdole2.tlb#OLE Automation**\G{00000205-0000-0010-8000-00AA006D2EA4}#2.5#0#C:\Program Files (x86)\Common Files\System\ado\msado25.tlb#Microsoft ActiveX Data Objects 2.5 Libraryh*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\Program Files (x86)\Common Files\Microsoft Shared\OFFICE16\ACEDAO.DLL#Microsoft Office 16.0 Access database engine Object Libraryf*\G{0002E157-0000-0000-C000-000000000046}#5.3#0#C:\Program Files (x86)\Common Files\Microsoft Shared\VBA\VBA6\VBE6EXT.OLB#Microsoft Visual Basic for Applications Extensibility 5.3  _I2  8MWHILTKQFFQQPDIOXSAGLNFCBLYJ1159936392!Form_Attendeesi 8NGFRYIMFCYGFAEAPDXUVLFRLLMUG1259936392m,Form_Attendees SubformO!8WLUWLWHYDVVNHEWEAXGMBDITQBMF1359936392Form_Employees0U8REYSEDMAFBYVEERCAYANCAVDEUEL1459936392 Form_Event TypespHU8UBYDRNBSBJERQDTJAYKBDAUQKMLI1559936392Form_Events$l` 8JAYNJWEFXEYXFEPLUJXABWXVSUIE1659936392$Form_Fee SchedulesxU8VEKNYIHSPNQAUDDPHGVFBHVIPYKN1759936392(Form_Payment MethodsdU8YESJUCJYYLBWUDZCNZUNNMKRCBLE1859936392Form_Paymentsni 8TOTSUACHPLPEVDFLHEAGHIGHUSPL1959936392$Form_Print Invoice@8MXGXWLNEKSUCODYIWNKJDOKOUCIL1:59936392"Form_Registration 8DBQXRWIXQEAMYDCHLNXFDLTAPYJN1;59936392,Form_Report Date Range-98CAKZTFIGXRMHFEBDMVVCBMJSDICF1<59936392"Global CodeW8TKKQFKDERCORSDEKTPVVNTSTGANC1=599363921.Report_Attendee Listing a8IPBKTUFHOOEVCEDXBYKTCGZOUDBF1>599363925Report_Invoice88ECXEJTDBG LVALFo&-qxME(S<S<S<<N0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7}  P%pPP &-qxME(S<S<S<<N0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Employ@ees" Bas0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TeateDerivCus&-qxME(S<S<S<<N0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Employ@ees" Bas0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TeateDerivCustomizD$Option Comp@ DT  Show Navigation Pane Search Bar    09.50 ~              F   Office Theme MR2^ANSI Query Mode(Themed Form ControlsAccessVersion BuildProjVerNavPane ClosedNavPane Width NavPane Category*NavPane Category NameNavPane View ByNavPane Sort By6Track Name AutoCorrect Info0Perform Name AutoCorrectHasOfflineListsWebDesignMode&Theme Resource Name>Show Navigation Pane Search Bar    09.50 ~              F   Office Theme  LVALe-xME(S<S<S<<N0{00362366-042F-4A58-8A9C-CA789CE3A88B} pPi| " %p " ("08:P,  : ,H P`hp xp ! (oPp $$, &$,/You must enter both beginning and ending dates.A@>Beginnining Registration Date 0B@2d8 $ & 0Ending date must be greater than Beginning date.A@>4`Beginnining Registration Date 0B@2d (kkox6Attribute VB_Name = "Form_Report DalRange" Bas0{00362366-042F-4A58-8A9C-CA789CE3A88B} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplqDerivCustomizD$Option Comp@dab  [V5 5AM6 -!8be ger@ than +g I6t7K8AကVisiğ) IffB S5u@u@B7 @ DWEPRSJVBCYUQDDZCIOUBOBJNEEIb^Z"  LVALFM}xME(S<S<S<<N0{5C08E5DC-4AEA-4FD2-8C71-A1A721428430} 8Pi| p$0%Ppp  " @ Xh xxp5There is no data for this report. Canceling report...A@>'|oxeAttribute VB_Name = "Report_endee Listi ng" Bas0{5C08E5DC-4AEA-4FD2-8C71-A1A721428430} |Global!sSpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  '|oxeAttribute VB_Name = "Report_endee Listi ng" Bas0{5C08E5DC-4AEA-4FD2-8C71-A1A721428430} |Global!sSpacIFalse dCreatablTru Predecl2aId"Ex0pose_TemplateDerivCust0omizD$Option Com2p@ DT  :SMSysAccessStorage,(NFee Schedules$ Gf_89FB037064DA4B26B45DED4CF2889F3C_DataXT?Events;Event Types 6Employees/Attendees0Attendee Count by Event84Sales by Event Type0,Sales by Employee,(InvoiceAttendee Listing*&Global Code Report Date Range,(Registration"Print Invoice$ PaymentsPayment Methods($My Company Information62Fee Schedules$ Events Subform&"Events Event Types  Event Fee Schedule Subform>: Employees Attendees Subform,( Attendees'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects  Su@u@C@ CWWGBAHINZDCDEJLKNTIFHFFELRHb^Z"  Su@u@D~@ SWWQJDNWISTCTDFJELBRBPWHJNBIb^Z"  LVAL AxME(S<S<S<<N0{86760754-8984-4473-BD2B-1AAAB32174C7}p 8pPi| < >i| `0%00 " @ Xh"p x" ( xp5There is no data for this report. Canceling report...A@>'|nceop  Print Invoice 0B@Bo` Print Invoice  0B@R Print Invoice$D '|koxαAttribute VB_Name = "Report_Invo@ice" Bas0{86760754-8984-4473-BD2B-1AAAB32174C7} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT    ,IfA Su@u@E@DBPNZMKHQHFEQDOCVPUXGFWCNEYIb^Z"  LVAL YxME(S<S<S<<N0{7F5D19C7-A6C3-4BCF-92D0-90B1D317F1F5}p 8pPi| < >i| `0%00 " @ Xh"p$x" 4  (xp5There is no data for this report. Canceling report...A@>'|nceop Report Date Range 0B@B`oXReport Date Range  ! 0B@RReport Date Range$'|koxAttribute VB_Name = "Report_Sales by Employee"  Bas0{7F5D19C7-A6C3-4BCF-92D0-90B1D317F1F5} |GlobaltSpacAIFalse dCreatablTru PredeclaId"Expose _TenateDerivCus`tomizD$Option Codmp@ DT   i| `0%00 " @ Xh"p$x" 4  (xp5There is no data for this report. Canceling report...A@>'|nceop Report Date Range 0B@BoXReport Date Range  ! 0B@RReport Date Range$'|koxAttribute VB_Name = "Report_Sales by Event Type"D Basb0{CCCB2B3D-0C78-47AE-9697-7F1DF87@A58A4} |G lobalvSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  stdole h%^*\G{00020430-;C 0046}#2.0#0#C:\Windows\sys@tem32\e2.tlb#OLE Automation0hADODB> AADOBuDDE5!D10-8DAA006D2EA4D5DProgram Files\CommonSM\ado\ms25NMicrosoft ActiveX Data Objects 2.5 LibraryHDAO>DA[ Y4AC9E1DA-5BAD-7-86E3-24F4CDCECA28}#cO,'Shared\OFFICE@14\ACE .DLL# Offi@1e@3d3base eng8ine54cVBIDEcVBIcEc56A^2E157c0D0-P5.3c `(x86)d7V(BA\6E6EXT.OLB7Visual Basic for Applic•s Extensibility @!@-@ @Fo rm_At@ de`esGrPm_ttenesBRZSEMLDLZMKAFEZZZRGTKEWCVCKL28RZSEPMLPL@MTKF`ZZ@RGT`E@WCV`K#`H j1x`w",Qi""(+1 Sub#mG,a ubfdMUSTVNCKSNICCE@OCYGAWGVXUNMU TN"SN@FC`EaCYA GX N(%  O6EmplToy6E7po$y6e6VCZKMWJKWBVMAEDUVBPLLFJENAL60Z2M`JW@`V8A6D AbP4LFJ`N`:L 6 i6Event Typ!Q *6Ev nQ FypFPDTVOKRYMPTMDULWGQYKUG YGSVC4FVPP4O`R2M- TaL`GQK GG`:!!aip @kSFP3LBEYCGOLJKPDBSWJBW_LNQVBKDUAL2E@CKOW14B@W@2B_N5KI M$lFee Schedu@G$F1ehceueMWTYFAGFBKGMHEEPOMBQNOGBNNJC'Tp F%G%BGH@&EOB0 N`5G0:N6Jp 'D  Paym'Meth,odEF PZa4m0(Mt popWOWIYIFOSDVXRDVAGGSGMGABIMABUW W2Y0FESVXPD`AAa'1G0gMrdpk"Q  HBZVGFHIFRBS HECIN` JG@HBQAEH H Z` H RS[EOIO)D)G0DHODm(n "(PripBIn vo`~(Prikt(Ipv`ic 3]UHPAVEMNRBMHZDONBPBMJKDLRUMG U PV'VM M0ZOB(B(7D (RPCMMo6D@ (R@egistr|Gw(R@ g jr0)to  H@CPUNFDForm_AttendeesForm_AttendeesForm_Attendees SubformForm_Attendees SubformForm_EmployeesForm_EmployeesForm_Event TypesForm_Event TypesForm_EventsForm_EventsForm_Fee SchedulesForm_Fee SchedulesForm_Payment MethodsForm_Payment MethodsForm_PaymentsForm_PaymentsForm_Print InvoiceForm_Print InvoiceForm_RegistrationForm_RegistrationForm_Report Date RangeForm_Report Date RangeReport_Attendee ListingReport_Attendee ListingReport_InvoiceReport_InvoiceReport_Sales by EmployeeReport_Sales by EmployeeReport_Sales by Event TypeReport_Sales by Event TypeGlobal CodeGlobal Code Su@u@I @dir0,(" LVALILXGEATDNNLKOYOGUAF1?59936392;0Report_Sales by EmployeeP8OIBXFXJYUIOSRDCKDCIVDXVCWOYE1@59936392=4Report_Sales by Event TypeShP h80`H֎t"ooN̛̑iB6̳FHaJua Fd;mkfBfS#5HL@ :aTGH˃ )&VGi5`kzA+MpIM8hVlO;]afT\^B,9Y=HKj8I3V2dIؗ"X>:ZōL"&\ޭ~HoFڃUGcPwrNXyexx?AccessVBAWin16~Win32Win64xMacVBA6#VBA7#Access Conference 4stdole`ADODBsDAOVBIDEAForm_Attendeesz{ _Evaluate Form_CurrentIsNull AttendeeIDFDoCmdƧ GoToControl P Form_Activaten Err_Form_ActivateAttendees SubformRequeryExit_Form_ActivateMsgBoxRErro Description Register_Click Err_Register_Click DoMenuItem&e acFormBar acRecordsMenu6 acSaveRecordj acMenuVer70XOpenFormExit_Register_ClickWPayments_Click.Err_Payments_ClicknFormRecordsetClone8 RecordCount{Exit_Payments_ClickcPreviewInvoice_ClickErr_PreviewInvoice_Click OpenReport acPreviewoForms AttendeesTRegistrationIDBExit_PreviewInvoice_ClickUForm_Attendees Subform p ViewEvent Err_ViewEventPExit_ViewEventIEventName_DblClickhCancelStartDate_DblClick%Sale_Amount_DblClickETotal_Payments_DblClickEAmount_Due_DblClick(Form_Employees3Q Form_Load{OpenArgsB EmployeeIDsForm_Event Types EventTypeID Form_EventsEventIDDEventTypeID_NotInListDNewDatax_ResponseacDataErrContinueDEventTypeID_DblClickoErr_EventTypeID_DblClick$lngEventTypeIDacDialogaExit_EventTypeID_DblClickT[EmployeeID_NotInListQEmployeeID_DblClickaErr_EmployeeID_DblClickr lngEmployeeIDIExit_EmployeeID_DblClickToggle_View_Click{ Toggle ViewCCaptionxEvents SubformVisibleEvent Fee Schedule Subform_Form_Fee Schedulesy FeeScheduleID\fForm_Payment Methods*cPaymentMethodID Form_Payments  Form_Open-IsLoaded.Form_BeforeInsertErr_Form_BeforeInsert PaymentDate PaymentAmounta Amount Due\Exit_Form_BeforeInsertEPaymentMethodID_NotInList_PaymentMethodID_AfterUpdate}Err_PaymentMethodID_AfterUpdateColumniCardholdersName+NAttendeeFirstNameGAttendeeLastNameVc Exit_PaymentMethodID_AfterUpdates(PaymentMethodID_DblClickErr_PaymentMethodID_DblClickulngPaymentMethodIDExit_PaymentMethodID_DblClickvForm_Print InvoiceOK_ClickR Cancel_ClickacFormForm_RegistrationForm_AfterInsertwRemaining SeatszErr_Form_CurrentExit_Form_CurrentK Total Paidޔ FindRecordxeEventID_NotInListb,EventID_AfterUpdateRegistrationFee'(EventID_DblClickErr_EventID_DblClickj lngEventIDExit_EventID_DblClickyFeeScheduleID_NotInList+FeeScheduleID_AfterUpdate,FeeScheduleID_DblCli LVAL ckErr_FeeScheduleID_DblClick lngFeeScheduleID? Exit_FeeScheduleID_DblClick|Form_Report Date Range  Preview_ClickxBeginnining Registration Date$WEnding Registration Date7 Global Code strFormNameoconObjStateClosedZ conDesignViewSysCmdGacSysCmdGetObjectState? CurrentViewReport_Attendee Listing Report_NoDatayReport_Invoiceó Report_CloseY Report_OpendReport_Sales by EmployeeReport_Sales by Event Typen;=-   # *m!"1 ,!5 +.  LVAL orm_Report Date Range  Preview_ClickxBeginnining Registration Date$WEnding Registration Date7 Global Code strFormNameoconObjStateClosedZ conDesignViewSysCmdGacSysCmdGetObjectState? CurrentViewReport_Attendee Listing Report_NoDatayReport_Invoiceó Report_CloseY Report_OpendReport_Sales by EmployeeReport_Sales by Event Typen7 !; AC  ! $) -s  "$'%.  Su@u@H#@!_VBA_PROJECTB>:"  Su@u@J@PROJECTwm<84" LVAL& Form_AttID="{0627FC99-4422-4E3B-9F8E-B1943492BECF}" DocClass=Form_Attendees/&H00000000 DocClass=Form_Attendees Subform/&H00000000 DocClass=Form_Employees/&H00000000 DocClass=Form_Event Types/&H00000000 DocClass=Form_Events/&H00000000 DocClass=Form_Fee Schedules/&H00000000 DocClass=Form_Payment Methods/&H00000000 DocClass=Form_Payments/&H00000000 DocClass=Form_Print Invoice/&H00000000 DocClass=Form_Registration/&H00000000 DocClass=Form_Report Date Range/&H00000000 DocClass=Report_Attendee Listing/&H00000000 DocClass=Report_Invoice/&H00000000 DocClass=Report_Sales by Employee/&H00000000 DocClass=Report_Sales by Event Type/&H00000000 Module=Global Code Name="Access Conference 4" HelpContextID="0" VersionCompatible32="393222000" CMG="93917D68906C906C906C906C" DPB="AAA844815A825A825A" GC="C1C32FB030B0304F" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] Form_Attendees=0, 0, 0, 0, C Form_Attendees Subform=0, 0, 0, 0, C Form_Employees=0, 0, 0, 0, C Form_Event Types=0, 0, 0, 0, C Form_Events=0, 0, 0, 0, C Form_Fee Schedules=0, 0, 0, 0, C Form_Payment Methods=0, 0, 0, 0, C Form_Payments=0, 0, 0, 0, C Form_Print Invoice=0, 0, 0, 0, C Form_Registration=0, 0, 0, 0, C Form_Report Date Range=0, 0, 0, 0, C Report_Attendee Listing=0, 0, 0, 0, C Report_Invoice=0, 0, 0, 0, C Report_Sales by Employee=0, 0, 0, 0, C Report_Sales by Event Type=0, 0, 0, 0, C Global Code=0, 0, 0, 0, C Form_AttendeesForm_AttendeesForm_Attendees SubformForm_Attendees SubformForm_EmployeesForm_EmployeesForm_Event TypesForm_Event TypesForm_EventsForm_EventsForm_Fee SchedulesForm_Fee SchedulesForm_Payment MethodsForm_Payment MethodsForm_PaymentsForm_PaymentsForm_Print InvoiceForm_Print InvoiceForm_RegistrationForm_RegistrationForm_Report Date RangeForm_Report Date RangeReport_Attendee ListingReport_Attendee ListingReport_InvoiceReport_InvoiceReport_Sales by EmployeeReport_Sales by EmployeeReport_Sales by Event TypeReport_Sales by Event TypeGlobal CodeGlobal Code OxME (S<S<S<<N0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7}x h@%@@  "*Hhp xxp !GotoNew "$&Mic D J *B@B\IkoAttribute VB_Name = "Form_Employ@ees" Bas0{FBC35C7F-A2C7-48B0-B5CA-71B94B39CEB7} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TeateDerivCustomizD$Option Comp@ DT