Standard ACE DBnb` Ugr@?~1y0̝cßFNe7ڜ(@(` {6߱$jC13gy[+|*|Xf_Љ$g'DeFx -bT4.0dv`R` YcS cc Y   Y Y  Y Y  Y  Y  Y   Y  Y  Y  Y  Y 2Y  Y   Y  Y ConnectDatabaseDateCreateDateUpdate FlagsForeignNameIdLvLvExtraLvModule LvPropName OwnerParentIdRmtInfoLongRmtInfoShortTypeYYIdParentIdName        OY'S  bY Y Y  Y 2ACMFInheritableObjectIdSID( YObjectId YS  Y  Y Y Y  Y  Y Y  Y AttributeExpressionFlagLvExtra Name1 Name2ObjectId Order Y"ObjectIdAttribute   -YS  Y Y Y  Y . Y  Y  Y  Y ccolumn grbiticolumnszColumnszObject$szReferencedColumn$szReferencedObjectszRelationship9 6  HtYYYszObject$szReferencedObjectszRelationship v1b N  : k & ||@@  @@  @@ @ @ @@@ @ @    JmmQbOQQkJmmQbOQQkkoLSdi`JomdQqQbmkQ`f^dvQQkQqQbmSQQkMWQOo^QkoLSdi`QqQbmmvfQk QqQbmk!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)JO`Yb)OJmJJMMQkkfJUQkOJmJLJkQkSdi`k`dOo^QkiQ^JmYdbkWYfkiQfdimkkMiYfmkkvkiQ^mJL^Qk+kh+MJmmQbOQQk+kh+MJmmQbOQQkkoLSdi`)+kh+MJomdQqQbmk+kh+MQ`f^dvQQYO)+kh+MJomdQqQbmk+kh+MQqQbmmvfQYO)+kh+MJomdQqQbmk+kh+M^dMJmYdb)+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+MiQUYkmiJmYdb+kh+MQ`f^dvQQYO)+kh+MiQUYkmiJmYdb+kh+MQqQbmYO)+kh+MiQUYkmiJmYdb+kh+MSQQkMWQOo^QYO)+kh+SJmmQbOQQkkoLSdi`)+kh+SJomdQqQbmk)+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+SiQUYkmiJmYdb)+kh+iJmmQbOQQ^YkmYbU)+kh+iYbqdYMQ)+kh+ikJ^QkLvQ`f^dvQQ)+kh+ikJ^QkLvQqQbmmvfQ)JmmQbOQQMdobmLvQqQbm) JmmQbOQQk)!Q`f^dvQQk)"QqQbmmvfQk)#QqQbmk)$S+FFFMLLBB:@OQ>BQ8HS<DSD6FMOD6QOD>6FD8>:B+ +;K[+ DF::B<8SBMFQBHOJM>FQ+ +;K[+ SHOL8L>HMSJL>LS>H?     !#%'1)!8)"=)#A)$I)%PRVRRRRRRRRR R R v1 @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @    $% & ' ( ) * + , - . / 0 1 2 3 456789:;<=>?@ABCDEFGHIJKLMNOP        !!!" "!""###$#%$&$'$(%)%*%+&,&-&.'/'0'1(2(3(4)5)6)7*8*9*:+;+<+=,>,?,@-A-B-C.D.E.F/G/H/I0J0011122233 3 4 4 4 555666777888999:::;/;0;1<2<3<4=8=9=:>;><>=?>???@56789  IFGHCDE!@!A!B#=#>#?%%%':';'<1 1!1"8#8$8%=&='=(A)A*A+I,I-I.P/P0P1V2V3V4    !"#$%&'()*+,-.567  !"#v1@H40.,/******** *  * * * * * *  * * !*!*!*!*"*"*"*"*" *"*#*#*#*#* #*!#*$*"$*$$*%$*&$*'$*#%*(%**%*+%*,% *-%*)&*.&*0&*1&*2& *3&*/'*4'*6'*7'*8' *9'*5(*:(*<(*=(*>( *?(*;)*@)*B)*C)*D)*E)*F) *G)*A**H**J**K**L**M**N**O**I+*P+*R+*S+*T+,+,+,+,+,+,+,+,+,+, + , +*Q,, ,, ,,,, -,-,-,-,.,.,.,.,/,/,/,/,0,0,0,0,0, 0,!0,"0,#0,$0,%0,&0,'0,(0 ,)0,1,*1,,1,-1,+2,.2,02,12,/3,23,43,53,34,64,84,94,:4,;4,75,<5,>5,?5,@5,A5,B5,C5,=6,D6,F6,G6,H6,I6,J6,K6,E7,L7,N7,O7,P7-7-7-7-7-7-7-7-7,M8-8- 8- 8- 8- 8-8-8-8-8-8-8-8-8-8-8-8-8-8-8 -8 -8 -8 -8 - 8- 9-!9-#9-$9-%9-&9-'9-(9-)9-*9-+9-,9--9-",Mv1@f @+ :DLQOD>DSD6FMOD6QOD>6FD8>:B+ +;K[ + DF::B<8SBMFQBHOJM>FQ+ +;K[ + SHOL8L>HMSJL>LS>H>>22222220 @&֦=@&֦=@Payment Methods@LLL@@@@@@@> @k֦=@k֦=@My Company Information@ZZZNNNNNNNL @զ=@զ=@Fee Schedules&@HHH<<<<<<<: @vrզ=@vrզ=@Events Subform8@JJJ>>>>>>>< @RӦ=@Ӧ=@Event Types:@DDD88888886 @ Ӧ=@Ӧ=@Event Fee Schedule Subform8@bbbVVVVVVVT @ Ӧ=@Ӧ=@Employees@@@@44444442 @ ΈҦ=@ΈҦ=@AutoEvents@BBB66666664 @  ͦ=@ ͦ=@Attendees SubformR@PPPDDDDDDDB @ &q̦=@&q̦=@Attendees.@@@@44444442 @ s"=@s"=@UserDefinedA@DDD88888886 @ P"=@fP@SummaryInfo|@DDD88888886 @Rs"=@s"=@SysRel.........., s"=@s"=@Scripts0000000000. s"=@s"=@Reports0000000000. s"=@s"=@Modules0000000000. s"=@s"=@Forms,,,,,,,,,,* s"=@s"=@DataAccessPages@@@@@@@@@@> '*$rR@*$rR@MSysComplexType_AttachmentTTTTTTTTTTT %*$rR@+$rR@MSysComplexType_TextHHHHHHHHHHH #*$rR@+$rR@MSysComplexType_DecimalNNNNNNNNNNN !*$rR@+$rR@MSysComplexType_GUIDHHHHHHHHHHH *$rR@+$rR@MSysComplexType_IEEEDoubleTTTTTTTTTTT *$rR@+$rR@MSysComplexType_IEEESingleTTTTTTTTTTT *$rR@+$rR@MSysComplexType_LongHHHHHHHHHHH *$rR@+$rR@MSysComplexType_ShortJJJJJJJJJJJ *$rR@+$rR@MSysComplexType_UnsignedByteXXXXXXXXXXX *$rR@*$rR@MSysComplexColumnsDDDDDDDDDDD P"=@P"=@MSysRelationshipsDDDDDDDDDDB P"=@P"=@MSysQueries88888888886 P"=@P"=@MSysACEs22222222220 P"=@P"=@MSysObjects88888888886 P"=@Pu@MSysDbC@:::......., @P"=@P"=@Relationships<<<<<<<<<<: P"=@P"=@Databases44444444442 P"=@P"=@Tables.........., D Y[N Y Y  Y Y Y ColumnNameComplexID&ComplexTypeObjectID"ConceptualTableIDFlatTableIDU((xp}YYY(IdxConceptualTableIDIdxFlatTableID IdxIDv1@ IfYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYNY  ValuedvfYN  Y  ValuedvfYN""Y  ValuedvfYN$$Y ValuedvfYN&& Y  ValuedvaY[N(( Y Y  Y Y  Y K Y UFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL((((Hv1b&:6ONY L K W SJ H,GFC?FD>:DBoTpIbћ\u@cIp~Su@q~Su@ f_888CBB6625DE46E19F33AE1C70E7D2D9_Datappppppppppn AJŦ=@\u@EventsOf:::......., @=)Ŧ=@\u@Event Types@DDD88888886 @8nĦ=@\u@Employees@@@@44444442 @1 væ=@=@AttendeesOf@@@44444442 @:˦=@=@Attendee Count by EventW@|@h\\PPPPPPPN @R8&o =@&o =@~sq_rSales by Employee4MR2KeepLocal TNNNNNNNL @78 =@8 =@~sq_rInvoice4MR2KeepLocal Tzzz:::::::8 @R5>=@|=@~sq_fRegistration4MR2KeepLocal TDDDDDDDB @R3=@=@~sq_fPayment Methods4MR2KeepLocal TJJJJJJJH @2=@=@~sq_fMy Company Information4MR2KeepLocal TXXXXXXXV @R0v=@v=@~sq_fEvents Subform4MR2KeepLocal THHHHHHHF @R.=@=@~sq_fEvent Types4MR2KeepLocal TBBBBBBB@ @R, 2=@ 2=@~sq_fAutoEvents4MR2KeepLocal T@@@@@@@> @+=@=@~sq_fAttendees Subform4MR2KeepLocal TNNNNNNNL @R)>=@>=@~sq_cRegistration~sq_cEventID4MR2KeepLocal T\\\\\\\Z @(>=@>=@~sq_cRegistration~sq_cEmployeeID4MR2KeepLocal Tbbbbbbb` @R&Jk=@Jk=@~sq_cFee Schedules~sq_cEventID4MR2KeepLocal T^^^^^^^\ @% =@ =@~sq_cEvents~sq_cEventTypeID4MR2KeepLocal TXXXXXXXV @R#=@=@~sq_cEvents~sq_cEvent Fee Schedule Subform4MR2KeepLocal Tvvvvvvvt @R!=@=@~sq_cAutoEvents~sq_cLocation4MR2KeepLocal TZZZZZZZX @  2=@ 2=@~sq_cAutoEvents~sq_cEventTypeID4MR2KeepLocal T```````^ @RI=@I=@~sq_cAttendees~sq_cAttendees Subform4MR2KeepLocal Tjjjjjjjh @ 7ӧ=@7ӧ=@Admin@8,,,,,,,,,* Rަ=@ަ=@Sales by Employee@PPPDDDDDDDB @uݦ=@uݦ=@InvoiceF @<<<0000000. @Up4G u W # i K !  } 2 { ]  j L  yE mCy=wGy[==o&sU7+on!Registration))) +on!Events +n! G+on! +n! G*], l@+ '*, [Fee Schedules].Fee2 g*,  [Fee Schedules].FeeDescription= g*, [Fee Schedules].FeeScheduleID< g*], Fee Schedules+++ *,  G*],  *,  G) Events.EventName/ ')Events.AvailableSpaces5 g)Events.EventName/ g)Events.EventID- g)Events ) G) ) G( ], ![LastName] & ", " & [FirstName]> '(, ![LastName] & ", " & [FirstName]> g(, [EmployeeID]+ g(], Employees### (],  (,  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$ati([__EventID] = EventID)6 '$atiEvents@+) 7$ ti G$ti__EventID### O$ati $ti G#([__EventID] = EventID)6 '#Fee SchedulesEvents77+ #  G#__EventID### O# # G" ![LastName] & ", " & [FirstName]> '"![LastName] & ", " & [FirstName]> g"[EmployeeID]+ g"Employees### " " G!PVenues ! P G!P !P G cClass[Event Types].EventType6 ' lass[Event Types].*. g cClassEvent Types'''  lass G cClass  lass G ati![LastName] & ", " & [FirstName]> 'ti![LastName] & ", " & [FirstName]> gti[EmployeeID]+ gatiEmployees### ati ti GJ([__AttendeeID] = AttendeeID)< 'JAttendees@+/# 7 J GJ__AttendeeID))) OJ J GLVALJ B^2.jz4&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]((Registration.AttendeeID=forms!Attendees!AttendeeID))Attendees.AttendeeID=Registration.AttendeeID((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](([Fee Schedules].EventID=forms!Registration!EventID))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];Qq)lB E z \ > b D &  T  S  \rT6<jLd4pF( `)gI7by Events 7by Employees### 7by Attendees### 7by  7y  G6AttendeesTotal Registrations by Attendee@+ma# 6n@+ g6 Attendees.** g6Total Registrations by AttendeeOOO 6Attendees### 6 G6 6 G5l@ + '5AttendeesRegistrationX@ +G;# 5Registration.*- g5Registration))) 5Attendees### 5 G5 5 G4@ + '4 Payments.*) g4Payments!!! 4 G4 4 G3Payment Methods/// 3  G3 3 G2My Company Information=== 2  G2 2 G1NamFee Schedules+++ 1 am G1Nam 1am G0 ^@ + '0AttendeesRegistrationX@ +G;# 0RegistrationSum Of Payments Query@+_S) 0P@+ g0Registration.RegistrationFee; g0Attendees.CompanyName4 g0Attendee Name^@+7++ o0Registration.AttendeeID6 g0Registration.EventID3 g0Sum Of Payments Query;;; 0Registration))) 0Attendees### 0 G0 0 G/Events /  G/ / G.on!Event Types''' . n! G.on! .n! G-Employees### -  G- - G,ts Events , s  G,ts  ,s  G+ on!Registration.RegistrationID: '+n!EventsRegistrationF@+A5 +n!RegistrationSum Of Payments Query@+_S) +n!Registration.AttendeeID6 g+n!P@+ g+n!Registration.SalesTaxRate8 g+n!Events.StartDate/ g+n!Events.EventName/ g+n!Registration.RegistrationFee; g+n!Registration.RegistrationID: g+on!Sum Of Payments Query;;; CY%L j @  N X  ~  p F  a&h>}A>@=`B$r ; G: NaRegistration.EventID3 g:NaNumber of Registered AttendeesD@.YMM o:NaRegistration.EventID3 g:tNaRegistration))) :Na G:Na G:tNa :Na G9 Na^@. g9 NaEvents.Location. g9 NaEvents.StartDate/ g9 NaEvents.EventName/ g9 Na[Event Types].EventType6 g9tNap@. '9NaEmployeesEventsL@.;/# 9NaEventsRegistrationF@ .A5 9NaRegistrationSum Of Payments Query@ ._S) 9NaEvent TypesEventsX@ .?3' 9NaTotal PaymentsZ@ .9-- o9NaRegistrationFee@ .;// o9NaEvent Manager^@.7++ o9NaEvents.Location. g9NaEvents.StartDate/ g9NaEvents.EventName/ g9Na[Event Types].EventType6 g9tNaSum Of Payments Query;;; 9tNaRegistration))) 9tNaEvents 9tNaEvent Types''' 9tNaEmployees### 9Na G9tNa 9Na G8 ttEvents.Location. g8 ttEvents.StartDate/ g8 ttEvents.EventName/ g8 tt[Event Types].EventType6 g8 tt^@. g8Attp@. '8ttEventsRegistrationF@.A5 8ttEmployeesRegistrationX@.G;# 8ttRegistrationSum Of Payments Query@._S) 8ttEvent TypesEventsX@.?3' 8ttTotal PaymentsZ@.9-- o8ttRegistrationFee@.;// o8ttEvents.Location. g8ttEvents.StartDate/ g8ttEvents.EventName/ g8tt[Event Types].EventType6 g8ttEmployee Name^@+7++ o8AttSum Of Payments Query;;; 8AttRegistration))) 8AttEmployees### 8AttEvents 8AttEvent Types''' 8tt G8Att 8tt G7y AttendeesRegistrationX@+G;# 7y EmployeesRegistrationX@+G;# 7y EventsRegistrationF@+A5 7y  Employees.** g7y  Events.*' g7y Registration.*- g7y  Attendees.** g7by Registration))) zLVALf 0 " f r  P  6Count(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].RegistrationID[Event Types].EventTypeID=Events.EventTypeIDSum([Sum Of Payments Query].[Total Payments])Sum(Clng(Registration.RegistrationFee*(1+Registration.SalesTaxRate)*100)/100)0 @ @ @ @ @ @ @ @ @ @ @ @ @ @********* *  * * * * * *  * * !*!*!*!*"*"*"*"*" *"*#*#*#*#* #*!#*$*"$*$$*%$*&$*'$*#%*(%**%*+%*,% *-%*)&*.&*0&*1&*2& *3&*/'*4'*6'*7'*8' *9'*5(*:(*<(*=(*>( *?(*;)*@)*B)*C)*D)*E)*F) *G)*A**H**J**K**L**M**N**O**I+*P+*R+*S+*T+,+,+,+,+,+,+,+,+,+, + , +*Q,, ,, ,,,, -,-,-,-,.,.,.,.,/,/,/,/,0,0,0,0,0, 0,!0,"0,#0,$0,%0,&0,'0,(0 ,)0,1,*1,,1,-1,+2,.2,02,12,/3,23,43,53,34,64,84,94,:4,;4,75,<5,>5,?5,@5,A5,B5,C5,=6,D6,F6,G6,H6,I6,J6,K6,E7,L7,N7,O7,P7-7-7-7-7-7-7-7-7,M8-8- 8- 8- 8- 8-8-8-8-8-8-8-8-8-8-8-8-8-8-8 -8 -8 -8 -8 - 8- 9-!9-#9-$9-%9-&9-'9-(9-)9-*9-+9-,9--9-",M/ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @.,.,/,/,/,/,0,0,0,0,0, 0,!0,"0,#0,$0,%0,&0,'0,(0 ,)0,1,*1,,1,-1,+2,.2,02,12,/3,23,43,53,34,64,84,94,:4,;4,75,<5,>5,?5,@5,A5,B5,C5,=6,D6,F6,G6,H6,I6,J6,K6,E7,L7,N7,O7,P7-7-7-7-7-7-7-7-7,M8-8- 8- 8- 8- 8-8-8-8-8-8-8-8-8-8-8-8-8-8-8 -8 -8 -8 -8 - 8- 9-!9-#9-$9-%9-&9-'9-(9-)9-*9-+9-,9--9-.9-/9-09-19-29-39-49 -59 -69 -79 -89 -99-":-::-<:-=:->:-?:-@: -A:-;;-B;;;;;; ;<< < < < < < <a YN 22Y  Y < Y d Y pd Y 0d Y Ρ Y 5d Y ( Y ( Y  < Y < Y d Y ;d Y ;_AttendeeID"AttendeeFirstName AttendeeLastName TitleCompanyNameAddressCityProvincePostalCodePhoneNumberFaxNumber EmailCategory Notes;_24;__;_25;_26;__;_27YYYY AttendeeLastNameCompanyNamePostalCodePrimaryKey 22 v1b @  1CU 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.  1@Lidsb3SiQkbYQiQ3\o`Ji3fWY^^Yfk3vdiiQk3 1@Mdbkd^YOJmQOWd^OYbUk3^QmkkmdfbkWdf3`QiQfJY^^JiOQ3d^Osdi^OOQ^YMJmQkkQb3fJMYSYMY`fdimk3 1  L>UHh83W8[8M<3`8Q:i<3m:i8uF3q:i>mB3 1 33333 KY0TN99Y  Y d Y d Y ud Y t< Y g<EmployeeIDFirstNameLastName TitleExtensionWorkPhone.9;imhed9<mbYAYY.rCLastNamePrimaryKeyv1 8i= 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:*% ? 8 @LJYbQk:Lokk`Jb:UJiidsJv:UQiv^d:Wd^^YbUk:ksJv^Q:sWYmQkYOQ: 8 @:::::::5Y N>>Y  Y dEventTypeIDEventTypeIPmtt>@CrYAY.rBPrimaryKeyv1i=Advance SalesCommunication SkillsComputer TrainingLeadership Seminars =???? PY NBBY  Y dY  Y m_( Y Y Y Y Y  Y  (Y  Y  * Y   Y  Y ,EventIDEventNameEventTypeID StatusLocationStartDateEndDateStartTimeEndTime RequiredStaffingConfirmedAvailableSpaces EventDescription NotesEmployeeID_BE__BFી_BG__ BHૉ_ B _YY=Y8YYYYL{27BED747-3C73-4F70-8CD7-0ED740871426}L{78226313-A1AD-4F6C-8E69-DAC43DB9548E}L{F9DB3E5D-2CE6-41B4-9CFA-B4BF4938B180}EmployeeIDEventNameEventTypeIDPrimaryKey BB BB 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.A-`@`@??2Computer Basics for BusinessNorthern Room/@Ckk_PP2Y@@??dSales, Sales, SalesAlgonquin RoomA@CccWGG2Y@@@@??2Negotiating ExcellenceBanff Room?@CbbVJJ2Y@ @??dPublic Speaking SkillsCanada Room>@CccWJJ2Y ADDDD A Md`fomQiLJkYMkSdiLokYbQkkDbQUdmYJmYbUQuMQ^^QbMQDfoL^YMkfQJ\YbUk\Y^^kDkJ^QkkJ^QkkJ^QkD ADDDD ADDDD 1Y%K \NJJYP Y Y  Y JY  Y  Y )7Y5g _DataFileDataFileFlagsFileNameFileTimeStampFileTypeFileURL$MSysResources_Data%TN(*gJMHZL19@JNF$eZO @92JOYYY _Data$IdxFKPrimaryScalar$MSysComplexPKIndexJJJJs 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㑫>>>>>>< @*u=@u=@~sq_cRegistration~sq_cFeeScheduleID4MR2KeepLocal Thhhhhhhf @'=@=@~sq_cPayments~sq_cPaymentMethodID4MR2KeepLocal Tdddddddb @$=@=@~sq_cEvents~sq_cEvents Subform4MR2KeepLocal T^^^^^^^\ @"=@=@~sq_cEvents~sq_cEmployeeID4MR2KeepLocal TVVVVVVVT @ 2=@ 2=@~sq_cAutoEvents~sq_cEmployeeID4MR2KeepLocal T^^^^^^^\ @Slߦ=@Slߦ=@Sales by Event Type@TTTHHHHHHHF @\ئ=@\ئ=@Print Invoice~@HHH<<<<<<<: @yԦ=@yԦ=@Events @:::......., @ 㨨=@&@AccessLayout4MR2KeepLocal T.@zz:::::::8 @u:˦=@\u@Venues@ :::......., @<3̦=@=@Total Registrations by Attendee@ |@xll```````^ @;˦=@Q=@Sum Of Payments Query@ |@dXXLLLLLLLJ @~ɦ=@=@RegistrationOfFFF:::::::8 @Ȧ=@d=@Payments@>>>22222220 @Ǧ=@c=@My Company Information@ZZZNNNNNNNL @Su@p~Su@ MSysResources<<<<<<<<<<: !rR@V?!rR@ MSysNavPaneObjectIDs4MR2KeepLocal  TJJJJJJJH @^!rR@el^!rR@ MSysNavPaneGroupToObjects4MR2KeepLocal  TTTTTTTTR @c[!rR@M$\!rR@ MSysNavPaneGroups4MR2KeepLocal  TDDDDDDDB @RW!rR@~Y!rR@ MSysNavPaneGroupCategories4MR2KeepLocal  TVVVVVVVT @VP"=@P"=@ MSysAccessStorageDDDDDDDDDDB P_Ʀ=@Ja=@Fee Schedules@HHH<<<<<<<: @P c; `Per Person@KLAdditional`SFirst Person @TThird Person `Second Person!pFirst Person  =Third Person  DSecond Person!@KLFirst Person  P @SSSSSSSSS P @SSSSSSSS SV YVNWWSTSTY Y Y  Y  Y Y Y eDateCreateDateUpdateIdLvNameParentIdTypeWWWYYYIdParentIdIdParentIdNameWWv1b @! U ! U'FȪFȪ0V6@c$ o q ( I  ! T  _,7rJo"Gdo<զ=@%=@CG@sTypeInfoA:62" զ=@%=@B2vfBlobA2.*" զ=@%=@A8  wvrզ=@=@?PropData<PLH8 vrզ=@=@>@sTypeInfo<:62" vrզ=@=@=tfBlob<2.*" vrզ=@=@<7  wyԦ=@S=@:PropData7PLH8 yԦ=@S=@9@sTypeInfo7:62" yԦ=@S=@8DnfBlob72.*" yԦ=@S=@76  wӦ=@Y=@5PropData2PLH8 Ӧ=@Y=@4@]TypeInfo2:62" Ӧ=@Y=@3@mBlob22.*" Ӧ=@Y=@25  wӦ=@=@0PropData-PLH8 Ӧ=@=@/@]TypeInfo-:62" Ӧ=@=@. @lBlob-2.*" Ӧ=@=@-4  wӦ=@'#=@+PropData(PLH8 Ӧ=@'#=@*@]TypeInfo(:62" Ӧ=@'#=@)jeBlob(2.*" Ӧ=@'#=@(3  wΈҦ=@h=@&PropData#PLH8 ΈҦ=@h=@%@]TypeInfo#:62" ΈҦ=@h=@$uaeBlob#2.*" ΈҦ=@h=@#2  w ͦ=@9=@!PropDataPLH8  ͦ=@9=@ @]TypeInfo:62"  ͦ=@9=@ ^eBlob2.*"  ͦ=@9=@1  woͦ=@(^Qz.@@]PropData:62" oͦ=@Pz.@@]DirData:62" &q̦=@x=@PropDataPLH8 3̦=@x=@@]TypeInfo:62" 3̦=@x=@):YeBlob2.*" 3̦=@x=@0  w¦=@֘~u@VBA$  w¦=@֘~u@VBAProject2.* w#=@#=@MSysDbDirData PLH8 P"=@P"=@CustomGroups62. wP"=@P"=@ Blob &" wP"=@P"=@ 0   wP"=@#=@ Databases0,( wP"=@P"=@ DataAccessPages<84 wP"=@P"=@ Cmdbars,($ wP"=@I~u@VBA$  wP"=@P"=@Scripts,($ wP"=@=@Modules,($ wP"=@d=@Reports,($ wP"=@Pz.@Forms($  wP"=@~"!rR@jiPropDataPLH8 P"=@P"=@MSysAccessStorage_SCRATCHPLH wP"=@~"!rR@MSysAccessStorage_ROOTJFB wLVALeZ ^02=5B>a)b*ce gh6i j%&k )?l,-@x +jJm4y  U,^> |GʜU=@AttendeesWkRFDoP6/B=@xAttendees Subformw6ټIF|Ж\=@Events;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments QueryhY(Cߘ?b;{XcHV]0WxRegistrationIDƏGҖN1#;{XcHV]0WxRegistrationFeeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total Payments~ 2yH~-;{XcHV]0WxAttendeeID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDq^ĎF#,^> |GʜUAttendeeID1bhΛ Hʆ,^> |GʜUCompanyName%q\Z I4f,^> |GʜUAddress ?&L r,^> |GʜUCityܖnH),^> |GʜUProvince\%:B&߂J,^> |GʜUPostalCode;lR7OY>,^> |GʜUAttendeeFirstNamez) fI%*!b,^> |GʜUAttendeeLastNameNKx:A,^> |GʜUTitlexM4M(>eČ,^> |GʜUPhoneNumbera8D0 O;;],^> |GʜUFaxNumberXɻI",^> |GʜUNotes  Attendees AttendeesW "[Event Procedure] @ Arialp "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`, FormHeaderx 1+slAV`glh1U2R`6Haxb8c,h%i Register &Register...~ "[Event Procedure]" @MS Sans Serifx ,5D0h1U2P`6axbc,h%iLVAL[i Payments &Payments...~ "[Event Procedure]" @MS Sans Serifx Y 9zGUQ\zh1U2V`6 axbc,h%ii PreviewInvoice &Pre&view Invoice...~ "[Event Procedure]" @MS Sans Serifx heO, 9`im847U;C`6@axc,k AttendeeID AttendeeIDx Bt]G5[d5U7`6axbc,d# e%i  AttendeeID Label AttendeeID" @MS Sans Serif  AttendeeID_Labelx ~F<`,  Detailx ԁƴH rZ m47U;`6axb c,e  CompanyName CompanyNamex FWeVH6[Td25U7`6Haxbc,d# e% "CompanyName Label Company Name" @MS Sans Serif "CompanyName_Labelx Mp|@j*#m47U;`6ab c,k Address Addressx [n?B6w<*d25U7`6Habc,d# e% Address Label Address" @MS Sans Serif Address_Labelx QKXGإ`m47U;`6ab c,e k City Cityx r<E d25U7`6Habc,d# e% City Label City" @MS Sans Serif City_Labelx ȜTxF7Fx7m47U;`6ab c,ek StateOrProvince Provincex Gw;KY Md25U7`6HaLVAL\bc,d# e% *StateOrProvince Label Province" @MS Sans Serif *StateOrProvince_Labelx Nw龡JV-m47U;`6ab c,ek PostalCode PostalCodeH 00000\-9999x ٶMC }27d25U7`6Habc,d# e%  PostalCode Label Postal Code" @MS Sans Serif  PostalCode_Labelx p3W`6Ha b`c,od  "Attendees Subform ,Form.Attendees Subform1 AttendeeID2 AttendeeID "Attendees_Subformx Cy7H +zd25]`6Hab c,d# e% .Attendees Subform Label 4Event Registration History" @MS Sans Serif .Attendees_Subform_Labelx BLL|-`, FormFooterx CC,oLVAL H 35ͬtB{8RB uFormHeaderDetailmEventTypeIDd EventTypeID_LabelEventTypeID LabelmEventTyped EventType_LabelEventType LabelFormFooterͬ amʠGy0̙FormHeaderDetailmFeeDescriptiond FeeDescription_LabelFeeDescription LabelmFeed Fee_LabelFee LabelFormFooterFeeScheduleIDEventIDͬdbfyBL}N{FormHeaderDetailmEmployeeIDd EmployeeID_LabelEmployeeID LabelmFirstNamed FirstName_LabelFirstName LabelmLastNamed LastName_LabelLastName LabelmTitled Title_LabelTitle Labelm WorkPhoned WorkPhone_LabelWorkPhone Labelm Extensiond Extension_LabelExtension LabelFormFooterͬ!s{IFqGN;:}h=FormHeaderDetailmEventIDd EventID_LabelmEventNamed EventName_LabeloEventTypeIDd EventTypeID_LabelmStatusd Status_Labelm StartDated StartDate_Labelm EndDated EndDate_LabelmStartTimed StartTime_LabelmEndTimed EndTime_LabelmRequiredStaffingd RequiredStaffing_LabelmConfirmedd Confirmed_LabelmAvailableSpacesd AvailableSpaces_LabelmEventDescriptiond EventDescription_LabelmNotesd Notes_LabeloEmployeeIDd EmployeeID_LabelnLocationd Location_Label FormFooterͬ MPUAKf FormHeaderDetailmEventNamed EventName_LabelEventName LabelmStartDated StartDate_LabelStartDate LabelmSale_AmountSale Amountd Sale_Amount_LabelSale Amount LabelmTotal_PaymentsTotal Paymentsd Total_Payments_LabelTotal Payments Labelm Amount_DueAmount Dued Amount_Due_LabelAmount Due Label FormFooter RegistrationIDRegistrationFeeSalesTaxRateAttendeeID 14CB0 13CB0 12CB0 11CB0 10CB0 9CB0 8CB0 7CB0 6CB0 5CB0 4CB0 3CB0 2CB0 1CB0 0CB0&Report Date RangeRegistration Print Invoice Payments "Payment Methods 0My Company Information Fee Schedules Events SubformEventsEvent Types8Event Fee Schedule SubformEmployeesAutoEvents&Attendees SubformAttendeesͬ# TmrNC.N"FormHeaderh Registerh Paymentsh PreviewInvoicemAttendeeIDd AttendeeID_LabelAttendeeID LabelDetailmCompanyNamed CompanyName_LabelCompanyName Labelm Addressd Address_LabelAddress Labelm Cityd City_LabelCity Labelm StateOrProvinced StateOrProvince_LabelStateOrProvince LabelmPostalCoded PostalCode_LabelPostalCode LabelmAttendeeFirstNamed AttendeeFirstName_LabelAttendeeFirstName LabelmAttendeeLastNamed AttendeeLastName_LabelAttendeeLastName LabelmTitled Title_LabelTitle LabelmPhoneNumberd PhoneNumber_LabelPhoneNumber LabelmFaxNumberd FaxNumber_LabelFaxNumber LabelmNotesd Notes_LabelNotes LabelpAttendees_SubformAttendees Subformd Attendees_Subform_LabelAttendees Subform LabelFormFooter Province!Email"CategoryLVALe_ ^02=5B>a)b*cg h6XiJjAk 9?l/B=@x WkRFDoP6y  Uw6ټIF|Ж\=@Events;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments QueryhY(Cߘ?b;{XcHV]0WxRegistrationIDƏGҖN1#;{XcHV]0WxRegistrationFeeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total Payments~ 2yH~-;{XcHV]0WxAttendeeID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventID`|x$Hw(mWkRFDoP6Sale Amountfl:IJ5G8{zpWkRFDoP6Total 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 r,޵QUFmfA`,  Detailx *o,A@iMm47U;C`6b c,e  EventName EventName "[Event Procedure]x #HA|C9Ad25U7bc,d# e%LVAL` EventName Label Event Name" @MS Sans Serif EventName_Labelx L2]I>m47U;C`6ahb c,eVk StartDate StartDate& Short Date "[Event Procedure]H 99/99/00;0x 8OGUd25U7ahbc,d# e% StartDate Label Start Date" @MS Sans Serif StartDate_Labelx ;:cJmEFhR-m80G47U;C`6ab c,e7k Sale Amount =[RegistrationFee]+CLng((([SalesTaxRate]*[RegistrationFee])*100))/100& *$#,##0.00;($#,##0.00) "[Event Procedure] Sale_Amountx `|x$Hw(md25U7abc,d# e% "Sale Amount Label Sale Amount" @MS Sans Serif "Sale_Amount_Labelx E,\NJf֋\m80G47U;C`6a8b c,e7k Total Payments Total Payments& *$#,##0.00;($#,##0.00) "[Event Procedure] Total_Paymentsx fl:IJ5G8{zpd25U7a8bc,d# e% (Total Payments Label Total Payments" @MS Sans Serif (Total_Payments_Labelx \G cP+m80G47U;C`6ab c,e7k Amount Due F=[Sale Amount]-nz([Total Payments])& *$#,##0.00;($#,##0.00) "[Event Procedure] Amount_Duex ZF d25U7abc,d# e%  Amount Due Label Amount Due" @MLVALS Sans Serif  Amount_Due_Labelx yA7EIW`,@@ FormFooterx nOE.SLVALeb9u08=5B>a)b*ce gh6Yi<j!k ?d f3̙f3f3ffffff3f3333f333f3f3̙f3̙̙̙̙f̙3̙ffffff3f3333f333f3f3̙f3f3ffffff3f3333f333f3ffffff3ffff̙fff3fffffff3ffffffffffff3fff3f3f3f3ff33f3ffffff3f3333f333333̙3f3333333f3333f3f3f3ff3f33f33333333f333333333f333f3̙f3f3ffffff3f3333f333f3 JFX<MU EMFJ  XF%%GDICJ$ xB =  = &_FMRIB_# BC ==(=@ f3f3̙f3fffff3ff333f3333f3f3f3̙f3fffff3ff333f3333f3f3̙̙̙f̙3̙̙̙f3fffff3ff333f3333f3fffff3fffffff3fff̙ffff3fffffffffff3ffff3f3f3ff3f33f3ffffff3ff333f3333333f33333̙33f3333f3f3f3ff33f3f3333333f3333333333f3333f3f3̙f3fffff3ff333f3333f3+++++++++++LVALc+++++++++++++++++++++++++++++++++++++++++++LVALd+++++++++++++++++++++++++++++++++++++  = = =   = Q$<=P(x@ =(=@ f3f3̙f3fffff3ff333f3333f3f3f3̙f3fffff3ff333f3333f3f3̙̙̙f̙3̙̙̙f3fffff3ff333f3333f3fffff3fffffff3fff̙ffff3fffffffffff3ffff3f3f3ff3f33f3ffffff3ff333f3333333f33333̙33f3333f3f3f3ff33f3f3333333f3333333333f3333f3f3̙f3fffff3ff333f3333f3LVALe+++++++++++++++++++++++++++++++++++++++++++LVALf++++++++++++++++++++++++++++++++++++++++++++++LVALg++Kl{2@x Y_4}ҦDRy ^ Uw6ټIF|Ж\=@EventsPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventName&PJZdw6ټIF|ЖEventTypeIDCCFwN*"c\7O=@Event TypesNR@X*9CCFwN*"c\7OEventType:7Jjq"w6ټIF|ЖStatus`b=MP]w6ټIF|ЖStartDate& Gbfw6ټIF|ЖEndDatetʷ6\oIߕa w6ټIF|ЖStartTime&%kF.w6ټIF|ЖEndTimeG(jD Ww6ټIF|ЖRequiredStaffinghuC_MB> w6ټIF|ЖConfirmed:a㪨Dkw6ټIF|ЖAvailableSpacesmg\A>Pkpw6ټIF|ЖEventDescriptionGM*#L#'j6w6ټIF|ЖNotes.^` KKa-w6ټIF|ЖEmployeeID;yJ AaJ=@EmployeesCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstName %/NiBщw6ټIF|ЖLocationcA ȤTH|C=@Venues   Events  Events @ Arialdd# e%3" @ Ariale23f2 4 3hg# 3" @ Ariali6 g4h53j6 g4h53k3l3mfi# 3" @ Arialnj# 3" @ Arialol# 3" @ Arialp3r45I3zi#j%" @MS Sans Serif`, FormHeaderx e #K(xU`,  Detailx WL3IͶ3]m7WF{`6axc,e EventID EventIDx aHLdd5]`6<axbtc, EventID_Label Event IDx E1O+XS$Mm7WF{`6ab c,e k EventName EventNamex lAMU˅_d5]`6<abtc, EventName_Label Event Namex ݿ9DB.&oC5WD{`Fb@ c6dHe fLVALh,h nZ ,"";"";"";"";"10";"100"x ^%OQ X} EventTypeID EventTypeID] Table/Query[ SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType;   0;2880Y $"SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType; ";"Event Types";"";"EventTypeID";"EventType";"PrimaryKey"d5]`6<aHbtc, "EventTypeID_Label Event Type IDx GrH%T; L8b:m7WF{`6abc,ek  Status  Statusx &fLFrl d5]`6<abtc, Status_Label  Statusx d)7 6BL$ӎm7WF{`6apb c,e k StartDate StartDate& Short DateH 99/99/00;0x \ t=A ix2d5]`6<apbtc, StartDate_Label Start Datex 0`hJ3CSEej9m7WF{`6a b c,e k EndDate EndDate& Short DateH 99/99/00;0x F<%F~H6zd5]`6<a btc, EndDate_Label End Datex w.O3lN󚏃ۜm7WF{`6a@ bc,ek StartTime StartTime& Medium TimeH 09:00\ >LL;0x .g2OG;;aouCd5]`6<a@ btc, StartTime_Label Start Timex 4gJ&F4b'xm7WF{`6a bc,ek EndTime EndTime& Medium TimeH 09:00\ >LL;0x H}V>kM5ո6<a btc, EndTime_Label End Timex A|M$m7WF{`6abc,ek   RequiredStaffing  RequiredStaffingx {WdJ9LVALir9d5]`6<abtc, ,RequiredStaffing_Label "Required Staffingx vN5#@JXr欦m7WF{`6(axbGc,eGk  Confirmed Confirmed&  Yes/Nox (+-_K"Ȩnd5]`6axbtc, Confirmed_Label Confirmedx []|JpB~m7WF{`6(abc,ek  AvailableSpaces AvailableSpacesx ̺ &@LS]ud5]`6abtc, *AvailableSpaces_Label  Available Spacesx >E0Bs,K{rx&Cm J27WF{`6(aHb c,e k   EventDescription  EventDescriptionx .*Jܪd5]`6aHbtc, ,EventDescription_Label Descriptionx BċCM[m J27WF{`6(ab c,e k   Notes  Notesx kN(&F3Byd5]`6abtc, Notes_Label  Notesx UD|'r oC5WD{`Fb@ c6(d e f,h nZ ("";"";"";"";"10";"0"x )R1xF(TJ EmployeeID EmployeeID] Table/Query[ SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];   0;2880Y ~"SELECT [EmployeeID], [LastName] & "", "" & [FirstName] FROM Employees ORDER BY [LastName] & "", "" & [FirstName]; ";"Employees";"";"EmployeeID";"LastName] & "", "" & [FirstName";"PrimaryKey"d5]`6a btc,  EmployeeID_Label Employee IDx }˂BLuo8n3WA{a6bc d,l Location Location] Table/Query[  Venuesx ͨAJ3d5]`6LVAL<abtc, Location_Label Locationx ӭCOw6&v`, FormFooterx 㧔&IRV^uLVALek ^02=5B>a)b*ce gh6M ijk [?l0e/-@x PzN LPLy  U;yJ AaJ=@EmployeesT%B~>O;yJ AaJEmployeeIDjz@&p;yJ AaJFirstNameCDn 5A ދ;yJ AaJLastNameAN[BA|9;yJ AaJTitle!KQGn;yJ AaJWorkPhoneg1R7|Iw&2 ;yJ AaJExtension  Employees Employees @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx u8BE6h`,N   Detailx S9AS$(kkm847U;C`68ahbc,e EmployeeID EmployeeIDx 7nH!A} d25U7`6ahbc,d# e%  EmployeeID Label Employee ID" @MS Sans Serif  EmployeeID_Labelx NgnHwDyU-m47U;C`68abc,e k FirstName FirstNamex  bZAG(Zd25U7`6abc,d# e% FirstName Label First Name" @MS Sans Serif FirstName_Labelx yCM4){HO %m47U;C`68a8bc,e k ULVALeLastName LastNamex  ȠJG!tvd25U7`6a8bc,d# e% LastName Label Last Name" @MS Sans Serif LastName_Labelx [e7cM@7H:C7#m47U;C`68abc,e k  Title  Titlex ߡB+|Utd25U7`6abc,d# e% Title Label  Title" @MS Sans Serif Title_Labelx 1IzDQ\m47U;C`68abc,e k WorkPhone WorkPhoneH $000\-000\-0000;0;_x dI畽 Od25U7`6abc,d# e% WorkPhone Label Work Phone" @MS Sans Serif WorkPhone_Labelx ߥUGR|m47U;C`68apbc,e k Extension Extensionx e69Hh':Vd25U7`6apbc,d# e% Extension Label Extension" @MS Sans Serif Extension_Labelx FAticJ`,@@ FormFooterx p$^C fFbLVALr 0CB0 1CB0 2CB0 3CB0 4CB0 5CB0 6CB0 7CB0 8CB0 9CB0 10CB0 11CB0 12CB0 13CB0 14CB0 15CB0$Attendee ListingInvoice&Sales by Employee*Sales by Event Type ^02=5B>a)b*cgh6XiJjAk ?l܅,@x ]|DAy  UR?MHKTeJa=@Fee Schedules}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFee  Fee Schedules  Eventsd27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx YZ&FVtKz_`,  Detailx t{&uF%SoOsm47U;C`6b c,e  FeeDescription FeeDescriptionx .^/:iM%P0{jd25U7bc,d# e% (FeeDescription Label Fee Description" @MS Sans Serif (FeeDescription_Labelx _h1#[Q@94[m0G47U;C`6ahb c,e7k Fee Fee& *$#,##0.00;($#,##0.00)x WlLFK|kLNd25U7ahbc,d# e% Fee Label Fee" @MS Sans Serif Fee_Labelx h6&KE`,@@ FormFooterx ޳M{Aӹ ALVALQ ^02=5B>a)b*ce gh6XiJjk ?l0e/-@x ZU \IQшy  UCCFwN*"c\7O=@Event TypesJKUa{CCFwN*"c\7OEventTypeIDNR@X*9CCFwN*"c\7OEventType  Event Types Event Types @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx F 1M$`,F  Detailx EVŔL wrFm847U;C`68ahbc,e EventTypeID EventTypeIDx %pٓ@ͨTd25U7`6ahbc,d# e% "EventTypeID Label Event Type ID" @MS Sans Serif "EventTypeID_Labelx  T=Ebm47U;C`68abc,e k EventType EventTypex E"NOGud25U7`6abc,d# e% EventType Label Event Type" @MS Sans Serif EventType_Labelx nBc1`,@@ FormFooterx &Eܕ$3{LVALfo ^02=5B>a)b*c e gh6XiJjA(k R?lO#--@x da KӅ=:y  Uw6ټIF|Ж\=@Events]|DA=@ Event Fee Schedule SubformR?MHKTeJa=@ Fee Schedules>&I 2R?MHKTeEventIDPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventNamemg\A>Pkpw6ټIF|ЖEventDescription %/NiBщw6ټIF|ЖLocation&PJZdw6ټIF|ЖEventTypeIDCCFwN*"c\7O=@Event TypesNR@X*9CCFwN*"c\7OEventType.^` KKa-w6ټIF|ЖEmployeeID;yJ AaJ=@EmployeesCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstName:7Jjq"w6ټIF|ЖStatus`b=MP]w6ټIF|ЖStartDate& Gbfw6ټIF|ЖEndDatetʷ6\oIߕa w6ټIF|ЖStartTime&%kF.w6ټIF|ЖEndTime:a㪨Dkw6ټIF|ЖAvailableSpaces&U0~BQNNDda KӅ=:AvailableSpaces'LjFṅZՕda KӅ=:Events Subform0wWD9{2|.C=@>E0Events Subform,^> |GʜU=@Attendees;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments Query( 4B$D;{XcHV]0WxEventID~ 2yH~-;{XcHV]0WxAttendeeIDz) fI%*!b,^> |GʜUAttendeeLastName;lR7OY>,^> |GʜUAttendeeFirstName1bhΛ Hʆ,^> |GʜUCompanyNameƏGҖN1#;{XcHV]0WxRegistrationFeemqcH- X6Aqr^Total PaymentshY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDq^ĎF#,^> |GʜUAttendeeID   Events  Events @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,LVALp FormHeaderx |*vL<;h,h1U2V`6axbc,h%i Toggle View $&View Fee Schedule~ "[Event Procedure]" @MS Sans Serif Toggle_Viewx ŽJ Or`,  Detailx ᒧ&mEiCDm47U;`6Pa<b c,e  EventName EventNamex ,pDO{Tzsd25U7`6Ta<blc,d# e% EventName Label Event Name" @MS Sans Serif EventName_Labelx ’O>$@m47U;`6Pahb c,k  EventDescription  EventDescriptionx O>3zFyـMd25U7`6Tahblc,d# e% ,EventDescription Label "Event Description" @MS Sans Serif ,EventDescription_Labelx 6O6DJR࡭ym47U;`6Pab c,k Location Locationx l٣iF7֌[d25U7`6Tablc,d# e% Location Label Location" @MS Sans Serif Location_Labelx oIEf(-oC25U9`Fb@ c6Pde f,h nZ ,"";"";"";"";"10";"100"x i?_@Tl 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`6TaLVALqblc,d# e% "EventTypeID Label Event Type" @MS Sans Serif "EventTypeID_Labelx (MM*3GoC25U9`Fb@ c6Pde f,h nZ ("";"";"";"";"10";"0"x N>ý9N9G 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 xqZE'fm47U;`6Pab c,ek  Status  Statusx ? Oyߌ\d25U7`6Tablc,d# e% Status Label  Status" @MS Sans Serif Status_Labelx h-߫M~gm47U;`6a<bc,k StartDate StartDate& Short DateH 99/99/00;0x   G)Fd25U7`6a<bc,d# e% StartDate Label Start Date" @MS Sans Serif StartDate_Labelx  Aل9m47U;`6ahbc,k EndDate EndDate& Short DateH 99/99/00;0x 3Hnfd25U7`6ahbc,LVALrd# e% EndDate Label End Date" @MS Sans Serif EndDate_Labelx 7G͇M+ m47U;`6abc,k StartTime StartTime& Medium TimeH 09:00\ >LL;0x zۿEy/Vd25U7`6abc,d# e% StartTime Label Start Time" @MS Sans Serif StartTime_Labelx ;pЍUD~>km47U;`6abc,k  EndTime EndTime& Medium TimeH 09:00\ >LL;0x U[u"WDad25U7`6abc,d# e% EndTime Label End Time" @MS Sans Serif EndTime_Labelx 4,PRG% am47U;`6abc,k  AvailableSpaces AvailableSpacesx &U0~BQNNDd25U7`6abc,d# e% *AvailableSpaces Label  Available Spaces" @MS Sans Serif *AvailableSpaces_Labelx q]!M 4Om80G47U;`6abc,k   Spaces Remaining =[AvailableSpaces]-IIf([Events Subform].Form.RecordsetClone.RecordCount=0,0,[Events Subform].Form![Total Attendees])&  Fixed  Spaces_Remainingx 0 |'JI d25U7`6abc,d# e% ,Spaces Remaining Label  Spaces Remaining" @MS Sans Serif ,Spaces_Remaining_Labelx ZLeOAv p3_`6Hao bc,od  4Event Fee Schedule Subform >Form.Event Fee S LVAL chedule Subform1 EventID2 EventID 4Event_Fee_Schedule_Subformx <QDK杀jd5]`6Hapb7c, @Event Fee Schedule Subform Label Fee Schedules: @Event_Fee_Schedule_Subform_Labelx sߗMCs!dVp3`6Hao b}c,od  Events Subform &Form.Events Subform1 EventID2 EventID Events_Subformx 'LjFṅZՕd5`6Hapbc, (Events Subform Label Attendees: (Events_Subform_Labelx I/@` ?`,@@ FormFooterx D Ki])4[LVALZ L l3ͬe M";iFormHeaderDetailmRegistrationIDd 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ͬ @᱕ OH lFormHeaderDetailmPaymentMethodIDd PaymentMethodID_LabelPaymentMethodID LabelmPaymentMethodd PaymentMethod_LabelPaymentMethod LabeljCreditCardd CreditCard_LabelCreditCard LabelFormFooterͬeccOμ /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ͬ */QH`8FormHeaderDetailmFeeScheduleIDd FeeScheduleID_LabelFeeScheduleID LabeloEventIDd EventID_LabelEventID LabelmFeeDescriptiond FeeDescription_LabelFeeDescription LabelmFeed Fee_LabelFee Label FormFooterͬ,@FLɉ>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ͬ$\3IWFormHeaderh 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#NotesLVALfu ^02=5B>a)b*cg h6ij>+k R?l\=@x 0wWD9{2|.y  U,^> |GʜU=@Attendees;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments Query( 4B$D;{XcHV]0WxEventID~ 2yH~-;{XcHV]0WxAttendeeIDz) fI%*!b,^> |GʜUAttendeeLastName;lR7OY>,^> |GʜUAttendeeFirstName1bhΛ Hʆ,^> |GʜUCompanyNameƏGҖN1#;{XcHV]0WxRegistrationFeemqcH- X6Aqr^Total PaymentshY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDq^ĎF#,^> |GʜUAttendeeIDx|6Gz,|OAttendee 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 R;KSqls$m847U;C`6a<bc,i Total Attendees (=Count([AttendeeID]) Total_Attendeesx 1p ycO 5Jrd5U7`6<a<LVAL!bc,e%i *Total Attendees Label Total Attendees *Total_Attendees_Labelx 쉰^Jt(S`,  Detailx -VBmltm847U;C`6b c,e  Attendee Attendee Namex q_(1TE续nOEd25U7bc,d# e% Attendee Label Attendee" @MS Sans Serif Attendee_Labelx Ѧ!iC 9'Pm47U;C`6ahb c,e k CompanyName CompanyNamex VA`_ˆK\Vd25U7ahbc,d# e% "CompanyName Label Company Name" @MS Sans Serif "CompanyName_Labelx cIKm0G47U;C`6ab c,ek RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x jnyFpIj["d25U7abc,d# e% *RegistrationFee Label  Registration Fee" @MS Sans Serif *RegistrationFee_Labelx -Q4 Miu2m80G47U;C`6a8b c,e6k Total Payments Total Payments& *$#,##0.00;($#,##0.00) Total_Paymentsx t4FhEx8\d25U7a8bc,d# e% (Total Payments Label Total Payments" @MS Sans Serif (Total_Payments_Labelx ,` @%T`,@@ FormFooterx :),ڑVN~-LVALfw ^02=5B>a)b*ce gh6XiJjk e?l/-@x '&M(m4D8y  UR?MHKTeJa=@Fee Schedules/!'a@CR?MHKTeFeeScheduleID>&I 2R?MHKTeEventIDw6ټIF|Ж\=@EventsDd@)FjKNw6ټIF|ЖEventName}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFee  Fee Schedules Fee Schedules @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx JOՁRNaEBl`,  Detailx K pBj}gjm847U;C`68ahb$ c,e FeeScheduleID FeeScheduleIDx wSAbuq͙)d25U7`6ahbc,d# e% &FeeScheduleID Label Fee Schedule ID" @MS Sans Serif &FeeScheduleID_Labelx ZטLJUaiVoC25U9A`Fb@ c68de f,h nZ ,"";"";"";"";"10";"100"x |S HJ*n< 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 kBТBm47U;C`68a8b c,e k FeeDescription FeeDescriptionx I˾E TNd25U7`6a8bc,d# e% (FeeDescription Label Fee Description" @MS Sans Serif (FeeDescription_Labelx Gp ^$F029 =5B>CJa)b*c0!e gh6Fij/+k !?l-,@x =.~t=AE?y H UcX1ETAaGiLc=@My Company Informationz4HS! -4cX1ETAaGiLCompanyName.N?DKF dGcX1ETAaGiLAddressUh޷'N`T,cX1ETAaGiLCityĥ E9IFfcX1ETAaGiLProvincet-GVFH_[CcX1ETAaGiLPostalCodebrbG|[cX1ETAaGiLCountryND{2tLS#A!cX1ETAaGiLPhoneNumberd'|LLcX1ETAaGiLFaxNumbercU O q`cX1ETAaGiLSalesTaxRateےH_Z*`cX1ETAaGiLDefaultPaymentTermsXEwBÏ.cX1ETAaGiLDefaultInvoiceDescription  ,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 =[1wN`,  Detailx OBY.K d5U`6abc, Info Enter your company's name and address information here. You will save the information by closing the form.x c F }x: m7U`6Pab c,e  CompanyName CompanyNamex  =4AONd5U`6abc, "CompanyName Label Company Name "CompanyName_Labelx #|&55G$ Sm7U`6Pab c,k Address Addressx 0[^E&iJ6R<㩾d5U`6abc,LVAL{ Address Label Address Address_Labelx *ⰨJig$m7U`6PaDb c,e k City Cityx :nqpH\#d5U`6aDbc, City Label City City_Labelx dC8;m7U`6Pab c,ek StateOrProvince Provincex p }Hb': 9Ud5U`6ab9c, *StateOrProvince Label Province *StateOrProvince_Labelx ` uCNkaDm7U`6Pa b c,ek PostalCode PostalCodeH >L0L\ 0L0x rϊtOTaJ1Nd5U`6a bGc,  PostalCode Label Postal Code  PostalCode_Labelx N:خ`7NvHãm7U`6Pa| b c,e k Country Countryx ohO$ld5U`6a| bc, Country Label Country Country_Labelx 8?hAczcWm7U`6Pa b c,e k PhoneNumber PhoneNumberH ,!\(999") "000\-0000;;_x ZmIʌLS<d5U`6a b7c, "PhoneNumber Label Phone Number "PhoneNumber_Labelx X] Nfm7U`6PaLb c,e k FaxNumber FaxNumberH ,!\(999") "000\-0000;;_x toB{d5U`6aLbGc, FaxNumber Label Fax Number FaxNumber_Labelx @m5lA"m7U`60abc,k SalesTaxRate SalesTaxRate& Percentx wPgJȵ&d5U`6sabFc, $SalesTaxRate Label Sales Tax Rate $SalesTaxRate_Labelx UCEZNL7m7U`60a LVAL bc,k  &DefaultPaymentTerms &DefaultPaymentTermsx XLNLaJO|+Md5U`6sabc, 2DefaultPaymentTerms Label Payment Terms 2DefaultPaymentTerms_Labelx BHAl m7U`60aTbc,k  2DefaultInvoiceDescription 2DefaultInvoiceDescriptionx D.2JRPlk?d5U`6saTbc, >DefaultInvoiceDescription Label Invoice Descr >DefaultInvoiceDescription_Labelx *$C$Z`,@@ FormFooterx 8y3K:>-LVALf} ^02=5B>a)b*ce gh6M ijk ! ?l[G.-@x G5iDۺ&mty @ U`58A0=@Payment MethodsV#=@mbc`58APaymentMethodIDN>.Clx$`58APaymentMethodje7;4K5rۍ`58ACreditCard  Payment Methods Payment Methods @ Arial "[Event Procedure]d27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx T 0E+YU`,  Detailx <ĠBVv:m847U;C`68ahbc,e PaymentMethodID PaymentMethodIDx bM9HDw'ҽd25U7`6ahbc,d# e% *PaymentMethodID Label Pymt Method ID" @MS Sans Serif *PaymentMethodID_Labelx K K˴ fm47U;C`68abc,e k PaymentMethod PaymentMethodx T@?CAQd25U7`6abc,d# e% &PaymentMethod Label Payment Method" @MS Sans Serif &PaymentMethod_Labelx  OtKB&"j12U`68a8i CreditCard CreditCardx "XCVfNd2 LVAL 5U7`6a8bc,d# e%  CreditCard Label Credit Card?" @MS Sans Serif  CreditCard_Labelx NFKIfHdi`,@@ FormFooterx ǧFB LVALf ^02=5B>a)b*c(e gh6XiJjk R?l=@x >儊H2DQq0@y  UQ4d&Jd=@Payments+mnC,Q4d&JRegistrationID+jJm4r=@AttendeesCy7H +z+jJm4Attendees SubformPaymentMethodID`58A0=@Payment MethodsN>.Clx$`58APaymentMethodPaymentDatePaymentAmountCardholdersNameCreditCardNumberCreditCardExpDateCreditCardAuthorizationNumber  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 jؐ=I; 4<`,  Detailx p)}EJ%Wxc1 m847U;C`6ahb c,e RegistrationID RegistrationID x=forms![Attendees]![Attendees Subform].form![RegistrationID]x ~rTJcL1Dd25U7`6ahbc,d# e% (RegistrationID Label Registration ID" @MS Sans Serif (RegistrationILVALD_Labelx TF:m847U;C`6ab c,e k Event Name f=forms!Attendees![Attendees Subform].form!EventName Event_Namex ͞EVt@4Ќ[?d25U7`6abc,d# e%  Event Name Label Event Name" @MS Sans Serif  Event_Name_Labelx Ɉo4JB0 ,oC25U9A`Fbc6d8e f,h nZ 8"";"";"";"";"";"";"10";"100"x 7=tHa p PaymentMethodID PaymentMethodID] Table/Query[ SELECT DISTINCTROW [Payment Methods].* FROM [Payment Methods] ORDER BY [Payment Methods].PaymentMethod;  0;1440;0V "[Event Procedure] "[Event Procedure]x "[Event Procedure]Y \"SELECT DISTINCTROW [Payment Methods].* FROM [Payment Methods] ORDER BY [Payment Methods].PaymentMethod; ";"Payment Methods";"";"PaymentMethodID";"PaymentMethod";"PrimaryKey"d25U7`6a8bc,d# e% *PaymentMethodID Label Payment Method" @MS Sans Serif *PaymentMethodID_Labelx JCgOzJim47U;C`6ab c,eVk PaymentDate PaymentDate& Short DateH 99/99/00;0x WGOHRXid25U7`6abc,d# e% "PaymentDate Label Payment Date" @MS Sans Serif "PaymentDate_Labelx KQZ?AB%lޚm0G47U;C`6ab c,e7k PaymentAmount PaymentAmount& *$#,##0.00;($#,##0.00)x cq_JT|E3d2LVAL5U7`6abc,d# e% &PaymentAmount Label Payment Amount" @MS Sans Serif &PaymentAmount_Labelx ybHe_Vm47U;C`6apb c,e k CardholdersName CardholdersNamex uہ|B E'o>d25U7`6apbc,d# e% *CardholdersName Label Cardholder Name" @MS Sans Serif *CardholdersName_Labelx [zaEPt[~m47U;C`6a b c,e k  CreditCardNumber  CreditCardNumberx KgCf>Md25U7`6a bc,d# e% ,CreditCardNumber Label Credit Card #" @MS Sans Serif ,CreditCardNumber_Labelx :V-D-DkQm47U;C`6a@ b c,eVk "CreditCardExpDate "CreditCardExpDate& Short DateH 99/99/00;0x MK=6|֟d25U7`6a@ bc,d# e% .CreditCardExpDate Label Card Exp. Date" @MS Sans Serif .CreditCardExpDate_Labelx LAk#h~m47U;C`6a b c,e k :CreditCardAuthorizationNumber :CreditCardAuthorizationNumberx OY hM{:d25U7`6a bc,d# e% FCreditCardAuthorizationNumber Label CC Authoriz. #" @MS Sans Serif FCreditCardAuthorizationNumber_Labelx C2vEFeAm`,@@ FormFooterx hsLELVALLVAL fZ> ^029 =5B>a)b*c,e g h6 ij+ k ?l.-@x G0]9OMIb<y . U  Print Invoice @ Ariald27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx xkkdsJlQW`,   Detailx #NHn km847U;C`68ab c,e Registration ID x=Forms![Attendees]![Attendees Subform].form![RegistrationID] Registration_IDx q5'BoEd25U7`6abc,d# e% *Registration ID Label Registration ID" @MS Sans Serif *Registration_ID_Labelx ]RGEzTjm847U;C`68ab c,eVk Invoice Date& Short Date =Date()H 99/99/00 Invoice_Datex %|FOh9cGld25U7`6abc,d# e% $Invoice Date Label Invoice Date" @MS Sans Serif $Invoice_Date_Labelx J[?NfAӖm80G47U;C`68ab c,e7kLVAL& Invoice Amount& *$#,##0.00;($#,##0.00) p=Forms![Attendees]![Attendees Subform].form![Amount Due] Invoice_Amountx wXL!Tըd25U7`6abc,d# e% (Invoice Amount Label Invoice Amount" @MS Sans Serif (Invoice_Amount_Labelx ިs8EvMm47U;C`68ab c,k &Invoice Description =Dlookup("[DefaultInvoiceDescription]","My Company Information") &Invoice_Descriptionx g^H͡B]Td25U7`6abc,d# e% 2Invoice Description Label Invoice Descr" @MS Sans Serif 2Invoice_Description_Labelx L-M?@_+m47U;C`68aDb c,k Payment Terms t=Dlookup("[DefaultPaymentTerms]","My Company Information") Payment_Termsx NH44u2d25U7`6aDbc,d# e% &Payment Terms Label Payment Terms" @MS Sans Serif &Payment_Terms_Labelx xGM#˄h1U`6a bc,h%ii OK OK~ "[Event Procedure]" @MS Sans Serifx [OvLϹh1U`6a bc,h%ii  Cancel  Cancel~ "[Event Procedure]" @MS Sans Serifx MS'Hv`,@@ FormFooterx 8,HkBMc- L3LVAL 8 Iͬ"w[B%0vnReportHeaderdLabel14PageHeaderdAttendee_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/ProvincemPhoneNumbermFaxNumbermAttendedPageFootermText15mText16ReportFooterAttendeeIDAttendeeFirstNameAttendeeLastNameTitleAddressCityProvincePostalCodeEmailCategory Notes!Total Registrationsͬ f$L FormHeaderDetailmBeginnining_Registration_DateBeginnining Registration Dated Beginnining_Registration_Date_LabelBeginnining Registration Date LabelmEnding_Registration_DateEnding Registration Dated Ending_Registration_Date_LabelEnding Registration Date Labelh PreviewFormFooterͬ!E1cBR\LFormHeaderDetailmAttendeeIDd 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ͬ(F.>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 CancelFormFooterLVAL f ^02=5B>a)b*c`e gh6XiJj'k R?{ "[Event Procedure]l|=@x  ExeIkfy  U;{XcHV]0Wx=@Registration~ 2yH~-;{XcHV]0WxAttendeeID+jJm4r=@AttendeesBt]G5[+jJm4AttendeeID,^> |GʜU=@Attendeesq^ĎF#,^> |GʜUAttendeeIDRegistrationIDRegistrationDateEmployeeID;yJ AaJ=@EmployeesT%B~>O;yJ AaJEmployeeIDCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNamePurchaseOrderNumberEventIDw6ټIF|Ж\=@EventsPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventName:a㪨Dkw6ټIF|ЖAvailableSpacesFeeScheduleIDR?MHKTeJa=@Fee Schedules>&I 2R?MHKTeEventIDRegistration/!'a@CR?MHKTeFeeScheduleID}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFeeRegistrationFee Aaw= ExeIkfEventIDSalesTaxRateB욼M_VӷQ ExeIkfSalesTaxRateȧxyBM+=Z ExeIkfRegistrationFee&B#՚ ExeIkfSales TaxDS^EC)H ExeIkfRegistrationID%ƒBHMSD ExeIkfTotal ChargesD>FKb ҅ ExeIkfTotal 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 JtfA`A`,   Detailx ; GQ m847];C`6ab4c, AttendeeID AttendeeID >=forms![Attendees]![AttendeeID]x ئsJk`d25]7`6abc,d# e%  AttendeeID Label AttendeeID" @MS Sans Serif  AttendeeID_Labelx f ֗b.Ay; m847;C`6abc,k RegistrationID RegistrationIDx DS^EC)Hd257`6abc,d# e% (RegistrationID Label Registration ID" @MS Sans Serif (RegistrationID_Labelx 3bMO>V m47U;C`6abc,k  RegistrationDate  RegistrationDate& Short Date =Date()H 99/99/00;0x Q3Nǯd25U7`6abc,d# e% ,RegistrationDate Label "Registration Date" @MS Sans Serif ,RegistrationDate_Labelx OtDS~m847U;C`6ab c,e k Attendee =Forms!Attendees!AttendeeFirstName & " " & Forms!Attendees!AttendeeLastNamex ƒ*JB%+ެd25U7`6abc,d# e% Attendee Label Attendee" @MS Sans Serif Attendee_Labelx 3ROD@ 6LVAL@oC25U9A`Fb@ c6de f,h nZ ("";"";"";"";"10";"0"x !9QcNAn 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 !gK 5m47U;C`6aTb c,e k &PurchaseOrderNumber &PurchaseOrderNumberx H /\~C#^_'d25U7`6aTbc,d# e% 2PurchaseOrderNumber Label PO Number" @MS Sans Serif 2PurchaseOrderNumber_Labelx W$3NHWSCoC25U9A`Fb@ c6de f,h nZ 8"";"";"";"";"";"";"10";"100"x  Aaw= 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% LVALEventID Label  Event" @MS Sans Serif EventID_Labelx  UEJtvo25U9A`Fb@ c6d$ e f,h nZ 6"";"";"";"";"";"";"10";"60"x  XI5 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 dOaJ"m0G47U;C`6a b c,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x ȧxyBM+=Zd25U7`6a bc,d# e% *RegistrationFee Label  Registration Fee" @MS Sans Serif *RegistrationFee_Labelx đAMhm847U;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 z0WʎdGj4QPkd25U7`6a bc,d# e% *Remaining Seats Label Remaining Seats" @MS Sans Serif *Remaining_Seats_Labelx ^nސ<@1ЩEbm47U;C`6ab@c,k  SalesTaxRate SalesTaxRateLVAL& Percent f=Dlookup("[SalesTaxRate]","My Company Information")x B욼M_VӷQd25U7`6abc,d# e% $SalesTaxRate Label Sales Tax Rate" @MS Sans Serif $SalesTaxRate_Labelx 2 :z(FG#m80G47U;C`6ab@c,k  Sales Tax n=CLng((([SalesTaxRate]*nz([RegistrationFee]))*100))/100& *$#,##0.00;($#,##0.00) Sales_Taxx &B#՚d25U7`6abc,d# e% Sales Tax Label Sales Tax" @MS Sans Serif Sales_Tax_Labelx )N#O7Om80G47U;C`6ab@c,k  Total Charges <=[RegistrationFee]+[Sales Tax]& *$#,##0.00;($#,##0.00) Total_Chargesx %ƒBHMSDd25U7`6abc,d# e% &Total Charges Label Total Charges" @MS Sans Serif &Total_Charges_Labelx ͎`~;oIvnbm80G47U;C`6ab@c,k  Total Paid =IIf(isnull([RegistrationID]),0,Dsum("[PaymentAmount]","Payments","[RegistrationID]=" & [RegistrationID]))& *$#,##0.00;($#,##0.00) Total_Paidx D>FKb ҅d25U7`6abc,d# e%  Total Paid Label Total Paid" @MS Sans Serif  Total_Paid_Labelx @ O @jlq5m80G47U;C`6aTb@c,k Amount Due B=[Total Charges]-nz( LVAL' [Total Paid])& *$#,##0.00;($#,##0.00) Amount_Duex _N ^029 =5B>a)b*ce gh6 ijk ?l/-@x ;7ڴ GفK3Ry . U  "Report Date RangeM "[Event Procedure] @ Ariald27e%" @ Ariale1f5g123I75hg#" @ Ariali1g4h5j16 g4h5k1l23I:m4" @ Arialn2" @ Arialo2" @ Arialpzi#" @ Arial{5e%" @ Arial`,@@ FormHeaderx L rLMAd f`,  Detailx x]%LPv um47U;C`6abVc,eV :Beginnining Registration Date& Short DateH 99/99/00 :Beginnining_Registration_Datex ^3aLTd25U7`6abcc,d# e% FBeginnining Registration Date Label  Begin. Reg. Date" @MS Sans Serif FBeginnining_Registration_Date_Labelx E`KlIm47U;C`6abVc,eVk 0Ending Registration Date& Short DateH 99/99/00 0Ending_Registration_Datex ikUFFF?6d25U7`6abcc,d# e% <Ending Registration Date Label  Ending Reg. Date" @MS Sans Serif <Ending_Registration_Date_Labelx -S JWh1U2V`6@ atbc,h%iLVALi Preview Pre&view...~ "[Event Procedure]" @MS Sans Serifx B_p*KN8zC`,@@ FormFooterx %*ސ?K60g6LVAL0f ^0:<=5B>a)b*c2e gh6ij0*k ?y "[Event Procedure]l=@x ,J[#BBfSiPy \ U,^> |GʜU=@Attendees1, A-Y [=@Total Registrations by Attendee@Ca11, A-Y [Total Registrationsq^ĎF#,^> |GʜUAttendeeID~ 2yH~-1, A-Y [AttendeeIDz) fI%*!bAttendeeLastName;lR7OY>AttendeeFirstName1bhΛ HʆCompanyName ?&L rCityܖnH)ProvincexM4M(>eČPhoneNumbera8D0 O;;]FaxNumber  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 A{C:Jw$Yo7d28`6Ha<bm c,d#e% Label14  Attendee Listing" @Times New Romanx %2aN6#^`, PageHeaderx \:x bN *!:d`6Ha<bpc,d# e% &Attendee Name Label Attendee Name  DetachedLabel &Attendee_Name_Labelx Ǯ,FUIJ΅id`6 a<bpc,d# e% "CompanyName Label Company Name  DetachedLabel "CompanyName_Labelx FR?mM_g/d`6a<bpc,d# e% 2City/State/Province Label &City/State/Province  DetachedLabel 2City_State_Province_Labelx ~BBZDmd`6pa<bpc,d# e% "PhoneNumber Label Phone Number  DetachedLabel "PhoneNumber_Labelx ?,DTjolvd`6(#a<bpc,d# e% FaxNumber Label Fax Number  DetachedLabel FaLVALxNumber_Labelx 1*g SA&RpZd7`6+a<bxc,d# e% Attended Label Registrations  DetachedLabel Attended_Labelx l5FAD'f2 `6Hb2  Line1x `6Jq dBf2 `6Hab2  Line2x bN{K`,h  Detailx iMhƩm`6Hbpc,, Attendee Name `=[AttendeeLastName] & ", " & [AttendeeFirstName] Attendee_Namex 8%OQm`6 bpc,,k CompanyName CompanyNamex !FM҂>dSm`6bpc,,k &City/State/Province 6=[City] & ", " & [Province] &City_State_Provincex zH`OS m`6pbpc,,k PhoneNumber PhoneNumberH &!\(999") "000\-0000x zMaF Wm`6(#bpc,,k FaxNumber FaxNumberH &!\(999") "000\-0000x ݓ4OJkXitm`6+bxc,,k Attended &Total Registrationsx r*HE5㜶f`, PageFooterx $nݍLO9~Nm;`6Habc,,i# j%  Text15  =Now()& Long Datex Wq (J, m;`6abc,,i# j%k  Text16 H="Page " & [Page] & " of " & [Pages]x i@K)DK`, ReportFooterx xҾɱJ{HgLVAL0f ^0:<=5B>a)b*c$e g2h6ij0*k ?y "[Event Procedure]l\G=@x }m7N*kV7y  U,^> |GʜU=@Attendees;yJ AaJ=@Employeesw6ټIF|Ж\=@Events;{XcHV]0Wx=@RegistrationPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDT%B~>O;yJ AaJEmployeeIDҖfB$Is" ";{XcHV]0WxEmployeeIDq^ĎF#,^> |GʜUAttendeeID~ 2yH~-;{XcHV]0WxAttendeeIDG0]9OMIb<=@Print Invoice%|FOh9cGlG0]9OMIbAttendeeFirstNamez) fI%*!bAttendeeLastName1bhΛ HʆCompanyName%q\Z I4fAddress ?&L rCityܖnH)Province\%:B&߂JPostalCodeDd@)FjKNEventName %/NiBщLocation`b=MP]StartDate& GbfEndDatetʷ6\oIߕa StartTime&%kF.EndTimeƏGҖN1#RegistrationFee7NWz`SalesTaxRate~5 Oߋ-9,}m7N*kV7RegistrationFeem1¼NX^}m7N*kV7Sales TaxB'ʶ<#CQV}m7N*kV7RegistrationID}m7N*kV7\G=@Invoice-ǰWJF3>"}m7N*kV7Total}N4F5}m7N*kV7Total Paymentsg^H͡B]TG0]9OMIbLL;0x P xAd`6abPc, StartTime Label Start Time StartTime_Labelx =pJ]sm5I`6 apbc,,k EndTime EndTime& Medium TimeH 09:00\ >LL;0x NUFln;Z&d`6apbPc, EndTime Label End Time EndTime_Labelx ph]cAV0bVm0G5I`6 a bc,,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x ~5 Oߋ-9,d`6a bPc, *RegistrationFee Label  Registration Fee *RegistrationFee_Labelx ڻ|'M0ym0G5I`6 a@ bc,,k Sales Tax ^=CLng([SalesTaxRate]*[RegistrationFee]*100)/100& *$#,##0.00;($#,##0.00) Sales_Taxx m1¼NX^d`6a@ bPc, Sales Tax Label Sales Tax Sales_Tax_Labelx @Jg{Wxm0G5I`6 a bc,,k  Total <=[RegistrationFee]+[Sales Tax]& *$#,##0.00;($#,##0.00)x -ǰWJF3>"d`6a bPc, Total Label  Total Total_Labelx WIڰHߧBOm0G5I`6 abc,,k  Total Payments =IIf(isnull([RegistrationID]),LVAL0,Dsum("[PaymentAmount]","Payments","[RegistrationID]=" & Reports!Invoice!RegistrationID))& *$#,##0.00;($#,##0.00) Total_Paymentsx }N4F5d`6abPc, (Total Payments Label Total Payments (Total_Payments_Labelx ML>;m0G5I`6 axbc,,k  Amount Due :=[Total]-nz([Total Payments])& *$#,##0.00;($#,##0.00) Amount_Duex V_Dp d`6axbPc,  Amount Due Label Amount Due  Amount_Due_Labelx 59SK<%Nm`6Hatbc,,k  &Invoice Description X=forms![Print Invoice]![Invoice Description] &Invoice_Descriptionx tSL$O'K`, GroupFooter1x )Zr<@jI_3`, PageFooterx W; B!<m;`6Habc,,i# j%  Text48  =Now()& Long Datex IOgC*Tm;`6abc,,i# j%k  Text49 H="Page " & [Page] & " of " & [Pages]x ,R&LzVĿK`, ReportFooterx jH{TCLVALUͬ3tKFbZjy>ReportHeadermReport_Date_RangeReport Date RangedLabel20PageHeaderdEmployee_Name_LabelEmployee Name LabeldEventType_LabelEventType LabeldEventName_LabelEventName LabeldStartDate_LabelStartDate LabeldLocation_LabelLocation Labeld RegistrationFee_LabelRegistrationFee Labelf Line1 GroupHeader0m Employee_NameEmployee Namef Line2DetailmEventTypemEventNamemStartDatemLocationmRegistrationFeeGroupFooter1mText12dLabel13mSum_Of_RegistrationFeeSum Of RegistrationFeePageFootermText21mText22ReportFootermRegistrationFee_Grand_Total_SumRegistrationFee Grand Total SumdLabel15Total PaymentsͬW6n+)KO<lx@ReportHeaderdLabel47PageHeaderGroupHeader0mCompanyNamemCompanyAddressmCompanyCityStatemCompanyPhoneFaxmInvoice_DateInvoice Dated Invoice_Date_LabelInvoice Date Labelm Attendee_IDAttendee IDd Attendee_ID_LabelAttendee ID Labelm RegistrationIDd RegistrationID_LabelRegistrationID LabelmRegistrationDatedRegistrationDate_LabelRegistrationDate LabelmPurchaseOrderNumberdPurchaseOrderNumber_LabelPurchaseOrderNumber LabelmTermsdTerms_LabelTerms LabeleBox17dAttendeemAttendee1mCompanyName1mAddressmAddress2DetailmEventNamedEventName_LabelEventName LabelmLocationdLocation_LabelLocation LabelmStartDated StartDate_LabelStartDate Labelm!EndDated"EndDate_LabelEndDate Labelm#StartTimed$StartTime_LabelStartTime Labelm%EndTimed&EndTime_LabelEndTime Labelm'RegistrationFeed(RegistrationFee_LabelRegistrationFee Labelm)Sales_TaxSales Taxd*Sales_Tax_LabelSales Tax Labelm+Totald,Total_LabelTotal Labelm-Total_PaymentsTotal Paymentsd.Total_Payments_LabelTotal Payments Labelm/Amount_DueAmount Dued0Amount_Due_LabelAmount Due Labelm1Invoice_DescriptionInvoice Description2GroupFooter13PageFooterm4Text48m5Text496ReportFooter7Attendees.AttendeeID8AttendeeFirstName9AttendeeLastName:Attendees.Title;City<Province=PostalCode>PhoneNumber?FaxNumber@EmailACategoryBAttendees.NotesCRegistration.AttendeeIDDRegistration.EmployeeIDERegistration.EventIDFSalesTaxRateGFeeScheduleIDHEvents.EventIDIEventTypeIDJStatusKRequiredStaffingLConfirmedMAvailableSpacesNEventDescriptionOEvents.NotesPEvents.EmployeeIDQEmployees.EmployeeIDRFirstNameSLastNameTEmployees.TitleUExtensionVWorkPhoneLVAL0f ^0:<=5B>a)b*c2e gh6iXj0*k R?y "[Event Procedure]lJ =@x fVF@}|vy  U;{XcHV]0Wx=@RegistrationȌۂۢD3T[kx;{XcHV]0WxRegistrationDate;7ڴ GفK3R=@Report Date Range^3aLT;7ڴ GفK3RBeginnining Registration DateikUFFF?6;7ڴ GفK3REnding Registration DateCCFwN*"c\7O=@Event Typesw6ټIF|Ж\=@Events;yJ AaJ=@Employees6Aqr^Q=@Sum Of Payments QueryCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNameNR@X*9CCFwN*"c\7OEventTypeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate %/NiBщw6ټIF|ЖLocationƏGҖN1#;{XcHV]0WxRegistrationFee7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total PaymentsJKUa{CCFwN*"c\7OEventTypeID&PJZdw6ټIF|ЖEventTypeIDhY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDT%B~>O;yJ AaJEmployeeIDҖfB$Is" ";{XcHV]0WxEmployeeIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDEmployee Name#~'QJ3u:fVF@}|vEmployee Name5jMpS~fVF@}|vRegistrationFee  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 Af4EC$>ݓ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 ]#xDT ~?d28`6Ha<b c,d#e% Label20 "Sales by Employee" @Times New Romanx GCTEh`, PageHeaderx :HuAEzd`6Ha<bc,d# e% &Employee Name Label Employee Name  DetachedLabel &Employee_Name_Labelx jęH-JUd`6 a<bc,d# e% EventType Label Event Type  DetachedLabel EventType_Labelx 'R.~@ IWd`6a<b c,d# e% EventName Label Event Name  DetachedLabel EventName_Labelx 3Ɛ)cMgBbd7`6`a<b8c,d# e% StartDate Label Date  DetachedLabel StartDate_Labelx ]7I&sN7[Mo d`6"a<b c,d# e% Location Label Location  DetachedLabel Location_Labelx D7@n>ܱ76,<bc,d# e% *RegistrationFee Label Total Sales  DetachedLabel *RegistrationFee_Labelx h` @af2 `6Hb2  Line1x 7A~:LacK`, GroupHeader0x m`H!ʖnm5I`6Ha<bc,, Employee NameLVAL Employee Name Employee_Namex #~'QJ3u:f2 `6Hb2  Line2x \XA4N:U]/WK`,h  Detailx / q KK(EIm`6 bc,, EventType EventTypex t!M6Ӈ$m`6b c,,k EventName EventNamex /2jE[~Um`6`b8c,,k StartDate StartDate& Short DateH 99/99/00;0x ek~ LSAm`6"b c,,k Location Locationx F3SG9R$f7jm`6,c,,k RegistrationFee RegistrationFee& *$#,##0.00;($#,##0.00)x 5jMpS~K`, GroupFooter1x ^f~B< :jm<"`6Hb2i#j%  Text12 ="Summary for " & "'Employee Name' = " & " " & [Employee Name] & " (" & Count(*) & " " & IIf(Count(*)=1,"detail record","detail records") & ")"" @ Arialx faRx(4A[ hd`6Habc,d# Label13 Sumx {: KyGR"2)vm<"`6,ai#j%k ,Sum Of RegistrationFee .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00)" @ Arial ,Sum_Of_RegistrationFeex ׮G./5t`, PageFooterx ɱEI-m;`6Habc,,i# j%  Text21  =Now()& Long Datex YEC$:vV7m;`6abc,,i# j%k  Text22 H="Page " & [Page] & " of " & [Pages]x  GFF@(K`,h ReportFooterx BqȀS;6m`6,c,,i# j% >RegistrationFee Grand Total Sum .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00) >RegistrationFee_Grand_Total_Sumx 3wIEӡ,d`6HbGc, LVALLabel15 Grand Totalx pvF5l(|LVAL@f ^0:<=5B>a)b*c2e gh6iXj0*k R?y "[Event Procedure]l =@x JROeJeby  U;{XcHV]0Wx=@RegistrationȌۂۢD3T[kx;{XcHV]0WxRegistrationDate;7ڴ GفK3R=@Report Date Range^3aLT;7ڴ GفK3RBeginnining Registration DateikUFFF?6;7ڴ GفK3REnding Registration Date;yJ AaJ=@EmployeesCCFwN*"c\7O=@Event Typesw6ټIF|Ж\=@Events6Aqr^Q=@Sum Of Payments QueryNR@X*9CCFwN*"c\7OEventTypeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate %/NiBщw6ټIF|ЖLocationCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNameƏGҖN1#;{XcHV]0WxRegistrationFee7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total PaymentsJKUa{CCFwN*"c\7OEventTypeID&PJZdw6ټIF|ЖEventTypeIDhY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDT%B~>O;yJ AaJEmployeeID.^` KKa-w6ټIF|ЖEmployeeIDEvent Manager3@M slL$ژgeJROeJebEventTypeVBV9Cg]JROeJebRegistrationFee  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 {OEc50ܪ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 -E8@Gtd28`6Ha<b c,d#e% Label20 &Sales by Event Type" @Times New Romanx $NJ(5W`, PageHeaderx kYM#xd`6Ha<bpc,d# e% EventType Label Event Type  DetachedLabel EventType_Labelx JwB ]VDd`6a<b c,d# e% EventName Label Event Name  DetachedLabel EventName_Labelx ׈>ڱڦ76<b8c,d# e% StartDate Label Date  DetachedLabel StartDate_Labelx ]!ˤM4($od`6a<b c,d# e% Location Label Location  DetachedLabel Location_Labelx  h(I^Ip3ad`6#a<bpc,d# e% &Event Manager Label Event Manager  DetachedLabel &Event_Manager_Labelx 49gDشd7`6p,a<bc,d# e% *RegistrationFee Label Total Sales  DetachedLabel *RegistrationFee_Labelx ^ORegistrationFee Grand Total Sum .=Sum([RegistrationFee])& *$#,##0.00;($#,##0.00) >RegistrationFee_Grand_Total_Sumx |ݷ JX>d`6HbeLVALuGc, Label15 Grand Totalx >IBQOz/c LVAL u Attendees&Attendees SubformAutoEventsEmployees8Event Fee Schedule SubformEvent TypesEvents Events SubformFee Schedules0My Company Information "Payment Methods Payments Print Invoice Registration &Report Date RangeSwitchboardͬt\{eٞCQ]'wReportHeadermReport_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 Payments-VUz7n+ b  V  { & ʂ ʘ#ɮ9Oe{őħ2šK·ANA@~u@m~u@DLZLQNQHDUFDKSDMDRBWJLWTWITF_VRN w~u@`~u@CVBHUJIMVIYKZPDKOJZISNZBXQKBGVRN w/~u@ ~u@BAcessVBAData62. wi\u@i\u@A@PROJECT840" i\u@i\u@@@PROJECTwm<84" i\u@i\u@? @dir0,(" i\u@i\u@>#f_VBA_PROJECTB>:" i\u@i\u@=@UXFPAQJTKULAPDYPVXOE_ZPNWXSBb^Z" i\u@i\u@<@NNOWAT_PZTPQQDAOQTXDNAZZJPOGb^Z" 4"\u@i\u@;@ICDUVRMBVSBORDLAAHRKHYXULONDb^Z" 4"\u@i\u@:}@ QCJLDVHTKIDRFEDWHFKVHDMZCLAHb^Z" 4"\u@i\u@9@HJSMJFNHSUBGUDOCHZAHMPKSUXXHb^Z" 4"\u@i\u@86 @SQBDTMNNNOWKXDEATYQUBTWOFXCKb^Z" 4"\u@i\u@7fBURBFPEGXLFRAEPQTERUCLHAUZEIb^Z" 4"\u@i\u@6@BZMXAMGQWUSKFEGNIDEGBEAOQMTCb^Z" 4"\u@i\u@5|fIDOWXDJIRRSABEDXZJVXHNHKWYNKb^Z" 4"\u@i\u@4@DBXUREDQGLCAUDKWZQUPJOXCBGHLb^Z" 4"\u@i\u@3@ZPSFTBILBHBVTDJVAAVYBNPPECVFb^Z" 4"\u@i\u@2fNNHSZINUPYNYQDIAODTBHDEGZEMMb^Z" 4"\u@i\u@1@NGOCMQLHERRMUDXDRMXF_OOPHKZKb^Z" 4"\u@i\u@0@OFQRWBGTFNVNGEIIYNMHLTFCWKJLb^Z" 4"\u@i\u@/G @LJHBNSEUXMVPNDIICTEXKLZVMRYJb^Z" 4"\u@i\u@.fUHMPOWHSZEKOQDARLRBHJDLLLDRFb^Z" 4"\u@i\u@- AcessVBADataNJF. [!"!rR@[!"!rR@ImExSpecs0,( wPz.@(^Qz.@@DirDataCopyB>:" Pz.@(^Qz.@@lPropDataCopyB>:"  =@ =@BlobDeltaz0,( wJ =@ =@ BlobDeltau0,( w\G=@/=@BlobDeltap0,( w=@=@BlobDeltai0,( w t=@0=@BlobDelta_0,( w|=@5=@BlobDeltaZ0,( w=@=@BlobDeltaU0,( w8=@=@BlobDeltaP0,( w=@=@BlobDeltaK0,( w=@A=@BlobDeltaF0,( wJk=@%=@BlobDeltaA0,( w\=@=@BlobDelta<0,( w =@S=@BlobDelta70,( w=@Y=@BlobDelta20,( wJa=@=@BlobDelta-0,( w=@'#=@BlobDelta(0,( wLVAL'fm] >ѷ(<S<S<<N0{6D54B60A-9572-4EDA-8AAB-431DB72E4E22} *P 4 D V@ b %0@G "(HP"X`h x "F @` hp x"F x@  "T(H    08@ Pxp ".$, CompanyName 0B@2k0o(P6 "8B@:<|x6p @!BA@><XoPF@ ".$,;Enter attendee information before registering for an event.A@>d J L N P 0B@H Registration 0B@RkT|F @!BA@>Tho`XP "8!Z!\!^<Register attendee for an event before viewing payments form.A@>t.d J L N P 0B@HPaymentsY[Payments]![RegistrationID] = Forms![Attendees]![Attendees Subform].form![RegistrationID] 0B@Rk@`8|0X( @!BA@> `o@d "8!Z!\!^JEnter attendee and registration information before previewing the invoice.A@>Gdx J L N P 0B@HXInvoice h[RegistrationID]= j"l"8!Z"n 0B@fkp|d @ X @!BA@>kpoxAttribute VB_Name = "Form_endees" Bas0{6D54B60A-9572-4EDA-8AAB-431DB72E4E22} |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 =viewxoPA@topA@toX0A@to@ J L N P 0B@HPayments 0B@Ro J L N P 0B@HPayments 0B@RoxAttribute VB_Name = "Form_endee@s SubfD"D Bas0{504D1B20-B655-41BC-A24B-B0E9FBF@F660D} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  Exit: 6=/@MsgBox7.DescriB3pResundC21q_DblC˰ѷ(<S<S<<N0{387B4274-52F9-42A5-8A04-A996F30C75EA}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Event Types"  Bas0{387B4274-52F9-42A5-8A04-A996F30C75EA} |GlobalSpacAIFalse dCreatablTru PredeclaId"Expose_Templat@eDerivCustomizD$Option Comp@ DT  Mѷ(<S<S<<N0{504D1B20-B655-41BC-A24B-B0E9FBFF660D} 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@HPayments 0B@Ro J L N P 0B@HPayments 0B@RoxAttribute VB_Name = "Form_endee@s SubfD"D Bas0{504D1B20-B655-41BC-A24B-B0E9FBF@F660D} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  Exit: 6=/@MsgBox7.DescriB3pResundC21q_DblCѷ(<S<S<<N0{C62FA92A-51E3-4895-AA10-6087F3E6AB38}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Fee Schedules"D Bas0{C62FA92A-51E3-4895-AA10-6087F3E@6AB38} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  ѷ(<S<S<<N0{95B1E140-0CEE-484F-B487-AE0CD5FCF26C}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Payment Methods" Bas0{95B1E140-0CEE-484F-B487-AE0CD5FCF26C} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT  ѷ(<S<S<<N0{C62FA92A-51E3-4895-AA10-6087F3E6AB38}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Fee Schedules"D Bas0{C62FA92A-51E3-4895-AA10-6087F3E@6AB38} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  ˰ѷ(<S<S<<N0{387B4274-52F9-42A5-8A04-A996F30C75EA}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Event Types"  Bas0{387B4274-52F9-42A5-8A04-A996F30C75EA} |GlobalSpacAIFalse dCreatablTru PredeclaId"Expose_Templat@eDerivCustomizD$Option Comp@ DT  %ѷ(<S<S<<N0{12DD335C-07D0-49A0-9BBF-009EF457BCB8} P ii h0i|` ii Hi|`   %G "*Hhp" x>"    028p  " > (" 08@ HXh p 0   ("0&8`p " xp !GotoNew "$, J P 0B@HkoP4Double-click this field to add an entry to the list.A@> 'o0 ]P "$, "(dd "' )k Event Types GotoNew 0B@R "B@: G  )jX|PH @!BA@>0o(h4Double-click this field to add an entry to the list.A@> 'o]h "$, "(dd "'dB ) dkh Employees GotoNew 0B@R "B@:r G  )jac| @!BA@> o "!&View Fee Schedulel "(n "(o&View Attendees "(dX "(e "(&View Fee Schedule "(koxAttribute VB_Name = "Form_Events" Bas0{12DD335C-07D0-49A0-9BBF-009EF457BCB8} |@GlobalSpacFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT  0Un Ck)ExitR1: aibrrY$P<.Descriv@Ku b8oyebbbntbcb{ Ebrb/#(b|bSb?bf HQca@armada .qaf La}]!aaF_6`6` c0_07 Toggle_View_Vl![ ].Car@& Fee Scheduxle"lRf@].Visi?w1*= ?y/ }& endeeQKY 9=  3|sub O O I zs/e^q`?a$ LVALv}G>ѷ(<S<S<<N0{E828A883-D908-46E9-BF2E-F33E7F81F19E} P  0% P  " ("0 8X hxp (8oPP  Print Invoice 0B@Bo xBAttribute VB_Name = "Form_Print Invoice"D Bas0{E828A883-D908-46E9-BF2E-F33E7F8@1F19E} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  aѷ(<S<S<<N0{20F1E314-6603-4C24-B0CC-0A8D11060600} 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 (kkox5Attribute VB_Name = "Form_Report DalRange" Bas0{20F1E314-6603-4C24-B0CC-0A8D1H1060} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplAqDerivCustomizD$Option 0Comp@ab  [V5 { 5AM6 -8be ger than +g I6t7K8AVisiğ)x IffB LVALi v}G>ѷ(<S<S<<N0{E828A883-D908-46E9-BF2E-F33E7F81F19E} P  0% P  " ("0 8X hxp (*oPP  Print Invoice 0B@Bo xBAttribute VB_Name = "Form_Print Invoice"D Bas0{E828A883-D908-46E9-BF2E-F33E7F8@1F19E} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  ѷ(<S<S<<N0{95B1E140-0CEE-484F-B487-AE0CD5FCF26C}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Payment Methods" Bas0{95B1E140-0CEE-484F-B487-AE0CD5FCF26C} |GlobalSpacIFalse dCreatablTru PredeclaId"Expose_TemplateDerivCustomizD$Option Comp@ DT  kxME+Pi*@,L@.LX B  R  p    xpK Returns True if the specified form is open in Form view or Datasheet view.]p] 2  *$0 , *$j!4 .'k(k ixuAttribute 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{V~u@I~u@I@WEFMTACETORHXDTBKNML_WUIDJJNb^Z" V @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @ @XXXXXXXX X X  X  X  X X XXXXXXXXXXX X!X#X$X%X&X(X)X *X!+X"-X#.X$/X%0X&2X'3X(4X)5X*7X+8X,9X-:X.<X/=X0>X1?X2AX3BX4CX5DxFxGxHxIxKxLxMxNxPx Qx Rx Sx Ux VxWxXxZx[x\x]x_x`xaxbxixjxkxlxnxoxpxqx rx!sx"ux#vx$wx%xx&zx'{x(|x)}x*x+x,x-x.x/x0x1x2x3      BRCSDTEFGHIJKLM N O P Q RSTUV$V@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@XXXXXXX X X  X X XXXXX#X(X-X#2X'7X+<X/AX3FxKxPx Ux Zx_xixnxoxpxux#zx'x+x-x.x/x0XBR  X  X  X XUVCSDTEFGHIJKLM N O P Q RSTXXXx1X X!Xx2#$X#%X#&X#x3()X (*X!(+X"(-.X$-/X%-0X&-23X(24X)25X*278X,79X-7:X.7<=X0<>X1<?X2<ABX4ACX5ADxAFGxFHxFIxFKLxKMxKNxKPQx PRx PSx PUVxUWxUXxU Z[xZ\xZ]xZ _`x_ax_bx_ ijxikxilxi pqx prx!psx"p uvx$uwx%uxx&u z{x(z|x)z}x*zx,V@@@@@ @@@   @@@  @ @@@  @ @@@M`OLJikXMokmd`UidofkX OJmJJMMQkkfJUQkX OJmJLJkQkX Sdi`kXY`QukfQMk`dOo^QkX`kvkJMMQkkkmdiJUQ+iddmXfidfOJmJXiQfdimkXkMiYfmkXqLJX`kvkJMMQkkkmdiJUQ+kMiJmMWX6X8X86x88x 8:x 8<x8>x:X<X>#'+/3۾۾ѻڱھڰھڰѻڱ68:#<x'OYiOJmJxfidfOJmJx6x+OYiOJmJx/OYiOJmJMdfvx0fidfOJmJx-fidfOJmJMdfvx.JMQkkqLJOJmJRqLJfid[QMmX 6X  OYiOJmJX L^dLX fid[QMmfid[QMms`qLJX+qLJ+fid[QMmL[\\bOWkk`vMkOuOQLxx^Oo\iMq` LkvJu[\uJSqJYQb`QhvJOuYkimq\LkvmbqO^b`WdYQbkMdLmSbSYOOQLOYiS\Ux`Q\MQQvLvOkomUSMWkLfxQbO YYfq`v^dYOSQWQqxifUQ\fM^MokQ[`uOuSLQvSsdLQbkO\bO\MQ\JS\L^x^hbhWOoSO\kO`OiLs[^smsYmS+T`S`^bkLk[`suUQQQiS[vUbMxUUd`iO\``SYQod^mQQOL``oxQ`dLOLv[ ixvO`MMo`o\umOMYWSJM^hkOmL[^ kUJSouLkUk`SJQxsLLd`\kvQqWM[kYom\^L`uJusxOLoQsh\[q`UWhhYkifMfhSUYxQJOQbOvLmmbfQkku[QmsudQuU`\hb`oOqmkOOiLSU\vMhY qLWo[Y`qYv\xfO\d[xYkbxLuh\LUSsQS`mJMQmdiWuOmL\b`^+soYO[[bL^dLXL^dLOQ^mJx1fidfOJmJXmvfQYbSdXL^dLXL^dLOQ^mJx2fidfOJmJXmvfQYbSdX#L^dLX#L^dLOQ^mJx3#fidfOJmJX#mvfQYbSdX(L^dLX (L^dLOQ^mJ(fidfOJmJX"(mvfQYbSdX!-L^dLX$-L^dLOQ^mJ-fidfOJmJX&-mvfQYbSdX%2L^dLX(2L^dLOQ^mJ2fidfOJmJX*2mvfQYbSdX)7L^dLX,7L^dLOQ^mJ7fidfOJmJX.7mvfQYbSdX-<L^dLX0<L^dLOQ^mJ<fidfOJmJX2<mvfQYbSdX1AL^dLX4AL^dLOQ^mJAfidfOJmJxAmvfQYbSdX5FL^dLxFL^dLOQ^mJFfidfOJmJxFmvfQYbSdxKL^dLxKL^dLOQ^mJKfidfOJmJxKmvfQYbSdxPL^dLx PL^dLOQ^mJPfidfOJmJx PmvfQYbSdx UL^dLxUL^dLOQ^mJ UfidfOJmJxUmvfQYbSdxZL^dLxZL^dLOQ^mJ ZfidfOJmJxZmvfQYbSdx_L^dLx_L^dLOQ^mJ _fidfOJmJx_mvfQYbSdxiL^dLxiL^dLOQ^mJ ifidfOJmJximvfQYbSdxpL^dLx pL^dLOQ^mJ pfidfOJmJx"pmvfQYbSdx!uL^dLx$uL^dLOQ^mJufidfOJmJx&umvfQYbSdx%zL^dLx(zL^dLOQ^mJzfidfOJmJx*zmvfQYbSdx)fidfOJmJx,,x,>YN Y Y Y  Y Y Y Y t Filter FlagsIdNamePosition SelectedObjectIDTypeeYIdv1@  eOyCustom ^0ablesW 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  @  @  YLP NLLLY Y Y Y  Y Y Y g FlagsGroupIDIconIdNameObjectIDPositiony!}GuDSYYGroupIDIdv1@@LyLk> ] 0  | O " n A  ` 3   R % qDc6 U(tGf9 X+P oO oN oM  oL  oK oJ oI oH oG oFA oE oD oCA oB@ oA? o@> o?< o>; o=: o<9 o;8 o:6 o95 o84 o73 o62 o57 o41  o30  o2/  o1.  o0-  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  o  o  o oX oP o C o = o 8  o 1  o )  o%  o  o  o o o o o ot  @ @ @ @ @ @ @ @ @     ?@ABCDEF#$%&'()*+,-./0123456789:;<=>GH !IJ"Kt  @ @ @ @ @ @ @ @ @       #$% &!'"(#)$*%+&,'-(.)/*0+1,2-3.4/5061728394:5;6<7=8>9?:;<B=C>D?E@FAGBHCIDJEKFLGMHNIOJPKRY6NY  Y Y IdNameTypedv LVAL'nu g >%ѷ(<S<S<<N0{65EF0717-A40B-4D87-A422-963BEACE1A69} pPi| 4 0 i| ii  `i|`  %(K " R0"  "   8@ HP`h" p>x" *8@ HP X`px "    6 0 PX `hx xp Attendees$GOpen the Payments form using the Payments button on the Attendees form.A@>4x'|kho`p6P B@:><8|06( @!BA@><o Z ) j"l"8!Z" )| @!BA@>o04Double-click this field to add an entry to the list.A@> 'o8( "$, "% j"l"  j"l" )kk| @!BA@>op] "$, "(dd@ "' )kPayment Methods GotoNew 0B@R "B@: G  )j| @!BA@>oxpx Attribute VB_Name = "Form_Paymen ts" Bas0{65EF0717-A40 B-4D822-963BEAC@E1A69} |G lobalSpacFalse dCreatab"lTru Pr@edeclaId"Expose_TemplateDerivCustomizD$Optio@n Comp@ fDT  0Me.R@equeryIExitK : O9 rrB.D`escriBhR8esu@3BePeInsertjT8 Me![sfe]Amount[Js]![hBw]. Du|e]Q"R) )T*Meth odID_ \InList(New!a`Sng,r 5po/o Y NY Y Y  Y  Y aDataExtensionIdNameTypeoInDa9B1YYJData_1968C45B1050425286CC38B193BEEB70Idv1@@thmxOffice Themethmx2* Y%K \N Y Y  Y d Y  Y d Y ( Y ( Y d Y  < Y   < Y    Y uSetupIDSalesTaxRateCompanyNameAddressCityProvincePostalCodeCountryPhoneNumberFaxNumber&DefaultPaymentTerms2DefaultInvoiceDescriptionpyYYYCompanyNamePostalCodePrimaryKey v1b@ aq CompuConference Ltd.460 Carreiro DriveCalgaryABT2R4R5Canada(403) 555-7777(403) 555-8888uuueUMEA8$ Md`foMdbSQiQbMQ^mO m:i>i@PY NY  Y dY PaymentMethodIDPaymentMethodCreditCard{h x YPrimaryKeyv1Cash Debit CardCredit CardCheque F Y %K \N    Y Y Y Y  Y < Y dY  Y <Y  PaymentIDRegistrationIDPaymentAmountPaymentDate CreditCardNumberCardholdersName"CreditCardExpDate:CreditCardAuthorizationNumberPaymentMethodIDseuIoesnYYYPaymentMethodIDPrimaryKeyRegistrationIDv1@  Ne3 p@&&&& `@&&&& `S@&&&& p@&&&& p@&&&& `S@I@34455645Elizabeth Brown0112GA0& `@&&&& @KL@&&&& @KL@&&&&  @KL@ @34455644Hari Kumar0111B<0&  @   @    @   $ Y%K \N  Y Y Y Y  Y  Y <Y Y  Y $RegistrationIDAttendeeIDEmployeeIDEventID RegistrationDate&PurchaseOrderNumberSalesTaxRateFeeScheduleIDRegistrationFeeYYYYYYYAttendeeIDEmployeeIDEventIDFeeScheduleIDPrimaryKey RegistrationDate v1b @  ^(P x B `@ `.. `@`.. `@p.. `@@KL.. @@ D.. @@@KL.. @@@KL.. @@`S..  @ `..  @@KL..  @p.. @ `.. @`S.. @p..  @ @       @ @       @ @       @ @         @ @      j @ @   @@@@ ` ` ` `  x5qS5 N < lassRegistration.AttendeeID6 g<lassTotal RegistrationsD@.C77 o<lassRegistration.AttendeeID6 g<cClassRegistration))) <lass G<lass G<cClass <lass G; Payments.RegistrationID6 g;Total PaymentsSum(Payments.PaymentAmount)V-- o;Payments.RegistrationID6 g;Payments!!! ; G; G; _Y0TN Y dY Y Y VenueNameCapacityRaisedStageBeverageService$RirnIYAY.rBPrimaryKeyv1@ ~Northern Room7Canada RoomBanff Room #Algonquin Room @J^UdbhoYbidd`LJbSSidd`MJbJOJidd`bdimWQibidd`'IDataQQvcP=*z @ -  } j C 0  m Z G p]I6#r_L8%uaN;'  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np    e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np    e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np    e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np    e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  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 -e^3LVALЄCMR2 GUIDNameMap. WkRFDoP6   Uw6ټIF|Ж\=@Events;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments QueryhY(Cߘ?b;{XcHV]0WxRegistrationIDƏGҖN1#;{XcHV]0WxRegistrationFeeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total Payments~ 2yH~-;{XcHV]0WxAttendeeID+mnC,6Aqr^RegistrationIDPxBɞMR2 GUIDNameMap. WkRFDoP6   Uw6ټIF|Ж\=@Events;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments QueryhY(Cߘ?b;{XcHV]0WxRegistrationIDƏGҖN1#;{XcHV]0WxRegistrationFeeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total Payments~ 2yH~-;{XcHV]0WxAttendeeID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventID`|x$Hw(mWkRFDoP6Sale Amountfl:IJ5G8{zpWkRFDoP6Total Payments MR2 GUIDNameMap  +jJm4  U,^> |GʜU=@AttendeesWkRFDoP6/B=@xAttendees Subformw6ټIF|Ж\=@Events;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments QueryhY(Cߘ?b;{XcHV]0WxRegistrationIDƏGҖN1#;{XcHV]0WxRegistrationFeeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total Payments~ 2yH~-;{XcHV]0WxAttendeeID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDq^ĎF#,^> |GʜUAttendeeID1bhΛ Hʆ,^> |GʜUCompanyName%q\Z I4f,^> |GʜUAddress ?&L r,^> |GʜUCityܖnH),^> |GʜUProvince\%:B&߂J,^> |GʜUPostalCode;lR7OY>,^> |GʜUAttendeeFirstNamez) fI%*!b,^> |GʜUAttendeeLastNameNKx:A,^> |GʜUTitlexM4M(>eČ,^> |GʜUPhoneNumbera8D0 O;;],^> |GʜUFaxNumberXɻI",^> |GʜUNotes MR2( ReplicateProject MR20 Title AuthorCompanyH. &Access Conference 7 DCFLVALR 8HMR2 GUIDNameMapZ ;7ڴ GفK3R6 . U MR2 GUIDNameMapZ G0]9OMIb<6 . U MR2 GUIDNameMap ZU \IQш  UCCFwN*"c\7O=@Event TypesJKUa{CCFwN*"c\7OEventTypeIDNR@X*9CCFwN*"c\7OEventType MR2 GUIDNameMap ]|DA  UR?MHKTeJa=@Fee Schedules}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFee MR2 GUIDNameMap PzN LPL  U;yJ AaJ=@EmployeesT%B~>O;yJ AaJEmployeeIDjz@&p;yJ AaJFirstNameCDn 5A ދ;yJ AaJLastNameAN[BA|9;yJ AaJTitle!KQGn;yJ AaJWorkPhoneg1R7|Iw&2 ;yJ AaJExtension MR2 GUIDNameMap Y_4}ҦDRf ^ Uw6ټIF|Ж\=@EventsPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventName&PJZdw6ټIF|ЖEventTypeIDCCFwN*"c\7O=@Event TypesNR@X*9CCFwN*"c\7OEventType:7Jjq"w6ټIF|ЖStatus`b=MP]w6ټIF|ЖStartDate& Gbfw6ټIF|ЖEndDatetʷ6\oIߕa w6ټIF|ЖStartTime&%kF.w6ټIF|ЖEndTimeG(jD Ww6ټIF|ЖRequiredStaffinghuC_MB> w6ټIF|ЖConfirmed:a㪨Dkw6ټIF|ЖAvailableSpacesmg\A>Pkpw6ټIF|ЖEventDescriptionGM*#L#'j6w6ټIF|ЖNotes.^` KKa-w6ټIF|ЖEmployeeID;yJ AaJ=@EmployeesCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstName %/NiBщw6ټIF|ЖLocationcA ȤTH|C=@Venues LVALMR2 GUIDNameMap 0wWD9{2|.  U,^> |GʜU=@Attendees;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments Query( 4B$D;{XcHV]0WxEventID~ 2yH~-;{XcHV]0WxAttendeeIDz) fI%*!b,^> |GʜUAttendeeLastName;lR7OY>,^> |GʜUAttendeeFirstName1bhΛ Hʆ,^> |GʜUCompanyNameƏGҖN1#;{XcHV]0WxRegistrationFeemqcH- X6Aqr^Total PaymentshY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDq^ĎF#,^> |GʜUAttendeeIDx|6Gz,|OAttendee Name MR2 GUIDNameMap  da KӅ=:  Uw6ټIF|Ж\=@Events]|DA=@ Event Fee Schedule SubformR?MHKTeJa=@ Fee Schedules>&I 2R?MHKTeEventIDPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventNamemg\A>Pkpw6ټIF|ЖEventDescription %/NiBщw6ټIF|ЖLocation&PJZdw6ټIF|ЖEventTypeIDCCFwN*"c\7O=@Event TypesNR@X*9CCFwN*"c\7OEventType.^` KKa-w6ټIF|ЖEmployeeID;yJ AaJ=@EmployeesCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstName:7Jjq"w6ټIF|ЖStatus`b=MP]w6ټIF|ЖStartDate& Gbfw6ټIF|ЖEndDatetʷ6\oIߕa w6ټIF|ЖStartTime&%kF.w6ټIF|ЖEndTime:a㪨Dkw6ټIF|ЖAvailableSpaces&U0~BQNNDda KӅ=:AvailableSpaces'LjFṅZՕda KӅ=:Events Subform0wWD9{2|.C=@>E0Events Subform,^> |GʜU=@Attendees;{XcHV]0Wx=@Registration6Aqr^Q=@Sum Of Payments Query( 4B$D;{XcHV]0WxEventID~ 2yH~-;{XcHV]0WxAttendeeIDz) fI%*!b,^> |GʜUAttendeeLastName;lR7OY>,^> |GʜUAttendeeFirstName1bhΛ Hʆ,^> |GʜUCompanyNameƏGҖN1#;{XcHV]0WxRegistrationFeemqcH- X6Aqr^Total PaymentshY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDq^ĎF#,^> |GʜUAttendeeID |LVAL B MR2 GUIDNameMap >儊H2DQq0@  UQ4d&Jd=@Payments+mnC,Q4d&JRegistrationID+jJm4r=@AttendeesCy7H +z+jJm4Attendees SubformPaymentMethodID`58A0=@Payment MethodsN>.Clx$`58APaymentMethodPaymentDatePaymentAmountCardholdersNameCreditCardNumberCreditCardExpDateCreditCardAuthorizationNumber MR2 GUIDNameMapl G5iDۺ&mtH @ U`58A0=@Payment MethodsV#=@mbc`58APaymentMethodIDN>.Clx$`58APaymentMethodje7;4K5rۍ`58ACreditCard MR2 GUIDNameMapt =.~t=AE?P H UcX1ETAaGiLc=@My Company Informationz4HS! -4cX1ETAaGiLCompanyName.N?DKF dGcX1ETAaGiLAddressUh޷'N`T,cX1ETAaGiLCityĥ E9IFfcX1ETAaGiLProvincet-GVFH_[CcX1ETAaGiLPostalCodebrbG|[cX1ETAaGiLCountryND{2tLS#A!cX1ETAaGiLPhoneNumberd'|LLcX1ETAaGiLFaxNumbercU O q`cX1ETAaGiLSalesTaxRateےH_Z*`cX1ETAaGiLDefaultPaymentTermsXEwBÏ.cX1ETAaGiLDefaultInvoiceDescription MR2 GUIDNameMap '&M(m4D8  UR?MHKTeJa=@Fee Schedules/!'a@CR?MHKTeFeeScheduleID>&I 2R?MHKTeEventIDw6ټIF|Ж\=@EventsDd@)FjKNw6ټIF|ЖEventName}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFee  LVALMR2 GUIDNameMap ,J[#BBfSiPd \ U,^> |GʜU=@Attendees1, A-Y [=@Total Registrations by Attendee@Ca11, A-Y [Total Registrationsq^ĎF#,^> |GʜUAttendeeID~ 2yH~-1, A-Y [AttendeeIDz) fI%*!bAttendeeLastName;lR7OY>AttendeeFirstName1bhΛ HʆCompanyName ?&L rCityܖnH)ProvincexM4M(>eČPhoneNumbera8D0 O;;]FaxNumber MR2 GUIDNameMap   ExeIkf  U;{XcHV]0Wx=@Registration~ 2yH~-;{XcHV]0WxAttendeeID+jJm4r=@AttendeesBt]G5[+jJm4AttendeeID,^> |GʜU=@Attendeesq^ĎF#,^> |GʜUAttendeeIDRegistrationIDRegistrationDateEmployeeID;yJ AaJ=@EmployeesT%B~>O;yJ AaJEmployeeIDCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNamePurchaseOrderNumberEventIDw6ټIF|Ж\=@EventsPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventName:a㪨Dkw6ټIF|ЖAvailableSpacesFeeScheduleIDR?MHKTeJa=@Fee Schedules>&I 2R?MHKTeEventIDRegistration/!'a@CR?MHKTeFeeScheduleID}PWBvER?MHKTeFeeDescriptionu7Ϫ5*H|O#XR?MHKTeFeeRegistrationFee Aaw= ExeIkfEventIDSalesTaxRateB욼M_VӷQ ExeIkfSalesTaxRateȧxyBM+=Z ExeIkfRegistrationFee&B#՚ ExeIkfSales TaxDS^EC)H ExeIkfRegistrationID%ƒBHMSD ExeIkfTotal ChargesD>FKb ҅ ExeIkfTotal Paid KvcO<)   x e R > +  {  g T A -}jVC0 lYE2 n[H0  /  / e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np /  .  . e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np .  -  - e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np -  ,  , e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np ,  +  + e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np +  *  * e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np *  )  ) e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np )  (  ( e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np (  '  ' e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np '  &  & e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np &  %  % e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np %  $  $ e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np $  #  # e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np #  "  " e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np "  !  ! e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np !     e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np      e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np    e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np LVALMR2 GUIDNameMap"  }m7N*kV7  U,^> |GʜU=@Attendees;yJ AaJ=@Employeesw6ټIF|Ж\=@Events;{XcHV]0Wx=@RegistrationPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDT%B~>O;yJ AaJEmployeeIDҖfB$Is" ";{XcHV]0WxEmployeeIDq^ĎF#,^> |GʜUAttendeeID~ 2yH~-;{XcHV]0WxAttendeeIDG0]9OMIb<=@Print Invoice%|FOh9cGlG0]9OMIbAttendeeFirstNamez) fI%*!bAttendeeLastName1bhΛ HʆCompanyName%q\Z I4fAddress ?&L rCityܖnH)Province\%:B&߂JPostalCodeDd@)FjKNEventName %/NiBщLocation`b=MP]StartDate& GbfEndDatetʷ6\oIߕa StartTime&%kF.EndTimeƏGҖN1#RegistrationFee7NWz`SalesTaxRate~5 Oߋ-9,}m7N*kV7RegistrationFeem1¼NX^}m7N*kV7Sales TaxB'ʶ<#CQV}m7N*kV7RegistrationID}m7N*kV7\G=@Invoice-ǰWJF3>"}m7N*kV7Total}N4F5}m7N*kV7Total Paymentsg^H͡B]TG0]9OMIbO;yJ AaJEmployeeIDҖfB$Is" ";{XcHV]0WxEmployeeIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDEmployee Name#~'QJ3u:fVF@}|vEmployee Name5jMpS~fVF@}|vRegistrationFee LVALMR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLQ <       bO`8Ex `y8 U;{XcHV]0Wx=@Registration( 4B$D;{XcHV]0WxEventIDhY(Cߘ?b;{XcHV]0WxRegistrationID MR2 GUIDNameMap JROeJeb  U;{XcHV]0Wx=@RegistrationȌۂۢD3T[kx;{XcHV]0WxRegistrationDate;7ڴ GفK3R=@Report Date Range^3aLT;7ڴ GفK3RBeginnining Registration DateikUFFF?6;7ڴ GفK3REnding Registration Date;yJ AaJ=@EmployeesCCFwN*"c\7O=@Event Typesw6ټIF|Ж\=@Events6Aqr^Q=@Sum Of Payments QueryNR@X*9CCFwN*"c\7OEventTypeDd@)FjKNw6ټIF|ЖEventName`b=MP]w6ټIF|ЖStartDate %/NiBщw6ټIF|ЖLocationCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNameƏGҖN1#;{XcHV]0WxRegistrationFee7NWz`;{XcHV]0WxSalesTaxRatemqcH- X6Aqr^Total PaymentsJKUa{CCFwN*"c\7OEventTypeID&PJZdw6ټIF|ЖEventTypeIDhY(Cߘ?b;{XcHV]0WxRegistrationID+mnC,6Aqr^RegistrationIDPxBɞƏŎw6ټIF|ЖEventID( 4B$D;{XcHV]0WxEventIDT%B~>O;yJ AaJEmployeeID.^` KKa-w6ټIF|ЖEmployeeIDEvent Manager3@M slL$ژgeJROeJebEventTypeVBV9Cg]JROeJebRegistrationFee LVAL0 8ά(h&xRegistrationά(h&xPaymentsά(h&xRegistrationά(x&iVenuesVenues xEventsEvents2KEvent TypesEvent TypesxEmployeesEmployeesJvcO<)   x e R > +  {  g T A -}jVC0 lXE2 n[  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  ! !e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np ! # #e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np # ' 'e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np '  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  V Ve6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np V P Pe6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np P I Ie6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np I A Ae6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np A = =e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np = 8 8e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 8 1 1e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 1 : :e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np : 9  9 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 9  8  8 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 8  7  7 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 7  6  6 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 6  5  5 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 5  4  4 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 4  3  3 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 3  2  2 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 2  1  1 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np 1  0  0 e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np LVALOfMR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControl$UnicodeCompressionIMEModeIMESentenceModeInputMaskValidationRuleValidationTextDescriptionDefaultValue FilterOrderByNameMapGUID FormatSmartTags     U,^> |GʜU=@Attendees_$FO,^> ҷʜUĴ2< LB^2,^> |GʜUAttendeeFirstNameS#|-[@l"#,^> |GʜUAttendeeLastNamet&GdY:,^> |GʜUTitle3Ӄ AO,,^> |GʜUCompanyName[_N*a&IT!&(,^> |GʜUAddressYtֆMkSc,^> |GʜUCitytJ@ЎRf,^> |GʜUProvince7k!.`@{-,^> |GʜUPostalCodexm20 WL0rP,^> |GʜUPhoneNumber-E3yd,^> |GʜUFaxNumber9~K~JaĜAC,^> |GʜUEmailo4j^ LL3,^> |GʜUCategory$UjD[9- 6,^> |GʜUNotes  ,^> |GʜU("AttendeeFirstName   First Name     m       ;lR7OY>& AttendeeLastName   Last Name     m       z) fI%*!b Title       m       NKx:A޲CompanyName    Company Name     m       1bhΛ HʆAddress   b    m       %q\Z I4fCity       m        ?&L rProvince   Province     m       ܖnH)PostalCode   Postal Code >L0L\ 0L0     m       \%:B&߂JPhoneNumber    Phone Number     m      4 ,!\(999") "000\-0000;;_ xM4M(>eČFaxNumber   Fax Number     m      4 ,!\(999") "000\-0000;;_ a8D0 O;;]| Notes            XɻI"~AttendeeID AttendeeID     q^ĎF# Email       m      $ Like "*@*.???"< 4Not a valid email address. ZUF9UCYACategory   f ^Select Delegate, Exhibitor, Attendee, or Media. "Attendee"    m       LVALڙd`ERq5xLVAL MR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenValidationRuleValidationText FilterOrderByNameMapGUIDDescription FormatSmartTagsInputMaskDefaultValueDisplayControlIMEModeIMESentenceMode$UnicodeCompression1    UCCFwN*"c\7ON=@Event Typesub3FK}ECCFwN*"c\7OEventTypeID!'U#sA_?tdBCCFwN*"c\7OEventType  CCFwN*"c\7OEventType   Event Type    m    NR@X*9}EventTypeID" Event Type ID    JKUa{MR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControl$UnicodeCompressionIMEModeIMESentenceModeInputMaskValidationRuleValidationText FilterOrderByNameMapGUIDDescription FormatSmartTagsDefaultValue     U;yJ AaJA=@EmployeesCZDkz ;yJ AaJEmployeeID )YA ~ů;yJ AaJFirstNameۮ:Yf"@;L#ҔX;yJ AaJLastNameVέqzFF;yJ AaJTitleǧýJ@ ng/;yJ AaJExtensione][4EH*mPF;yJ AaJWorkPhone  ;yJ AaJFirstName   First Name     m       jz@&pLastName   Last Name     m       CDn 5A ދ Title       m       AN[BA|9Extension       m       g1R7|Iw&2 WorkPhone   Work Phone4 ,\(000") "000\-0000;0;_     m       !KQGnwEmployeeID Employee ID    T%B~>OLVALOfMR2OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHiddenDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList FormatInputMaskValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsDefaultValueIMEModeIMESentenceMode$UnicodeCompressionDecimalPlaceso   0 ( Uw6ټIF|Ж=@Events70sNbZvw6ټIF|ЖEventID@Թ21FZp}w6ټIF|ЖEventNameCCFwN*"c\7O=@Event TypesNR@X*9CCFwN*"c\7OEventType.lLߗw6ټIF|ЖEventTypeID`XM ,w6ټIF|ЖStatus]ũOM,@w6ټIF|ЖLocationh"K#N w6ټIF|ЖStartDate:bOoH1w6ټIF|ЖEndDate2߲bqJ ~w6ټIF|ЖStartTime;zIDI&kw6ټIF|ЖEndTimeI_Cȕw6ټIF|ЖRequiredStaffingC<̻w6ټIF|ЖConfirmedLEU`5@GZw6ټIF|ЖAvailableSpacese[pF>b{Uw6ټIF|ЖEventDescriptionXTBN' [ȩw6ټIF|ЖNotes;yJ AaJ=@Employeesko6N:jrw6ټIF|ЖEmployeeIDCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstName  w6ټIF|ЖEventName   Event Name     m     Dd@)FjKNEventTypeID " Event Type ID  o Table/Query SELECT DISTINCTROW [Event Types].* FROM [Event Types] ORDER BY [Event Types].EventType;       0;2880  2880twip  r   ! &PJZd Status       m     :7Jjq"Location       m      %/NiBщStartDate  Start Date Short Date 99/99/00;0      `b=MP]EndDate  End Date Short Date 99/99/00;0      & GbfStartTime  Start Time Medium Time  09:00\ >LL;0      tʷ6\oIߕa EndTime  End Time Medium Time  09:00\ >LL;0      &%kF.& RequiredStaffing * "Required Staffing    !  m G(jD W~ConfirmJ LVALZ ed   Yes/No     m huC_MB> $AvailableSpaces (  Available Spaces    !  m :a㪨Dk& EventDescription  * "Event Description        mg\A>Pkp| Notes          GM*#L#'j6EmployeeID  Employee ID  o Table/Query SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];       0;2880  2880twip     ! .^` KKa-kEventID Event ID    PxBɞƏŎ\LVALlMR2OrientationOrderByOnDefaultViewRequiredCaptionDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListColumnWidthColumnOrderColumnHiddenAllowZeroLength FormatDecimalPlacesValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsInputMaskDefaultValueIMEModeIMESentenceMode$UnicodeCompression     UR?MHKTe8=@Fee Scheduleso+NRBBR?MHKTeFeeScheduleIDw6ټIF|Ж\=@EventsDd@)FjKNw6ټIF|ЖEventNamemf)TN?dpFR?MHKTeEventID^MCK"ӻiR?MHKTeFeeDescriptionGK0N[R?MHKTeFee  R?MHKTeEventID  Event ID o Table/Query SELECT DISTINCTROW Events.* FROM Events ORDER BY Events.EventName;      0;2880   2880twip  $    >&I 2"FeeDescription  & Fee Description    m    ! }PWBvE Fee 0 ($#,##0.00;-$#,##0.00     u7Ϫ5*H|O#X숅 FeeScheduleID& Fee Schedule ID    /!'a@CAvcO<)   x e R > +  {  g T A -}jVC0 lYE2? ?e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np ? > >e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np > = =e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np =  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  < <e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np < ; ;e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np ;  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   Te6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np  % %e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np %  e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np   e6pʿ0p`-Hv(kQ2f7+Hvn΢PX5yh?̴^ / 70?yVo`#8G"B>'Np ELVALUMR2BOrientationOrderByOnDefaultViewRequiredCaption FormatDefaultValueValidationRuleValidationTextColumnWidthColumnOrderColumnHiddenDecimalPlacesDisplayControlAllowZeroLength$UnicodeCompressionIMEModeIMESentenceModeInputMask FilterOrderByNameMapGUIDDescriptionSmartTags     UcX1ETAaGiL}=@My Company Information :@)@qg9cX1ETAaGiLSetupIDŭx)ծKS t0cX1ETAaGiLSalesTaxRate@EwK*iƐIcX1ETAaGiLCompanyNamePJ ocX1ETAaGiLAddressdDCxDvycX1ETAaGiLCityêc L8ADcX1ETAaGiLProvince7jM͛cX1ETAaGiLPostalCode荳KQGDmcX1ETAaGiLCountry G_EcX1ETAaGiLPhoneNumberc{HLxcX1ETAaGiLFaxNumberݶgdG)Q–cX1ETAaGiLDefaultPaymentTermsi8N/τcX1ETAaGiLDefaultInvoiceDescription  cX1ETAaGiLSalesTaxRate $ Sales Tax Rate Percent  0  <1L DThis value must be less than 100%.          m cU O q`CompanyName    Company Name        m    z4HS! -4Address          m    .N?DKF dGCity          m    Uh޷'N`T,Province   Province        m    ĥ E9IFfPostalCode   Postal Code >L0L\ 0L0        m    t-GVFH_[CCountry          m    brbG|[PhoneNumber    Phone Number, $000\-000\-0000;0;_        m    ND{2tLS#A!FaxNumber   Fax Number, $000\-000\-0000;0;_        m    d'|LL,&DefaultPaymentTerms  2 *Default Payment Terms        m    ےH_Z*`82DefaultInvoiceDescription  > 6Default Invoice Description          XEwBÏ.iSetupID SetupID       N6Ksu.X LVALh MR2&OrientationOrderByOnDefaultViewAllowZeroLengthRequiredCaptionColumnWidthColumnOrderColumnHidden FormatValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsInputMaskDefaultValueDisplayControlIMEModeIMESentenceMode$UnicodeCompression   H @ U`58ASv=@Payment Methods>XI `58APaymentMethodIDv>HtI\ (`58APaymentMethodC KG(S D`58ACreditCard  `58Aﻺ PaymentMethod  $ Payment Method    m    N>.Clx$CreditCard   Credit Card? Yes/No    m je7;4K5rۍ$PaymentMethodID* "Payment Method ID    V#=@mbc   ?J=@J=@{F9DB3E5D-2CE6-41B4-9CFA-B4BF4938B180}nnnnnnnnnnl >J=@J=@{78226313-A1AD-4F6C-8E69-DAC43DB9548E}nnnnnnnnnnl =J=@J=@{27BED747-3C73-4F70-8CD7-0ED740871426}nnnnnnnnnnl Ǧ=@0=@Payment Methods@LLL@@@@@@@> @/LVAL?MR2OrientationOrderByOnDefaultViewRequiredCaptionColumnWidthColumnOrderColumnHidden FormatDecimalPlacesInputMaskAllowZeroLengthDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToListValidationRuleValidationText FilterOrderByNameMapGUIDDescriptionSmartTagsDefaultValueIMEModeIMESentenceMode$UnicodeCompression     UQ4d&J=@Payments>E# c%Q4d&JPaymentIDЙ]!EGlQ4d&JRegistrationID0 HOu(Q4d&JPaymentAmount殝 (6KYuAQ4d&JPaymentDate!.QOOF EQ4d&JCreditCardNumberM}LƺQ4d&JCardholdersName UE{G"v5Q4d&JCreditCardExpDateKcrMMeQ4d&JCreditCardAuthorizationNumber`58A0=@Payment MethodsN>.Clx$`58APaymentMethodcyOhdQ4d&JPaymentMethodID  Q4d&J"RegistrationID & Registration ID       m +mnC, PaymentAmount $ Payment Amount0 ($#,##0.00;-$#,##0.00      D 2JpZ|PaymentDate   Payment Date Short Date 99/99/00;0       hN;SAr{ۋ& CreditCardNumber   " Credit Card #     m    ! ^!@d[$CardholdersName   & Cardholder Name     m    !  ܁^@("CreditCardExpDate $ Card Exp. Date Short Date 99/99/00;0       XY7K|r@:CreditCardAuthorizationNumber   $ CC Authoriz. #     m    ! I"NG2~9m$PaymentMethodID * "Payment Method ID  o Table/Query SELECT DISTINCTROW [Payment Methods].* FROM [Payment Methods] ORDER BY [Payment Methods].PaymentMethod;    0;1440;0  1440twip       *sWJN,sPaymentID Payment ID    CJGqLVALOf MR2RequiredCaptionDisplayControlRowSourceTypeRowSourceBoundColumnColumnCountColumnHeadsColumnWidthsListRowsListWidthLimitToList FormatInputMaskAllowZeroLengthDefaultValueValidationRuleValidationTextDecimalPlacesOrientation FilterOrderByOrderByOnNameMapDefaultViewGUIDColumnWidthColumnOrderColumnHiddenDescriptionSmartTagsIMEModeIMESentenceMode$UnicodeCompressionAttendeeID  AttendeeID     m ~ 2yH~-EmployeeID  Employee ID o Table/Query SELECT [EmployeeID], [LastName] & ", " & [FirstName] FROM Employees ORDER BY [LastName] & ", " & [FirstName];     0;2880   2880twip       ҖfB$Is" "EventID  Event ID o Table/Query SELECT DISTINCTROW Events.EventID, Events.EventName, Events.AvailableSpaces FROM Events ORDER BY Events.EventName;    0;2880;0   2880twip       ( 4B$D& RegistrationDate * "Registration Date Short Date 99/99/00;0       ȌۂۢD3T[kx,&PurchaseOrderNumber   PO Number    m    ! v6Jof;SalesTaxRate $ Sales Tax Rate Percent  0  <1L DThis value must be less than 100%.     m 7NWz` FeeScheduleID & Fee Schedule ID     m wqBN/a4ބ%$RegistrationFee (  Registration Fee0 ($#,##0.00;-$#,##0.00     ƏGҖN1#"RegistrationID& Registration ID    hY(Cߘ?b  ~ v U;{XcHV]0Wx=@RegistrationcԹjM,4A;{XcHV]0WxRegistrationIDmi;g[F@&Qh;{XcHV]0WxAttendeeID;yJ AaJ=@EmployeesGY}h2$=;{XcHV]0WxEmployeeIDCDn 5A ދ;yJ AaJLastNamejz@&p;yJ AaJFirstNamew6ټIF|Ж\=@EventsPxBɞƏŎw6ټIF|ЖEventIDDd@)FjKNw6ټIF|ЖEventName:a㪨Dkw6ټIF|ЖAvailableSpacesե#A&Ѷ;{XcHV]0WxEventIDR/A J_+{;{XcHV]0WxRegistrationDaten;Zp@]I;{XcHV]0WxPurchaseOrderNumber1~߹KLVAL.J;{XcHV]0WxSalesTaxRatecqB-;{XcHV]0WxFeeScheduleID2%^Ab؍ ;{XcHV]0WxRegistrationFee   ;{XcHV]0WxLVALe 00MR2^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 ~ w             F   Office Theme MR2BOrientationOrderByOnDefaultViewColumnWidthColumnOrderColumnHiddenDescriptionRequiredAllowZeroLengthDisplayControlIMEModeIMESentenceMode$UnicodeCompressionDecimalPlacesDefaultValue FormatValidationRuleValidationText FilterOrderByNameMapGUIDInputMaskCaptionSmartTags   j b UcA ȤTH|C=@Venues_2NUהcA ȤTH|CVenueNameI.naO{kcA ȤTH|CCapacityl^Fq2oYcA ȤTH|CRaisedStage/n⩒Au&cA ȤTH|CBeverageService  cA ȤTH|CVenueName E  < 4The room or facility name.    m       5&@l/Capacity   N FCapacity is the fire code capacity.    0   m i"CJ7RaisedStage     Yes/No   j n < FDlkx$BeverageService E    Yes/No   j 2TCsqBMR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLW <       1, A-Y [ U;{XcHV]0Wx=@Registration~ 2yH~-;{XcHV]0WxAttendeeIDhY(Cߘ?b;{XcHV]0WxRegistrationID J,&Total Registrations @Ca1MR2ODBCTimeoutMaxRecordsReplicableRecordLocksRecordsetType FilterOrderByOrderByOnOrientationNameMapDefaultViewGUIDDOLU <       6Aqr^ UQ4d&Jd=@Payments+mnC,Q4d&JRegistrationIDD 2JpZ|Q4d&JPaymentAmount @"Total Payments mqcH- X ] {F9DB3E5D-2CE6-41B4-9CFA-B4BF4938B180}EventsEmployeeIDEmployeesEmployeeIDzfZ{78226313-A1AD-4F6C-8E69-DAC43DB9548E}EventsEventTypeIDEvent TypesEventTypeID|fZ{27BED747-3C73-4F70-8CD7-0ED740871426}EventsLocationVenuesVenueNamevfZ A @J^UdbhoYbidd`DLJbSSidd`DMJbJOJidd`DbdimWQibidd`D LVALFM}>ѷ(<S<S<<N0{87AF5B77-85C0-4215-85E7-2530766EFBE1} 8Pi| p$0%Ppp  " @ Xh xxp5There is no data for this report. Canceling report...A@>'||oxdAttribute VB_Name = "Report_endee Listi ng" Bas0{87AF5B77-85C@0-4215E7-2530766EFBE1} |@GlobalsSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT  Vѷ(<S<S<<N0{6EEF0E36-292B-4F4B-A83C-1381126C7840}p 8pPi| < >i| `0%00 " @ Xh"p x" ( xp5There is no data for this report. Canceling report...A@>'||op  Print Invoice 0B@Bo` Print Invoice  0B@R Print Invoice$D '|koxαAttribute VB_Name = "Report_Invo@ice" Bas0{6EEF0E36-292B-4F4B-A83C-1381126C7840} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT    ,IfA XLVALhc"HDou-clk\is field to add an ry\l [ = ac!@FContinA[AfterUpdV]>f|`Null(D$]M} .Column(2)D,wCardhol0dersᮞLFirst#& " & RLaiC|#T??V#V8 hWmDblCAO"c%Dim0 lnga_Long!z!(?IsEA`RETextD"ļEBDoD F%Dq%A  4cDoCmLd.jAK " a/s", P9ialop@"GotoA D]cA@ <> 0b1X6`?vT\_o* pD?*apIFj_& *{V~u@ܘ~u@J|'IIPVMYLOIDFEHEVZRPGEKPCLCUSEb^Z" {VJ~u@ܘ~u@K@MFMLNSBSJMWXGEEERFJYGNCZGGOMb^Z" LVAL'%#>ѷ(<S<S<<N0{45919FAB-0731-4263-89A5-52B35C4C158F} P i| * 4` ii x@i|` ii X  i|` p0iPi  i|` xH%x HH "&(PX" `hZ"   (0@H"PX`x       08" @>H"    00@ `h px" >"  0@H " PX` hx  , (0 8@PX" `>h""    0@4H   xp "This event is fully booked.A@>ek(o P Attendees$OOpen the Registration form using the Registration button on the Attendees form.A@>'|ko "B@:| @!BA@>LVALo6 Attendees$ !B@: B@: j"l"8!Z!\!^ RegistrationID 0B@2 j"l"8!Z"n 0B@kk<|6 @!BA@><o`4Double-click this field to add an entry to the list.A@> 'ohX]` "$, "(dd( "' )*k Employees GotoNew 0B@R "B@: G  )j| @!BA@>pohx4Double-click this field to add an entry to the list.A@> 'o "$, "B@: ) ) koX] "$, "(ddp "' )kHEvents GotoNew 0B@R "B@: G  )j "B@:| @!BA@>o4Double-click this field to add an entry to the list.A@> 'oHp % ) o ]0 "$, "(dd "'(! )D"k Fee Schedules GotoNew 0B@R "B@: G  )j@$H|@8 @!BA@> oxAttribute VB_Name = "Form_Registration" " Bas0{45919FAB-0731-4263-89A5-52B35C4C 158F} |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< ѷ(<S<S<<N0{BC4B7433-C2E8-461F-8862-905A6A793E8E}p 8pPi| < >i| `0%00 " @ Xh"p$x" 4  (xp5There is no data for this report. Canceling report...A@>'|8op Report Date Range 0B@B`oXReport Date Range  ! 0B@RReport Date Range$'|koxAttribute VB_Name = "Report_Sales by Employee"  Bas0{BC4B7433-C2E8-461F-8862-905A6A793E8E} |GlobaltSpacAIFalse dCreatablTru PredeclaId"Expose _TenateDerivCus`tomizD$Option Codmp@ DT   ѷ(<S<S<<N0{7BDA5C74-D965-439E-B792-AC515D27CD77}p 8pPi| < >i| `0%00 " @ Xh"p$x" 4  (xp5There is no data for this report. Canceling report...A@>'||op Report Date Range 0B@BoXReport Date Range  ! 0B@RReport Date Range$'|koxAttribute VB_Name = "Report_Sales by Event Type"D Basb0{7BDA5C74-D965-439E-B792-AC515D2@7CD77} |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_ttenesBUHMPOWHSZEKOQDA@RLRBHJ`L@DRF28U@HMPW@SZEK@Q)ARLU`B JLLRF @1x`w"a","(Ţ+ Sub#mG,a Su0bfdLJHBNSEUXMVPNDIICTEXKLZVMRDYJLJBNEUXUVNIGCTT X`L` VqRY`,% M6@Employ6EE7poy6e6OFQRWBGTFNVNGEIIYNMHLT@FCWKJLOU`0Q`3W@_G`F V`GY`M LbCW &J7 ;6EventP Typ!Q *6ETv nQ y pNGOCMQLHERRMUDXDRMXF_OOPHKZKQNG`OC/QU`H`R`M5DU 6DbX _Ou7HZ`ai @kSFPNjINUPYNYQDIAODTBHDEGZEMMN@/iI0U1YjIVD#jD@GnM 3%Fee Schedu@G$KF1ehc5eueZPSFTBILBHBVTDJVAAVYBNPPECVCZ S T2WLPH0V D2bV AV36P1ECC' ѿ 1 BoPPaym'M`ethodEF Pa4m0(jMtpopDBXUREDQGLCAUDKWZQUPJOXCBTGH5D X 'RUD0G(Cp UBK4Z01J@(X B@+H0Pgpk"Q A 0^tvBIDOWXDJIRRSABEDXZJVXHN`HKWYN5aqO@ X JpN4S B X'JX*!+ *K]m(D((PripBInvo`~A(Pri p npCoc 3]BZMXAMGQWUSKFEGN~GBEAOQMTTCc6B MpAAU3G@W@S@F G7#GE*OM`*C Mo6(RegistrY|Gw(R@ g r0)to URBFPEGXLFRAEPQTERUCLHAPUZEI UNBUP6P X%FAP` jRCpjH UE@()3Lj@ HyReportQe RangeMy p)ZtDD 1ERngSQBDTMNNNOWKXDEATYQUB@TWOFXC)SU B)TNN5j*!TpDQpB`WFC^M }aB^GlobpCod ^G2xb *l C df HJSMJF0_UBGUDOCHZAP@KSUXXHHOS J_U0'G 1C5Z@s^Kч7m(Hk!Փ3stingG. z 0#iD1)3)QCJLDVHTKIEDWHFKVHDMZCLADQNDBHK&y6DFHKDZLBOOoFD(_pCICDUVRMBVSBORDLAAHRKHYXULONDCI D Vp5MVB0&VR( A`R&H0(`L ٿ'V Say by hG0S)a = y) !6AT@_PZTPQ`OQTXDNAZZpJPOG5a`AQ_PBTPQ[7QpQ7N0ZJPOGHP18`HP,D"0(+Report_Sales by Event Ty peG4>eport_Sal"s byQEvn TTp UXFPAQJTKULAPDYPVXOE_ZPNW@XSB28[UXFAQJ=KULDADYVQOEwZ NDWSB$ y:Z LVALr Form_A&-q>;ѷ(<S<S<<N0{62C19B64-66D9-4279-BA85-F44C7D4E117B}  P%pPP &-q>;ѷ(<S<S<<N0{62C19B64-66D9-4279-BA85-F44C7D4E117B}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Employ@ees" Bas0{62C19B64-66D9-4279-BA85-F44C7D4E117B} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TeateDerivC&-q>;ѷ(<S<S<<N0{62C19B64-66D9-4279-BA85-F44C7D4E117B}  P%pPP  "*Hhp xxp !GotoNew "$, J P 0B@HkoxAttribute VB_Name = "Form_Employ@ees" Bas0{62C19B64-66D9-4279-BA85-F44C7D4E117B} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TeateDerivCustomizD$Option Comp@ DT  Show Navigation Pane Search Bar    09.50 ~ w             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 ~ w             F   Office Theme LVALe>aѷ(<S<S<<N0{20F1E314-6603-4C24-B0CC-0A8D11060600} 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 (kkox5Attribute VB_Name = "Form_Report DalRange" Bas0{20F1E314-6603-4C24-B0CC-0A8D1H1060} |G lobalSpacIFalse dCreatab"lTru Pr@edeclaId"Expose_TemplAqDerivCustomizD$Option 0Comp@ab  [V5 { 5AM6 -8be ger than +g I6t7K8AVisiğ)x IffB {V~u@I~u@M6 @RZYDMCCUMUKXTDCIHFACLQSDTBJLb^Z" LVAL FM}>ѷ(<S<S<<N0{87AF5B77-85C0-4215-85E7-2530766EFBE1} 8Pi| p$0%Ppp  " @ Xh xxp5There is no data for this report. Canceling report...A@>'|\WioxdAttribute VB_Name = "Report_endee Listi ng" Bas0{87AF5B77-85C@0-4215E7-2530766EFBE1} |@GlobalsSpacIFalse dCreataDblTru Predecla Id"Expo se_TemplateDerivCustom izD$Option Comp@ DT  kxME+Pi*@,L@.LX B  R  p    xpK Returns True if the specified form is open in Form view or Datasheet view.]p] 2  *$0 , *$j!4 .'k(k ixuAttribute 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$6NL } : V -  q @  x I  b + _4JF~QVenues<Total Registrations by AttendeeHD;Sum Of Payments Query40Registration"PaymentsPayment Methods($My Company Information62MSysResources$ MSysNavPaneObjectIDs2.MSysNavPaneGroupToObjects<8MSysNavPaneGroups,(MSysNavPaneGroupCategories>:VMSysAccessStorage,(PFee Schedules$ If_888CBB6625DE46E19F33AE1C70E7D2D9_DataXTAEvents=Event Types 8Employees1Attendees:Attendee 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&"EventsEvent Types  Event Fee Schedule Subform>: Employees AutoEvents Attendees Subform,( Attendees'MSysComplexType_Attachment>:%MSysComplexType_Text2.#MSysComplexType_Decimal84!MSysComplexType_GUID2.MSysComplexType_IEEEDouble>:MSysComplexType_IEEESingle>:MSysComplexType_Long2.MSysComplexType_Short40MSysComplexType_UnsignedByteB>MSysComplexColumns.*MSysRelationships,(MSysQueries MSysACEsMSysObjects {V落~u@ܘ~u@N@FKGZMEKCEEYBYDSUTGFCHSBPZENDb^Z" {V%~u@I~u@O}@TWXOEXGMKQNMUDVTSDDRBFGKYCQIb^Z" ELVALU A>Vѷ(<S<S<<N0{6EEF0E36-292B-4F4B-A83C-1381126C7840}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{6EEF0E36-292B-4F4B-A83C-1381126C7840} |GlobaBlSpacFalse dCre atablTru PredecdlaId"E`xpose_TemplateDerivCus`tomizD$Option Codmp@ DT    ,IfA {V\~u@֘~u@P@ BJKKNDHSSMYCSDXDEBZZLDUKRCVMb^Z" LVAL% Y>ѷ(<S<S<<N0{BC4B7433-C2E8-461F-8862-905A6A793E8E}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{BC4B7433-C2E8-461F-8862-905A6A793E8E} |GlobaltSpacAIFalse dCreatablTru PredeclaId"Expose _TenateDerivCus`tomizD$Option Codmp@ DT   ѷ(<S<S<<N0{7BDA5C74-D965-439E-B792-AC515D27CD77}p 8pPi| < >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{7BDA5C74-D965-439E-B792-AC515D2@7CD77} |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_ttenesBVBHUJIMVIYKZPDKOJZISNZBXQKBG28NHUJPMV@YKZP)K EJ` ISNBHXQBDH 1x-`w",*""(+ Sub#mG,a ``ubfdLZLQNQHDUFDKSDMDRBWJLWTWITF_LLN`H`UF"SM`R@HW LWT`IF +,% M6Employ6E7pHoy6e6SGAFUXBSGSMFAEZWBBOMKSYEVHCJS`0A`U`2B`"G`MAE WB7M5SY`V`56C i;6EventP Typ!Q *6ETv nQ (y pJMXDXFBEYFWOBENSDKNDKCEKAFKBQJMD`FU E F`1ObN DN5KC`K^F Bb]4˰ @kSFPBSYTNVDLNMHOICOBTFNFIDDE2YNjDLgM/jOkE`SATm5N`!DR M%Fee Schedbu@G$F1ehceueSIUTKLBMXAXWZDBUEWQKJVMGHQQI'jIBT`L`AUW@'DUp WU 6K&VGpQI// ѿ 1 PPaym'MethodEF Pa4Vm0(MtpopWEFMThTORHXDTBKNML_WUIPDJJNW0 F T%a&T4Rp X'T0KLAWJN)p gpkw"Q A 0^tvBIIPVMYLOIDFEHEVZRPGEKPCLCUSE I@'jP`(M4L FUH0V@R^GUKpC*C SKBm((D(PripBInvo`~(PrTi 0 npCo c 3]MFMLNSBSJMWXGEEERFJYGNCZGGOM NM5S`S@*MBXQE ER5JpGCGO Mo6ijQ(Registr|Gw(R@ g r0)to SRPCPQFGIZEADENDYBTTNPESSXJDS PPBP3F@ I E(QBOYTEP*SQXE()3L]@ HyReportQe RangeMy p)ZtDD 1ERngRZYDMCCUMUKXTDCIHFACLQS07JLRp ZYP5M'M'KUDT0C@!HAo{z7J}a^GlobpCod ^G2xb l C df FKGZMEpjEYBYDSUTGFCHSBPZc 1hG MikB'DjUG C Dq*PKa`Dm(Hk!0'Փ3stingG. z iD1)3)TWXOEXGMKQNMUDVTSD0FGKYCu_UAXDEG@4Kհ)NpUV Dp+BGaYpQ0OFD(_0CBJKHSS@MYCSDXyZZLDUKRCVCB3Kp 4H`^S 1 q ^E06ZՠL UpR mE ٿ'V $Say bDy G0S)a y) RDKMMFIEUOLTEEDBMMUZEMOBDBYRP K!SI`*ULPRUq{MU)MBDBYJHP18`HP,D"0(+Report_Sales by Event Ty peG4>eport_Sal"s byQEvn TTp BSYAXJKXAFVAIENMEQYADXISR@TVK28[BAOYAXKAAFVI@ENMQQADI+RaVK$y:VĘ~u@ܘ~u@T @&dir0,(" LVAL6)a  *\G{000204EF-0000-0000-C000-000000000046}#4.1#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA7\VBE7.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#9.0#0#C:\Program Files\Microsoft Office\Office14\MSACC.OLB#Microsoft Access 14.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\Windows\system32\stdole2.tlb#OLE Automation*\G{00000205-0000-0010-8000-00AA006D2EA4}#2.5#0#C:\Program Files\Common Files\System\ado\msado25.tlb#Microsoft ActiveX Data Objects 2.5 Library\*\G{4AC9E1DA-5BAD-4AC7-86E3-24F4CDCECA28}#c.0#0#C:\Program Files\Common Files\Microsoft Shared\OFFICE14\ACEDAO.DLL#Microsoft Office 12.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.3Z`I]  >8VBHUJIMVIYKZPDKOJZISNZBXQKBG944ea58d33'Form_Attendees 8LZLQNQHDUFDKSDMDRBWJLWTWITF_954ea58d33s,Form_Attendees SubformM% 8SGAFUXBSGSMFAEZWBBOMKSYEVHCJ964ea58d33Form_Employees;0 8JMXDXFBEYFWOBENSDKNDKCEKAFKB974ea58d33 Form_Event Types˰H 8BSYTNVDLNMHOIENSCOBTFNFIDDEB984ea58d33Form_Events%` 8SIUTKLBMXAXWZDBUEWQKJVMGHQQI994ea58d33$Form_Fee Schedulesx 8WEFMTACETORHXDTBKNML_WUIDJJN9:4ea58d33(Form_Payment Methodsg 8IIPVMYLOIDFEHEVZRPGEKPCLCUSE9;4ea58d33Form_Payments%m 8MFMLNSBSJMWXGEEERFJYGNCZGGOM9<4ea58d33$Form_Print InvoiceM8SRPCPQFGIZEADENDYBTTNPESSXJE9=4ea58d33"Form_Registration@)8RZYDMCCUMUKXTDCIHFACLQSDTBJL9>4ea58d33!,Form_Report Date Rangea8FKGZMEKCEEYBYDSUTGFCHSBPZEND9?4ea58d33(Global Codekm8TWXOEXGMKQNMUDVTSDDRBFGKYCQI9@4ea58d337.Report_Attendee Listing 8BJKKNDHSSMYCSDXDEBZZLDUKRCVM9A4ea58d33;Report_InvoiceV88RDKMMFIEUOLTEEDBMMUZEMOBDBYJ9B4ea58d33A0Report_Sales byLVAL* EmployeeP8BSYAXJKXAFVAIENMEQYADXISRTVK9C4ea58d33C4Report_Sales by Event Typeh HPx0h8`j~dJ !ZE$go@i|wux$HJLD܃MY@K #_V]C4@o`*tO&qD5GUq&$@={;MQy: Sb;QFO !ttA^ V=Iߝ+1ՏPqHIpUN[FqZw〗yK=/ RMIJc5KVvִ-lH- _xFAccessVBAWin16~Win32Win64xMacVBA6#VBA7#Access Conference 7stdole`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_DblClickErr_FeeScheduleID_DblClick lngFeeScheduleID? Exit_FeeScheduleID_DblClick|F 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  "$'%. VĘ~u@֘~u@S#(6_VBA_PROJECTB>:" V7ʘ~u@֘~u@U@&PROJECTwm<84" . LVAL> ID="{437FB8D4-D472-4105-B8A6-21815ECB25FA}" 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 7" HelpContextID="0" VersionCompatible32="393222000" CMG="85875268BE9AC29AC29AC29AC2" DPB="BBB96CA6A3A7A3A7A3" GC="F1F326CB27CB2734" [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 VnИ~u@֘~u@V@-PROJECT840" V ~u@I~u@B AcessVBADataNJF. ˏTables "w