Standard Jet DBnb` Ugr@?~1y0̝cǟFN7]D^(`T{6߱wCϯ34ay[|*|OJl>`&_Љ$g'DeFx -{NteaR]!!@ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o    ۇ O8V#jKrvwlrV#jKV#jKV#jKV#jKM qؓ V#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   * *ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o *  ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   Tۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o  Tۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   ۇ O8V#jKȴOݏ ToV#jKV#jKV#jKrvwlrV#jKV#jKV#jKV#jKV#o   VCS           2c   ct    j    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni )L Id ParentIdName        - - - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV VCZS     2  ObjectIdSIDACM FInheritablebc ObjectId      2 +rptSalesByEmpCust.tblCustomers.CustomerName tblCustomers,rptSalesByEmpCust.tblEmpCustAlias.EmployeeIDetblEmpCustAliasrptSalesByEmpCust.tblEmpCustAlias.LevelrptSalesByEmpCust.tblEmpCustAlias.ColumnAlias -=N:@   X+ BX+ X+ X+rptSalesByEmpCustxtblEmpCustAlias k4z@ tblCustomers   Œr@4~sq_drptSalesByEmpCust~sq_dsrptCustomerHeadings X ` `h p `  X+ BX+ X+ X+ tblEmpCustAliastblCustomers  2 r  `BX+ X+ X+tblEmpCustAlias B      `X+tblCustomers ( P  x   __EmployeeIDP  __Levelx   8 @P`p                                                           p      |VC?.S  .           ObjectId AttributeOrderName1Name2 ExpressionFlagilnzjtz ObjectIdAttribute  hPh2Hx Hx 8HxtblEmpCustAliasPrimaryKey tblCustomers0@PrimaryKey CustomerID ` p ` PrimaryKeyv `Pv  sH h0 (8tblEmpCustAlias`( 0@dpt x  [__Level] Level`xPh x PrimaryKey P [__EmployeeID]    tblCustomers PrimaryKey  PrimaryKey 8( PrimaryKeyVCS            szRelationshipgrbitccolumnicolumnszObjectszColumnszReferencedObjectszReferencedColumn   szObjectszReferencedObjectszRelationship- - - - - - - - - - - - - - - -  -  -  -   -!  -" - -*xx-,---.-/x-+x xxxxx `hh {qg]SI?5"@Ao{z< Cy xPb0F?CyCyCyhCy ACy CyPCyhCyCyCy@CyXCyCy0Cy0Cy0CyCy CyPCyhCy 2      2 tblCustomers.CustomerName tblCustomerstblEmpCustAlias.EmployeeID%tblEmpCustAliastblEmpCustAlias.LeveltblEmpCustAlias.ColumnAliasxCypCy@CyPCy xCy3)9@CyCy xCyCy Cy0W  Cy0W PCy0W hCy0W tblEmpCustAliasxCy8CyhCy CyxCyk4z@ tblCustomersPCy0Cy@Cy CyxCyŒr@~sq_rsrptCustomerHeadingsCyCy CyCy Cy Cy @Cy(Cy XCy0CyCyCy@CyXCy Cy0W PCy0W hCy0W tblEmpCustAlias CyCy PCy Cy hCy(CyCy@CyXCyCy0W tblCustomers CyCyCy CyCyCy xCy@CyPCy`CypCyCyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCy CyCyCyCy Cy@Cy Cy Cy Cy Cy Cy Cy  Cy Cy |Cy CyCyCyCyxCy CyW Cy Cy|Cy CyCy o{ @ @ @ @ @ @  - - - - - - -  -  -  - -  -  -  - - - - - - - - - -  Cy CyH Cyx Cy Cy CytblEmpCustAliasCyPrimaryKey tblCustomersCyCyPrimaryKey CustomerID Cy0CypCy Cy @Cy CyCyCy Cy`Cy PrimaryKeyCyCyv 0Cy CyCyv CyCy8CyCyCysCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCyCy`Cy CyCyHCy CyCyhCyPCytblEmpCustAliasCyhCyCyhCy0CyCy`CyCy tblCustomers PrimaryKeyCytCyCytCyCyCyCy0CyCytCyCy CyCyCy PrimaryKey0CyCy PCyCyCyCy@Cy PrimaryKeyD @ @@@guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvbrs}rgwamfosbxvw`mj`vov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvt`ssfosbxvwtvuswburvvw`at|wafosbxvwv`mfvwambxvwrofuvwamfosbxvw`mj`vwamfosmr}ffvwamv`mfv~wamf|sm`p`wjrp`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfdtblEmpCustAlias.CustomerID = tblCustomers.CustomerID(([__EmployeeID] = EmployeeID)) AND ([__Level] = Level)SELECT tblCustomers.CustomerName, tblEmpCustAlias.EmployeeID, tblEmpCustAlias.Level, tblEmpCustAlias.ColumntblEmpCustAlias.CustomerID = tblCustomers.CustomerID(([tblEmpCustAlias.CustomerID = tblCustomers.CustomerIDtblEmpCustAlias.CustomerID = tblCustomers.CustomerID(((tblSales.SaleDate) Between [Forms]![frmReportSelect]![txtStartDate] And [Forms]![frmReportSelect]![txtEndDate]))tblSales.EmployeeID = tblEmpCustAlias.EmployeeIDtblSales.CustomerID = tblEmpCustAlias.CustomerIDtblEmployees.EmployeeID = tblSales.EmployeeIDtblCustomers.CustomerID = tblSales.CustomerIDtblEmpCustAlias.ColumnAlias In ("A","B","C","D","E","F","G","H")(((tblSales.SaleDate) Between [Forms]![frmReportSelect]![txtStartDate] And [Forms]![frmReportSelect]![txtEndDate]))o{~ zk\XI:6'teaRC  S Sۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o S = =ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o = 8 8ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o 8 4 4ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o 4 / /ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o /    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o      ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   Tۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o @ @ @ @          38<A[ "@"@rptSalesByEmpCust00000000000  "@"@basCreateColumnAlias33333333333 "@"@frmReportSelect...........  "@"@UserDefined***********  "@"@SummaryInfo***********  "@"@AccessLayout+++++++++++ "@"@SysRel%%%%%%%%%%% "@"@Scripts&&&&&&&&&&& "@"@Reports&&&&&&&&&&& "@"@Modules&&&&&&&&&&& "@"@Forms$$$$$$$$$$$ "@"@MSysRelationships22222222220 "@"@MSysQueries,,,,,,,,,,* "@"@MSysACEs))))))))))' "@"@MSysObjects,,,,,,,,,,* "@"@MSysDb''''''''''% "@"@Relationships.........., "@"@Databases**********( "@"@Tables''''''''''%  {qg]SI?LEINFOd dwSignaturedwStrucVersionl>dwStrucVersionh>@  @ @ @ @ @ @ @ @ @ @ @********* ************ *!*"*#*$ *% *& *' *( *) ** *+ *, *- l l l l l lllll l l lll lllll*.llllllll 3l3l3l8l8l 8l!<l"<l#<l$Al%AoAo[o[o[o****** * * * ***eee3`h%qLPuUueU3`n%rPUueUu20_%Puueeeeu20_%tHP5uueeeex2`g%+Peeeeue!3%0PUueeEE!30;%1DPUueEEu!3`M%2Peeee5uu3pe%8Puueeeee 3`t%9@PueUueE 3`d%:PEeeeueU 3`e%;PB @ @ @ @ @ @ 1 1 1 1 1 1 1  1  1  1 1  1  1  1 1 1 1 1 1 1 1 11111111111 1!1"1#1$1%1&1'1( 1) 1* 1+ 1, 1-1e@j 'e@j 'e@j 'e@j 'te@j 'te@j 'te@j '  qselXtbDemo.ColumnField/ g qselXtbDemo.RowField, gTotal Of NumericFieldSum(qselXtbDemo.NumericField)J!! oThe ValueSum(qselXtbDemo.NumericField)> oqselXtbDemo.ColumnField/ b3B@NL@~TMPCLP560531@:::......., @ ~Y@~Y@~sq_rrptXtbDemo *@HHH<000000. `@MSUDOHP LaserJet 4Si<d d278d eTimes New Romane24fg37jghm5CArialn=Arialo3AArialp4RowField` ReportHeaderd2`<a<bc dLabel16Cross Tab Demo Report` PageHeader d`<a<bc;RowField LabelRowField DetachedLabelRowField_Labeld7`` a<bc; Column1 LabelColumn1 DetachedLabel Column1_Labeld7` a<bc; Column2 LabelColumn2 DetachedLabel Column2_Labeld7`a<bc; Column3 LabelColumn3 DetachedLabel Column3_Labeld7`a<bc; Column4 LabelColumn4 DetachedLabel Column4_Labeld7``a<bc; Column5 LabelColumn5 DetachedLabel Column5_Labeld7` a<bc; Column6 LabelColumn6 DetachedLabel Column6_Labeld7`a<bc; Total LabelTotal DetachedLabel Total_Labelf2`<awb7#Line19`Detailm`<a<bcRowFieldRowFieldm;`` a<bckColumn1Column1m;` a<bckColumn2Column2m;`a<bckColumn3Column3m;`a<bckColumn4Column4m;``a<bckColumn5Column5m;` a<bckColumn6Column6m;`a<bckTotalTotal` PageFooterm ;<`<abc,i jText17=Now() Long DateTimes New Romanm ;<`abc,i jkText18$="Page " & [Page] & " of " & [Pages]Times New Romanf2`<ab$Line20`H ReportFooter m;`` axbcText21=Sum([Column1])m;` axbckText22=Sum([Column2])m;`axbckText23=Sum([Column3])m;`axbckText24=Sum([Column4])m;``axbckText25=Sum([Column5])m;` axbckText26=Sum([Column6])m;`abc,jkText27 =Sum([Total])f2`xb7#Line36da<bc;Label37Totals DetachedLabeld7`abc;Label38 Grand Total     ͬfTDESTDetailFormHeaderFormFootermPKd PK_LabelPK LabelmRowFieldd RowField_LabelRowField LabelmColumnFieldd ColumnField_LabelColumnField Labelm NumericFieldd NumericField_LabelNumericField Labelm CriteriaField1d CriteriaField1_LabelCriteriaField1 Labelm CriteriaField2d CriteriaField2_LabelCriteriaField2 LabelmCriteriaField3d CriteriaField3_LabelCriteriaField3 Labelͬ$,'!)枙ReportHeaderdLabel16PageHeaderdRowField_LabelRowField LabeldColumn1_LabelColumn1 LabeldColumn2_LabelColumn2 LabeldColumn3_LabelColumn3 LabeldColumn4_LabelColumn4 LabeldColumn5_LabelColumn5 Labeld Column6_LabelColumn6 Labeld Total_LabelTotal Labelf Line19 Detailm RowFieldmColumn1mColumn2mColumn3mColumn4mColumn5mColumn6mTotalPageFootermText17mText18fLine20ReportFootermText21mText22mta5@ taMSysObjectsCStr(Database)"3ta DetachedLabelQ]u=i-<8CkAt(N[Dl@K l@ztblExplanationZ@p<<<0000000. @Ar@ʆ!s@tblSales@p555)))))))' @<r@er@tblEmployees@n999-------+ @8mr@k4z@tblEmpCustAliasW@n<<<0000000. @3Ir@Œr@tblCustomersq@n999-------+ @k 3>@>@qsrptCrosstab@h@@/F::......., @ >Gs@iyet@@qappEmpCust\@h@/D88,,,,,,,* @D*r@`r@MSysModules2----------+ `r@`r@MSysModules,,,,,,,,,,* b=@=@Copy Of tblEmpCustAlias@hDDD88888886 @k Gs@etʏ@rptSalesByEmpCustb@jLWF000i\P>>2222220  }~Us@v@basCreateColumnAlias55555555553 (JCt@tv@frmReportSelect0000000000.  pr@pr@UserDefined,,,,,,,,,,*  pr@pr@SummaryInfo^@h888,,,,,,,* @ t@oT@AccessLayout*@h@/E99-------+ @r@r@SysRel''''''''''% r@r@Scripts((((((((((& r@r@Reports((((((((((& r@r@Modules((((((((((& r@r@Forms&&&&&&&&&&$ ;r@;r@MSysRelationships22222222220 ;r@;r@MSysQueries,,,,,,,,,,* ;r@;r@MSysACEs))))))))))' ;r@;r@MSysObjects,,,,,,,,,,* ;r@Tt@MSysDb@h333'''''''% @;r@;r@Relationships.........., ;r@;r@Databases**********( ;r@;r@Tables''''''''''% VC$N$$     2 EmployeeID CustomerIDLevel ColumnAlias  PrimaryKey t`0cP%`:d %t t $` )t`1fP%`:d %t t $` )t`y kzy1fP%`:d%t t $` )t`1fP%`:d %t t $` )t`1fP%`:d %t t $` )t`0cP%`:d %t t $` )t`-''' '@ F0 6 @0  {|$ (t`@0 Z^^K__SRP_9rU l$`0 ()`40&$i`8tpa{q01236c@/g(hij<k,E @ tblAboutDBAbout Database[Event Procedure][Event Procedure] d7ee1i14bcgfj14bcgfm49cgfn25hfo27fjfz5`X FormHeader1f23Ub%Line20`xDetail0e15]` abcBox19m 7U;`a8bBc ej COPYRIGHT COPYRIGHTr07ab8c;dggear1L_8ࡱ>   !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry F %9]ۻOle @ $yj[L=.zk\M>/ guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd `  "P H`  # 4v  B   #  ( 0 -8H P B X` h B<p   #   -  )Use database order for string comparisons@ B@frmSwitchboard B@h  9   B@sError BF AE @D ?C >B =A 8A 7F 6E 5D 4C 3B .A -D ,C +B *A )F $E #D "C !B  A B A F E D C B A E D  C  B  A @@@@@@@@@         !"#$)*+,-.345678=>? @!A"B# - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV VCEN __A__   2 EmployeeID CustomerIDLevel ColumnAlias t`0cP%`:d %t t $` )t`1fP%`:d %t t $` )t`y kzy1fP%`:d%t t $` )t`1fP%`:d %t t $` )t`1fP%`:d %t t $` )t`0cP%`:d %t t $` )t`-''' '@ F0 6 @0  {|$ (t`@0 Z^^K__SRP_9rU l$`0 ()`40&$i`8tp{$p$p $pp$$p$pH$$P $( `<j$H$pX@l   T @d @T  @ D H@ 4 0@ $ @    @ x X   8 @  @  P @  0@(  @ p @ 0@ @l  @  H@h @p X P @ VCe N            FlagsFormModuleNameReplicationVersionTypeTypeInfoVersion0Index1 t`0cP%`:d %t t $` )t`1fP%`:d %t t $` )t`y kzy1fP%`:d%t t $` )t`1fP%`:d %t t $` )t`1fP%`:d %t t $` )t`0cP%`:d %t t $` )t`-''' '@ F0 6 @0  {|$ (t`@0 Z^^K__SRP_9rU l$`0 ()`40&$i`8tp{qg @   guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvbrs}rgwamfosbxvw`mj`vov}v`bfvov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd)n Error GoTo_" Dim@ stDocAs Sng τ6DoCmd.Open߇%0Exizt<:*/ rr MsgBox err.DescriBIResu@R EndK WK# &8IX GIntPegerX@FuncA ] e;A9HDD7j$ 52xDBWindow_MouseDown(Butt,, Shift1, 4Single, YšH1"get back to the Main Menu, runmacro 'Autoexec'.", 64, "Remer#KKclm"# +-`*8vW/7S1!`Report?p L?qu#qCrit a_q 7'4&`Yr-'__SRP_60rU pyy[_ LVAL i_VBA_MODULEg%xpr $(LX(L6 << <<<<< LLLP8"*\Rffff*638e0c455*\R2*#28*\R2*#2d*\R0*#16*\R0*#10*\R0*#c*\R1*#1c*\R1*#8e*\R1*#8f8$ 03$ `$$$ P$ `t`p`&n`0h `hPX$x$PPhP$ @\pxP8$` l`fxPh$$P0$i  pppLVAL ppppppppppp0+`oLL $@ LVAL @ @ P(`xX P $  "BH@X @8H XPx 8@8 @( @ p`& @ @ @ @ h@ xHH HMEO B  B  * $@ h ,     B(  p    & #,\. "    Z+ #(  8  H   P (p @.#`      ( 0   LVAL   px xp f`Delete * from tblEmpCustAlias'  B@ZZ ".tblEmpCustAlias %$.Z qappEmpCust B@(54^Z C@.5456hnC@B..6N'0A'&ascii value of 'A' &$B:>C@FC@HC@JqfX & '&e54h B@R B@R6N 0_*eZZ ".tblSales %$.geC@FC@H54^ C@. Z6^$\ :ZC@BC@Jn..<=============================================================== Purpose:==# Copyright: 1999 Business Resultspda Company: Business Results  Phone: 715-835-8130& E-Mail: dhookom@invisibleinc.comHa Programmer: Duane Hookom Called From:== Date: 1/22/00== Parameters:==<============================================================ ZFor Error HandlingZZZZZDelete * from tblEmpCustAlias'n B@Rsu  B@' B@R81 ". ' 5456C@. :6N'0A'&ascii value of 'A'6N 0_C@FC@H & '&C@JhqA'&hn..hs`X PH !'r #: B@B  Error Description:  !'kZ@'54_  '54hZX 'qpx &A  8 qappEmpCust B@(!<create table of unique combinations of employee and customer &$B:>/assign alLVAL !ias A - whatevertblEmpCustAlias %$.00table used to redefine/alias the column headingsnC@C:\9tfil C:\boot.ini9")7This file already existsA@~ 5 sPaHfile not found - do other stuffh@Attribute VB_Name = "basCreateColumnAlias" Option Compare Datae0Explicit FuDncZUpdE@mpCust(pbytNums As Byte)Long ` '=8@ Purpose:Copyright: 1999 Business Resultsrny: Phone: 715-83130 E-Mail: dhookom@invisiblein c.comProgrammer: Duane HCalled Frombm=1/22/0 :Pa$eters= On Error GoT4o r_@) D@im strMsgrSng 'F@@HandliwI SQL3 inIn`tegerLpevellngIDő&q@ Max d^bA GX4rBRecordse_ 2 G __SRP_4rU~} qA!i i,KCp#fH%X"$ `X X,'8%lpFH%X"$ `X X58.:H%X"$ `X dX"cH%X"$ `X X  fX"$ QX`+X'%'(%'8%` QX\68( l\# 4k kY   4kY8:HLVAL? % $8"qh58 lApn(8:H % $8lhi]1(58\T  lg%:H % (#kn8 8:H % (58 d knpnknAf)l lApn   4kMTu2 K \  c=\ c=` XX lqX XX lqxX f8  \tp`X8(k__SRP_5nrU (`%p[_    O        IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni )L Id ParentIdName        - - - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV 2pBʦ+MSysDb #)%Form_frmReportSelect$IE951 *basCreateColumnAlias1--)%%LVAL1@ ͬ (DESTDetailmtxtStartDated Label1mtxtEndDated Label3h cmdPreviewReportd Label5d Label7nlboNumColumnsLVAL &i_VBA_MODULE?Tir u(DESTir ux6 pir uir u ..Mr4v8|<z@~DHpLD@[LS S6LLLL L= #1/22/00#) Th enMsgB0ox "fe m{ be ger than @k", vbOKOnly +QInfaE, "C ge$@Bv@7xitV7 End If22<22/112 1less02/20y0bC/ fbESbGjb1UpdXEmpAbAliaslboNumColumns:)p0*KgTrptSa 1ByDoCmd.Op enbg[, acDfUE"yD@V`Yre was T ehc@suting values. Can't run r."'CriticalX#Z XBqA'QaozEW: }rr4]$ .De0scri Resu8 a __SRP_2rU q 9  qq iq@41 a rrr@81 aY vvv@<  |||@ @y  zzz@DA9~~~@H 9 @LQ y ppp?K;9dt t LdT`@]XD4t5d\~9''4:$NDD@:TNdd 6dD489dt t LdT@]KD4t5d\9''4:$NDD@:TNdd 6dD48IDt t LDd  Lde4)t6Dd\9''4:$NDD@:TNdd 6dD485dt %LVAL1E t ` d^t5d Cx9'D%'d%lxFT%t" $ ` t t6dD69''4:$NDD:TNdd 6dD4<''4'D tt ,>Fd t6dD4 8t( {x(tdD4@[__SRP_3erU X$` pLVAL G 02=Babc,e gh4ij`'k(JCt@Report SelectionAriald2hgh MS Sans Serifm45n2`@ Detailm7U`,a txtStartDatem/d/yyyy #1/22/2000#d5U`,abcLabel1Start Date >-1/22/2000m7U`,ak txtEndDatem/d/yyyy #2/1/2000#d5U`,abcLabel3End Date <=2/11/2000h1U`,abcicmdPreviewReportPreview Crosstab Report[Event Procedure]d5U`ab cd Label5ݳThis Crosstab report creates an "alias" for each employee's customers. For each employee, the customer alias is A - H. The alias is used in a crosstab query as the column heading.Arialn03Wa bcd8l lboNumColumns Value List 2;3;4;5;66d5]` a,bHcLabel7Number of Columns'/o`QB qbO@1"s`QB>/     ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o      ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o      ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o     ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o     ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   LVAL ,i_VBA_PROJECTa^  *\G{000204EF-0000-0000-C000-000000000046}#3.0#9#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBA332.DLL#Visual Basic For Applications*\G{4AFFC9A0-5F99-101B-AF4E-00AA003F0F07}#8.0#0#C:\Program Files\Microsoft Office\Office\MSACC8.OLB#Microsoft Access 8.0 Object Library*\G{00025E01-0000-0000-C000-000000000046}#4.0#0#C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLL#Microsoft DAO 3.51 Object Library P8p(basCreateColumnAlias 638e0c455*DPr (Form_frmReportSelect 338e0c455*Dc(MP(xd(DEST(DEST@cy83 AccessAnd as=Dim@doGEndHEndifSfalse_Goto`IfyLoLVAL -ngzloop|MenotnothingSetThenTrueuntilwhilewith VBAWin16~Win32Mac DAO CrossTabfModule1b _Evaluate(UpdateEmpCustAlias_B_var_FunctionOstrSQLFDoCmdƧRunSQLdb\rs_ Recordset _B_var_set CurrentDbS OpenRecordset|intAlias OpenQueryMove>yMovef6- MoveFirstNlngEmpID# _B_var_DoEOFBOFy _B_var_IfPempIDIAsc!u ColumnAliasaP ColumnAliaChrK~ _B_var_Chr\;Edit+UpdateMoveNextL!Collect employeeIDs basCreateColumnAlias SetWarningsoff! UpdateDatesE UpdatableESaleDateRndRSaleIDՃ _B_var_Datev Form_frmReportSelect)FormDetail2 txtStartDateaLabel1, txtEndDate̿Label3,cmdPreviewReportcmdPreviewReport_ClickErr_cmdPreviewReport_Clickf stDocNamez OpenReport acPreviewoExit_cmdPreviewReport_ClickMsgBoxRErro Description ClickValueKvbOKOnly vbInformationnexiD _B_var_GoTo8<UpdateEmpCustAlias_Errv strErrMsg.UpdateEmpCustAlias_ExitNumber- vbCritical+}bytLevelBLabel5,Level bytMaxColumns7 _B_var_Exit_B_var_bytMaxColumnsո Form_Form16SigDisc=Text2~SigDisc_AfterUpdate AfterUpdateSigDisc_BeforeUpdate'Cancel BeforeUpdate6pbytNumColumnsm lboNumColumnsLabel7, Application* FileSearchD NewSearchfLookInPfilenamejExecuteYHcQ  $dirLVAL .0* pHdCrossTab,@ Z= n P8 EJ< DAO>BDA@O *\G{000@25E01-0C  0046}#4.0#0#C:\PROGRAM FILES\COMMON MICROSOFT SHARE D\w350.DLL#Micmoft 3.51 Object LibraryHAp basCreateColumnAl@ias _VBA_MODU LE2VDBt_MvDULEQ H1ΰ  ,7hr!+=Form_frmReportSelY<=M"-(B __SRP_0 K)^Form_frmReportSelectForm_frmReportSelectbasCreateColumnAliasbasCreateColumnAliasrU~~~~~~~~~~~~~~~~~E ir u  a qa a basCreateColumnAliasForm_frmReportSelectCrossTabF=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\VBA\VBA332.DLLVBA 9 a(J_N? 3C:\Program Files\Microsoft Office\Office\MSACC8.OLBAccess Qy8^F=C:\PROGRAM FILES\COMMON FILES\MICROSOFT SHARED\DAO\DAO350.DLLDAO Y HUpdateEmpCustAlias  Delete * from tblEmpCustAlias@ČF1BJIph)aN?I`GXGP qappEmpCust tblEmpCustAliasqm.1m. employeeID Level VBA332.DLL I`  ColumnAlias I fĤIx8<54 u54 u(DEST54 u@C7? txtEndDateEC7?cmdPreviewRepLVAL#M ortAC7?Label531?FormSC7?Detail txtStartDatecmdPreviewReport_Click TF;|? IS Change Start Date )Start Date must be greater than 1/21/2000 Change End Date $End Date must be less than 2/12/2000 (End Date must be greater than Start Date rptSalesByEmpCust Error 6There was an error computing values. Can't run report. Form_Form1BJ g uUJ g uCJ g uTJ g uText2SigDiscSigDisc_AfterUpdateSigDisc_BeforeUpdate L +You have entered a discount of less than 1%VJ g uXJ g uWJ g uy7 u|7 u{7 uKC7? lboNumColumns XZ;|?2 F C:\ *.txt This file already exists *.bat *.ini boot.ini C:\boot.iniir uir uir uC__SRP_12rU~~~~~~s   1  y   (  8 Q HCancelpbytNumColumns XTwLVAL @ @ @&qtblEmpCustAlias StblCustomers&qtblSales0:<=Babce hXiJjk_ ]w@SELECT tblCustomers.CustomerName, tblEmpCustAlias.EmployeeID, tblEmpCustAlias.Level, tblEmpCustAlias.ColumnAlias FROM tblEmpCustAlias INNER JOIN tblCustomers ON tblEmpCustAlias.CustomerID = tblCustomers.CustomerID;Arial8p4\\BRLH4\5SIXXLetter!p(H''''(e23winspool\\BRLH4\5SINe00:m5<Arial ColumnAlias`Detailm0<"ci j CustomerName CustomerName$#,##0.00;($#,##0.00)ʾtblEmpCustAliasqxtbEmpCustSalesfrmReportSelectrptSalesByEmpCustbasCreateColumnAlias@a`vbuf`wfbrmxop`mj`v#gruo,guoufsruwvfmfbw#ov}vda# t`0cP%`:d %t t $` )t`1fP%`:d %t t $` )t`y kzy1fP%`:d%t t $` )t`1fP%`:d %t t $` )t`1fP%`:d %t t $` )t`0cP%`:d %t t $` )t`-''' '@ F0 6 @0  {|$ (t`@0 Z^^K__SRP_9rU l$`0 ()`40&$i`8tp?.N|iVC!]#~\="qA"q>C  tblEmpCustAlias.ColumnAlias3 g tblSales.SaleDate) g tblEmpCustAlias.Level- g [LastName] & ", " & [FirstName]7 g tblSales.EmployeeID+ gs@2 'tblSalestblEmpCustAlias0@2/# tblSalestblEmpCustAlias0@2/# tblEmployeestblSales-@2,  tblCustomerstblSales-@2,  SumOfSaleAmtSum(tblSales.SaleAmt)9 oTotalSalesSum(tblSales.SaleAmt)7 o@@2 gtblSales.SaleDate) gtblEmpCustAlias.Level- gLastFirstName[LastName] & ", " & [FirstName]D otblSales.EmployeeID+ gtblSales tblEmployees tblEmpCustAlias tblCustomers  G G   tblEmpCustAliastblCustomers4@23'  tblEmpCustAlias.ColumnAlias3 g tblEmpCustAlias.Level- g tblEmpCustAlias.EmployeeID2 g tblCustomers.CustomerName1 g tblCustomers  tblEmpCustAlias   G  G     tblSales.CustomerID+ g tblSales.EmployeeID+ g s@2 ' CustomerIDtblSales.CustomerID5 w EmployeeIDtblSales.EmployeeID5 w tblSales   G tblEmpCustAlias O    LVALY_@ 1 1 1 1 1 1 (((tblSales.SaleDate) Between [Forms]![frmReportSelect]![txtStartDate] And [Forms]![frmReportSelect]![txtEndDate]))tblSales.EmployeeID = tblEmpCustAlias.EmployeeIDtblSales.CustomerID = tblEmpCustAlias.CustomerIDtblEmployees.EmployeeID = tblSales.EmployeeIDtblCustomers.CustomerID = tblSales.CustomerIDtblEmpCustAlias.ColumnAlias In ("A","B","C","D","E","F","G","H")tblEmpCustAlias.CustomerID = tblCustomers.CustomerID(((tblSales.SaleDate) Between [Forms]![frmReportSelect]![txtStartDate] And [Forms]![frmReportSelect]![txtEndDate]))VC$BN44$$$$   2 CustomerID CustomerName4647  CustomerID PrimaryKeyg tblEmpCustAlias.Level- g [LastName] & ", " & [FirstName]7 g tblSales.EmployeeID+ gs@2 'tblSalestblEmpCustAlias0 qYX @qYX @qxtbEmpCustSales///////////  qYX @qYX @qsrptCrosstab,,,,,,,,,,,  GVX @WX @@qappEmpCust*********** NX @GVX @MSysModules2+++++++++++ lIX @NX @MSysModules*********** .FX @lIX @Copy Of tblEmpCustAlias66666666666  ZLEX @ZLEX @srptCustomerHeadings33333333333  ZLEX @ZLEX @rptSalesByEmpCust00000000000  ZLEX @ZLEX @basCreateColumnAlias33333333333 ZLEX @ZLEX @frmReportSelect...........  ZLEX @ZLEX @UserDefined***********  ZLEX @ZLEX @SummaryInfo***********  ZLEX @ZLEX @AccessLayout+++++++++++ ZLEX @ZLEX @SysRel%%%%%%%%%%% ZLEX @ZLEX @Scripts&&&&&&&&&&& ZLEX @ZLEX @Reports&&&&&&&&&&& ZLEX @ZLEX @Modules&&&&&&&&&&& ZLEX @ZLEX @Forms$$$$$$$$$$$ ZLEX @ZLEX @MSysRelationships22222222220 ZLEX @ZLEX @MSysQueries,,,,,,,,,,* ZLEX @ZLEX @MSysACEs))))))))))' ZLEX @ZLEX @MSysObjects,,,,,,,,,,* ZLEX @ZLEX @MSysDb''''''''''% ZLEX @ZLEX @Relationships.........., ZLEX @ZLEX @Databases**********( ZLEX @ZLEX @Tables''''''''''% {q @ @ @ @ @  1 1 1 1 1 1 1  1  1  1 1  1  1  1 1 1 1 1 1 1 1 11111111111 1!1"1#1$1%1&1'1( 1) 1* 1+ 1,1 G G   tblEmpCustAliastblCustomers4@23'  tblEmpCustAlias.ColumnAlias3 g tblEmpCustAlias.Level- g tblEmpCustAlias.EmployeeID2 g tblCustome@ 3$t`L8$p\H4  lXD0guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvbrs}rgwamfosbxvw`mj`vov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvt`ssfosbxvwtvuswburvvw`at|wafosbxvwv`mfv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd BCustomer 66ACustomer 65@Customer 64?Customer 63>Customer 62=Customer 618Customer 567Customer 556Customer 545Customer 534Customer 523Customer 51.Customer 46-Customer 45,Customer 44+Customer 43*Customer 42)Customer 41$Customer 36#Customer 35"Customer 34!Customer 33 Customer 32Customer 31Customer 26Customer 25Customer 24Customer 23Customer 22Customer 21Customer 16Customer 15Customer 14 Customer 13 Customer 12 Customer 113 @ @ @ @ 5 5 55555555 5 5 5  5 !5"5#5$5)5*5+5,5-5.5354555657585=5>5?5 @5!A5"B5#qYX @qYX @qsrptCrosstab,,,,,,,,,,,  GVX @WX @@qappEmpCust*********** NX @GVX @MSysModules2+++++++++++ lIX @NX @MSysModules*********** .FX @lIX @Copy Of tblEmpCustAlias66666666666  ZLEX @ZLEX @srptCustomerHeadings33333333333  ZLEX @ZLEX @rptSalesByEmpCust00000000000  ZLEX @ZLEX @basCreateColumnAlias33333333333 ZLEX @ZLEX @frmReportSelect...........  ZLEX @ZLEX @UserDefined***********  ZLEX @ZLEX @SummaryInfo***********  ZLEX @ZLEX @AccessLayout+++++++++++ ZLEX @ZLEX @SysRel%%%%%%%%%%% ZLEX @ZLEX @Scripts&&&&&&&&&&& ZLEX @ZLEX @Reports&&&&&&&&&&& ZLEX @ZLEX @Modules&&&&&&&&&&& ZLEX @ZLEX @Forms$$$$$$$$$$$ ZLEX @ZLEX @MSysRelationships22222222220 ZLEX @ZLEX @MSysQueries,,,,,,,,,,* ZLEX @ZLEX @MSysACEs))))))))))' ZLEX @ZLEX @MSysObjects,,,,,,,,,,* ZLEX @ZLEX @MSysDb''''''''''% ZLEX @ZLEX @Relationships.........., ZLEX @ZLEX @Databases**********( ZLEX @ZLEX @Tables''''''''''% 3 @ @ @ @ 5 5 55555555 5 5 5  5 !5"5#5$5)5*5+5,5-5.5354555657585=5>5?5 @5!A5"B5# Id ParentIdName        - - - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV VC$N99$$     2 EmployeeID CustomerIDLevel ColumnAlias9;  PrimaryKey a{q 8$yj[L=.zk\M>/ @guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvbrs}rgwamfosbxvw`mj`vov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvt`ssfosbxvwtvuswburvvw`at|wafosbxvwv`mfvwambxvwrofuv`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd BF AE @D ?C >B =A 8A 7F 6E 5D 4C 3B .A -D ,C +B *A )F $E #D "C !B  A B A F E D C B A E D  C  B  A 8@@@@@@@@@ : : :::::::: : : :  : !:":#:$:):*:+:,:-:.:3:4:5:6:7:8:=:>:?: @:!A:"B:# - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV VCN==   2  2 EmployeeID FirstNameLastNamen=?{=@  EmployeeID PrimaryKey {q @@y< @ @guoufsruwvfmfbwa`vbuf`wfbrmxop`mj`vuswv`mfva}fosbxvwvuswbxvwrofuif`djphvd`w`a`vfvgruovordxmfv ufm`wjrpvijsvufsruwv vbujswv v}vufm w`amfvbrs}rgwamfosbxvw`mj`vov}v`bfvov}vordxmfvov}vordxmfvXov}vrakfbwvov}vtxfujfvov}vufm`wjrpvijsvt`ssfosbxvwtvuswburvvw`at|wafosbxvwv`mfvwambxvwrofuvwamfosbxvw`mj`v`bbfvvm`}rxw ov}vdavxoo`u}jpgrxvfudfgjpfd TedBahr JoanArc FredCash BillJohnson RachelCarson JoeSmith < @>>>>>> < @>>>>>>       IdParentIdNameType DateCreate DateUpdateOwnerFlagsDatabaseConnect ForeignName RmtInfoShort RmtInfoLongLvLvPropLvModuleLvExtrasetni )L Id ParentIdName        - - - - - - -  -  -  -   -!  -" - -#krf bvojwikrf dvojwikrf fvojwikrf@`vojwikrf@a&vojwikrf@bvojwikrf@dvojwikrf`  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV VCkkNBBk$kkk      SaleIDSaleDate EmployeeID CustomerIDSaleAmt{BKBPBU  CustomerID EmployeeID PrimaryKey S{qg AH~dJ0z`F,v\B(rX>$ nT: jP6fL2 H@G@TF@LE@OD@ C@ XB@*A@Z@ @ L? @ G>`@ T=`@^<@L;@ :@ Y9@ 88`@^7@ *6@ b5 @-4`@S3 @ )2`@ V1@:0`@ ./@ Z.@U-@G,`@O+ @<*@7)@>(@$'@ 8&@ B% @$@ #@-"@ !@ J @ @ a@ T@@@@ 0 @ ?@ @ J@&`@a@]@@ U@8@ @\@ @@ `@ @ `@ ( `@ B @J @ (@@ V`@ [`@N @V @ @ ,@ W @ CAH~dJ0z`F,v\B(rX>$ nT: jP6fL2@:@ @`@ (@@=@ a@ <@ X @ +@ @@ '@I @@@P@ V@ @ R~@Q}`@*|@ { @ Iz@ y@ Qx@ w`@ !v@ @u@Vt@@ Us@ r`@ _q@p`@ o@ n@ 7m@ l@+k@ Oj@ i@ %h@ Wg@'f@Xe@@0d`@ @c@ b@ 7a@ 1`@^_@ ^`@ O]@@ W\@W[@=Z@ 1Y @MX@FW@XV@ cU`@"T@ QS@CR @]Q@VP@$O`@ !N@ 'M@ L@K @QJ@@I`@ FAH~dJ0z`F,v\B(rX>$ nT: jP6fL2 @@Y@X @'@@F@M@6`@E@@-@T`@P@) @E`@;@\@@R@@@ @B@A@`@@S@>@@@H`@@@E@+@Y@'@@*@/@]@&@-`@@ 4@+@  @;@ 9@@ $@8@ @@*`@ @@ @2@0@ @ `@ " @3`@-@ A@ @ [@@@ :@ @@@K@@ 1@ @3 @KAH~dJ0z`F,v\B(rX>$ nT: jP6fL2 @"(@/@ ?@$4@# `@$ @@6@">@#N@$ @$8@ Q@$A@ @!I@G@@$S@#@# @  @ V @@ I @#U @@!:`@"O @$`@!K@#0@#^`@ 4@!S`@"1 @#\@!X@ [@@#&@#`@&@@@@ (@#<@ ,@$ @ @@@#@$@$K@#@$@ ]@@ H`@ $@$@#K@G@V`@6@ `@O@a@@ @C@.@ @J@@0@`@@@@K @ @&AH~dJ0z`F,v\B(rX>$ nT: jP6fL2h`@$Ug@!`f@ `e@@#d@ c`@ ]b @!4a@!`@ A_@@$4^`@!]@@#T\@![@ Z@"_Y@ 7X @#W@FV@/U@#WT@>S`@XR@@"Q@#)P@!#O@"YN@$M@"L`@1K @#"J@@!'I@ >H@ /G@ %F@E@$]D@#+C@$#B`@!bA@_@@")?@">`@$=`@#3< @!;`@#:@#9@"D8`@#'7@ 6@"5 @$E4`@!3@$G2 @!`1`@"80@@ X/@$.@$M-`@"a, @$6+@[*@ b)@#E( @!G'@@$7&@#% @$@# #@""@#A!@cAH~dJ0z`F,v\B(rX>$ nT: jP6fL2@<`@ (@#@@@ !@!]@"B@#@#W@@$*@ [`@!?@#c@ L@$G@S@@ 3 @!)`@!1`@#@#!@=@";@#" @#@G@!@$>@#`@#F @#@"5`@Z@#@`@#C@"U@$A@" @#@ @"@$ @$@"0@ E@!@ Q@T@[`@#]~@@$!}@ |@@#5{@"Oz@ ;y@"Qx@#3w@Mv@!cu@ <t@#%s@#r@=q@$Dp@$o@# n@!m@$l`@#\k @#1j @!Ji@@AH~dJ0z`F,v\B(rX>$ nT: jP6fL2 @!Q@ @! `@ @@ G@$+@!O@@ H@#" @`@!8@@"0@!3@ U @$@!]@"U@!A@@ @"@$B@@ 9@ `@$@ #@@#a`@";@$`@$+@@! @O`@ A @"M @"M@#`@"  @$D@!@!F @$@@ 3`@!  @"L@" @!@#5`@Y`@ @5@"@!@$^@#<@#a@#7@!`@$ @!/@@"M@#_@@!N@@#@!9`@@!b@#R @#a`@"=`@BAH~dJ0z`F,v\B(rX>$ nT: jP6fL2@@"?`@#/>@=`@ %<@ #; @"Z:@!Z9@@a8@$7`@]6 @"B5@ 64@!A3`@!V2`@#D1@#`0 @/@".@!^-`@#,@!]+@$*`@"F)@"U(@$''@ &@"1%@5$@$H#`@$)"`@#M!`@#@  @"0@@$I@$-@@!@!8@#O@!U@@"`@@$F`@$@! @#W@$9@";@ @$@ `@#W `@" `@ ) @" @! `@"@"`@##@#/@ 2@ c@!G@"P@!Y@@ U`@#I@` @# @$@R`@AO  J L$aM@gN C C C C# C= C> C? CB D D D D D$ D% D* D+ D0 D1 D3 D6 D= E E E E E C C C C% C& C/ C5 C6 C8 D D D D D D D D D D! D' D) D- D. D2 D7 D8 D> D@ DA DB E E E E E E E C C C C C C C C C! C. C1 C2 C9 C: D D D D" D& D? DD E E CC CC;C@CFDDDD DDDDD(D4D:D;DCDGEEEE EEEEEECCCCCC"C$C(C0C4C7CCCEDD DDD,D<DEEEE EEEC C CCC'C)C*C+C,C-C3C<CACDCGDD DDDD#D/D5D9DFEEEE)E,E4E;EEEGFFFFE"E$E(E-E0E3E7E=E>E?EDEFFFE!E&E+E2E6E:EBFFFE#E/E@EAECF FFE'E*E.E5E8E9E<FFF E%E1F F F F!F"F8FAFFGGG GGG G%G+G2G3G5G6GCHH HHHHH H'H.H2H8HDHGIIIIIII'I/I1I=ICJJJJJJJ,J7J>J@JE````````#`$`(`)`-`4`<`>aaaa#a3a;aCbb F F F F F F F% F* F2 F3 F4 F: F< FE G G G& G' G( G8 G: G? GB GE H H H H H H7 H: H= HC HF I I I& I- I0 I4 I9 I? IB ID IF J J J AMB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B! C C C C C C C C C C C# C= C> C? CB D D D D D$ D% D* D+ D0 D1 D3 D6 D= E E E E E C C C C% C& C/ C5 C6 C8 D D D D D D D D D D! D' D) D- D. D2 D7 D8 D> D@ DA DB E E E E E E E C C C C C C C C C! C. C1 C2 C9 C: D D D D" D& D? DD E E CC CC;C@CFDDDD DDDDD(D4D:D;DCDGEEEE EEEEEECCCCCC"C$C(C0C4C7CCCEDD DDD,D<DEEEE EEEC C CCC'C)C*C+C,C-C3C<CACDCGDD DDDD#D/D5D9DFEEEE)E,E4E;EEEGFFFFE"E$E(E-E0E3E7E=E>E?EDEFFFE!E&E+E2E6E:EBFFFE#E/E@EAECF FFE'E*E.E5E8E9E<FFF E%E1F F F F!F"F8FAFFGGG GGG G%G+G2G3G5G6GCHH HHHHH H'H.H2H8HDHGIIIIIII'I/I1I=ICJJJJJJJ,J7J>J@JE````````#`$`(`)`-`4`<`>aaaa#a3a;aCbb F F F F F F F% F* F2 F3 F4 F: F< FE G G G& G' G( G8 G: G? GB GE H H H H H H7 H: H= HC HF I I I& I- I0 I4 I9 I? IB ID IF J J J ALNB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B! J J J. J< JC JD ` ` ` ` ` `' `* `3 `7 `; `B a a a a a a a a a a% a' a/ a= a> a@ aA!F&!F)!F-!F0!F9!G!G!G!G!G!!G)!G/!G;!G=!G@!GA!GF!H!H!H !H!H-!H5!H6!H#J#J#J #J#J#J#J"#J(#J)#J4#J8#J9#JF#`#`#`#`"#`&#`+#`/#`1#`8#`C#`E#`G#a#a #a #a#a$#a&#a)#a1#a6#a9#aF#b#b#b$F$F$F$F$F$F.$F7$F;$F=$F>$FB$FD$G$G $G $G$G$G$G$G"$G$$G-$G>$GG$H$H$H$H$H$H#$H,$H9$H>$I $I$I$I!$I)$I*$I.$I2$I8$IA$J$J$J$J$J$J%$J&$J*$J+$J/$J2$J?$`$`$`$`$`$`!$`,$`0$`:$`?$a$a $a $a1AMOB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!$a$a$a($a*$a-$a4$a8$a?$aD)b)b)b%)b+)b,)b0)b9*b *b*b*b"*b$*b'*b(*b2*b7*b=+b +b+b)+b*+b3+b4+b?,b,b,b,b,b,b ,b!,b&,b-,b.,b<,b>-b-b-b-b-b-b/-b6-b;.b.b .b .b .b.b.b.b.b#.b1.b5.b8.b:3c3c3c 3c3c3c3c3c!3c$3c/3c:3c=3d3d3d 3d 3d 3d3d3d3d3d-3d13d;3d=3d@3e3e3e 3e3e"3e44bE4c4c4c 4c4c4c4c4c4c4c#4c&4c-4c04c94c;4c?4d4d4d4d4d4d"4d$4d04d34d44d94d<4d>4dC4e4e4e4e4e4e+4e35bA5bB5c5c5c5c 5c5c5c'5c(5c,5cB5cF5d5d5d5d 5d5d5d#5d%5d/5d25d55e5e5e 5e5e5e5e!5e,5e-5e/5e26bF6c 6c6c6c%6c26c56c86c>6d6d6d6d6d6d!6d&6d(6d.6d66d?6dB6dF6e6e 6e6e 6e#6e$6e(6e)6e.6e06e16e57bC7c7c7c7c)7c.7c17c37c47c77cA7cC7cD7cE7d7d7d 7d'7d*7d+7d77d87d:7dD7dG7e7e7e7e7e7e7e7e7e%7e'7e*8b@8bD8bG8c8c8c 8c8c 8c"8c*8c+8c68c<8c@8cG8d8d8d 8d8d8d)8d,8dA8dE8e 8e 8e8e8e8e8e&=e7=e8=e9=eB=eE=f=f=f=f=f=f=f=f!=f%=f/=f5=f:=f?=fG=g=g=g=g=g=g"=g+=g/=g1>e;>eA>eC>f>f>f>f>f">f$>f'>f)>f.>f0>f2>f8>f=>g>g>g>g)>g,>g->g.?e@eG@f@f @f&@f,@f1@f6@f7@g("AN @ @ @ @ @ @ @@g@g @g@g&@g'Ae@AeDAfAfAfAf*Af3Af4Af;AfBAfDAgAg Ag AgAgAg Ag!Ag$Ag%Be:BfBfBf BfBfBfBfBfBfBf Bf#Bf+Bf9Bf<Bf>BfEBfFBgBg BgBgBgBgBgBg#Bg(Bg*Bg2 AT FEQb9Rg SCCC C C CCCCCCCCCCCCCCCCC C!C"C#C$C%C&C(C.C/C0C1C2C4C5C6C7C8C9C:C;C=C>C?C@CBCCCECFDDDDDDDDD D D D DDDDDDDDDDDDDDDD D!D"D$D%D&D'D(D)D*D+D,D-D.D0D1D2D3D4D6D7D8D:D;D<D=D>D?D@DADBDCDDDEDGEEEEEEEEE E E E E EEEEEEEEEEEEEEEEE C C CCC'C)C*C+C,C-C3C<CACDCGDD DDDD#D/D5D9DFEEEE!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7E8E9E:E;E<E=E>E?E@EAEBECEDEEEFEGFFFFFFFFFF F F F F FFFFF!F"F8FAFFGGG GGG G%G+G2G3G5G6GCHH HHHHH H'H.H2H8HDHGIIIIIII'I/I1I=ICJJJJJJJ,J7J>J@JE````````#`$`(`)`-`4`<`>aaaa#a3a;aCbbFFFFFFFFFFFFFFF F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F9F:F;F<F=F>F?F@FBFCFDFE7ARB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!CCCCCCCCCC C C CCCCCCCCCCCCCCCCC C!C"C#C$C%C&C(C.C/C0C1C2C4C5C6C7C8C9C:C;C=C>C?C@CBCCCECFDDDDDDDDD D D D DDDDDDDDDDDDDDDD D!D"D$D%D&D'D(D)D*D+D,D-D.D0D1D2D3D4D6D7D8D:D;D<D=D>D?D@DADBDCDDDEDGEEEEEEEEE E E E E EEEEEEEEEEEEEEEEE C C CCC'C)C*C+C,C-C3C<CACDCGDD DDDD#D/D5D9DFEEEE!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7E8E9E:E;E<E=E>E?E@EAEBECEDEEEFEGFFFFFFFFFF F F F F FFFFF!F"F8FAFFGGG GGG G%G+G2G3G5G6GCHH HHHHH H'H.H2H8HDHGIIIIIII'I/I1I=ICJJJJJJJ,J7J>J@JE````````#`$`(`)`-`4`<`>aaaa#a3a;aCbbFFFFFFFFFFFFFFF F#F$F%F&F'F(F)F*F+F,F-F.F/F0F1F2F3F4F5F6F7F9F:F;F<F=F>F?F@FBFCFDFE7AQS*FGGGGGGGGG G G G GGGGGGGGGGGGGGGGG!G"G#G$G&G'G(G)G*G,G-G.G/G0G1G4G7G8G9G:G;GG?G@GAGBGDGEGFGGHHHHHHHHH H H H HHHHHHHHHHHHHHH!H"H#H$H%H&H(H)H*H+H,H-H/H0H1H3H4H5H6H7H9H:H;HH?H@HAHBHCHEHFIIIIII I I I I IIIIIIIIIIIIIIIII I!I"I#I$I%I&I(I)I*I+I,I-I.I0I2I3I4I5I6I7I8I9I:I;II?I@IAIBIDIEIFIGJJJJJJ J J J J JJJJJJJJJJJJJJJJJ J!J"J#J$J%J&J'J(J)J*J+J-J.J/J0J1J2J3J4J5J6J8J9J:J;Ja?a@aAaBaDaEaFaGbbbbbbbb%b+b,b0b9HHH!H"H#H$H%H&H(H)H*H+H,H-H/H0H1H3H4H5H6H7H9H:H;H<H=H>H?H@HAHBHCHEHFIIIIII I I I I IIIIIIIIIIIIIIIII I!I"I#I$I%I&I(I)I*I+I,I-I.I0I2I3I4I5I6I7I8I9I:I;I<I>I?I@IAIBIDIEIFIGJJJJJJ J J J J JJJJJJJJJJARTB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!bb b bbbbbbbbbbbbb b!b"b$b&b'b(b)b*b-b.b/b2b3b4b6b7b;b<b=b>b?bb b b bbbbb#b1b5b8b:b@bAbBbCbDbEbFbGcccccccccc c c c c ccccccccccccccccccc c!c"c#c$c%c&c'c(c)c*c+c,c-c.c/c0c1c2c3c4c5c6c7c8c9c:c;c<c=c>c?c@cAcBcCcDcEcFcGdddddddddd d d d d ddddddddddddddddddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGeeeeeeeeee e e e e eeeeeeeeeeeeeeeeeee e!e"e#e$e%e&e'e(e)e*e+e,e-e.e/e0e1e2e3e4e5e6e7e8e9e:e;e<e=e>e?e@eAeBeCeDeEeFeGffffffffff f f f f fffffffffffffffffff f!f"f#f$f%f&f'f(f)f*f+f,f-f.f/f0f1f2f3f4f5f6f7f8f9f:f;f<f=f>f?f@fAfBfCfDfEfFfGgggggggggg g g g EAS @ @ @ @ @g ggggggggggggggggggg g!g"g#g$g%g&g'g(g)g*g+g,g-g.g/g0g1g2 AZ F&VJWb.XfYC C C C C CCCCCCCCCCCCCCCCC C!C "C!#C"$C#%C$&C%'C&(C')C(*C)+C*,C+-C,.C-/C.0C/1C02C13C24C35C46C57C68C79C8:C9;C:<C;=C<>C=?C>@C?AC@BCACCBDCCECDFCEGCFHCGIDJDKDLDMDNDODPDQDRD SD TD UD VD WDXDYDZD[D\D]D^D_D`DaDbDcDdDeDfDgDhDiD jD!kD"lD#mD$nD%oD&pD'qD(rD)sD*tD+uD,vD-wD.xD/yD0zD1{D2|D3}D4~D5D6D7D8D9D:D;D<D=D>D?D@DADBDCDDDEDFDGEEEEEEEEEE E E E E EEEEEEEEEEEEEEEEEEE E!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7E8E9E:E;E<E=E>E?E@EAEBECEDEEEFEGFFFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFF F!F"F#F$F%F&DFDGEEEEEEEEEE E E E E EEEEEEEEEEEEEEEEEEE E!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7 AWB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!CCCCCCCC C C C C C C CCCCCCCCCCCCCCCCC C!C "C!#C"$C#%C$&C%'C&(C')C(*C)+C*,C+-C,.C-/C.0C/1C02C13C24C35C46C57C68C79C8:C9;C:<C;=C<>C=?C>@C?AC@BCACCBDCCECDFCEGCFHCGIDJDKDLDMDNDODPDQDRD SD TD UD VD WDXDYDZD[D\D]D^D_D`DaDbDcDdDeDfDgDhDiD jD!kD"lD#mD$nD%oD&pD'qD(rD)sD*tD+uD,vD-wD.xD/yD0zD1{D2|D3}D4~D5D6D7D8D9D:D;D<D=D>D?D@DADBDCDDDEDFDGEEEEEEEEEE E E E E EEEEEEEEEEEEEEEEEEE E!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7E8E9E:E;E<E=E>E?E@EAEBECEDEEEFEGFFFFFFFFFF F F F F FFFFFFFFFFFFFFFFFFF F!F"F#F$F%F&DFDGEEEEEEEEEE E E E E EEEEEEEEEEEEEEEEEEE E!E"E#E$E%E&E'E(E)E*E+E,E-E.E/E0E1E2E3E4E5E6E7AVXB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!F'F(F)F*F+F,F-F.F/ F0 F1 F2 F3 F4F5F6F7F8F9F:F;F<F=F>F?F@FAFBFCFDFEFF FG!G"G#G$G%G&G'G(G)G*G +G ,G -G .G /G0G1G2G3G4G5G6G7G8G9G:G;G<G=G>G?G@GAG BG!CG"DG#EG$FG%GG&HG'IG(JG)KG*LG+MG,NG-OG.PG/QG0RG1SG2TG3UG4VG5WG6XG7YG8ZG9[G:\G;]G<^G=_G>`G?aG@bGAcGBdGCeGDfGEgGFhGGiHjHkHlHmHnHoHpHqHrH sH tH uH vH wHxHyHzH{H|H}H~HHHHHHHHHHHH H!H"H#H$H%H&H'H(H)H*H+H,H-H.H/H0H1H2H3H4H5H6H7H8H9H:H;H<H=H>H?H@HAHBHCHDHEHFHGIIIIIIIIII I I I I IIIIIIIIIIIIIIIIIII I!I"I#I$I%I&I'I(I)I*I+I,I-I.I/I0I1I2I3I4I5I6I7I8I9I:I;I<I=I>I?I@IAIBICIDIEIFIGJJJJJJJH%H&H'H(H)H*H+H,H-H.H/H0H1H2H3H4H5H6H7H8H9H:H;H<H=H>H?H@HAHBHCHDHEHFHGIIIIIIIIII I I I I IIIIIIIIIAWYB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!JJJ J J J J JJ J J J J JJJJJJJJJJJJJ J!J"J#J$J%J& J'!J("J)#J*$J+%J,&J-'J.(J/)J0*J1+J2,J3-J4.J5/J60J71J82J93J:4J;5J<6J=7J>8J?9J@:JA;JB<JC=JD>JE?JF@JGA`B`C`D`E`F`G`H`I`J` K` L` M` N` O`P`Q`R`S`T`U`V`W`X`Y`Z`[`\`]`^`_```a` b`!c`"d`#e`$f`%g`&h`'i`(j`)k`*l`+m`,n`-o`.p`/q`0r`1s`2t`3u`4v`5w`6x`7y`8z`9{`:|`;}`<~`=`>`?`@`A`B`C`D`E`F`Gaaaaaaaaaa a a a a aaaaaaaaaaaaaaaaaaa a!a"a#a$a%a&a'a(a)a*a+a,a-a.a/a0a1a2a3a4a5a6a7a8a9a:a;a<a=a>a?a@aAaBaCaDaEaFaGbbbbbbbbbb b b b b bbbbbbbbbbbbbbbbbbb b!b"b#b$b%b&b'b(b)b*b+b,b-b.aaaaa a a a a aaaaaaaaaaaaaaaaaaa a!a"a#a$a%a&a'a(a)a*a+a,a-a.a/a0a1a2a3a4a5a6a7a8a9a:a;a<a=a>AXZB!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!B!b/b0b1b2b3b4b5b6b7 b8 b9 b: b; b<b=b>b?b@bAbBbCbDbEbFbGccccccc c!c"c #c $c %c &c 'c(c)c*c+c,c-c.c/c0c1c2c3c4c5c6c7c8c9c :c!;c"<c#=c$>c%?c&@c'Ac(Bc)Cc*Dc+Ec,Fc-Gc.Hc/Ic0Jc1Kc2Lc3Mc4Nc5Oc6Pc7Qc8Rc9Sc:Tc;UcXc?Yc@ZcA[cB\cC]cD^cE_cF`cGadbdcdddedfdgdhdidjd kd ld md nd odpdqdrdsdtdudvdwdxdydzd{d|d}d~dddd d!d"d#d$d%d&d'd(d)d*d+d,d-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGeeeeeeeeee e e e e eeeeeeeeeeeeeeeeeee e!e"e#e$e%e&e'e(e)e*e+e,e-e.e/e0e1e2e3e4e5e6e7e8e9e:e;e<e=e>e?e@eAeBeCeDeEeFeGffffffffff f f f f fd-d.d/d0d1d2d3d4d5d6d7d8d9d:d;d<d=d>d?d@dAdBdCdDdEdFdGeeeeeeeeee e e e e eeeeeeeeeeeeeeeee<AY @ @ @ @ @ @ @ @ @ @ @ @ @fffffffff f f f f fffff f!f"f#f$f%f&f'f(f)f*f+f,f-f. f/!f0"f1#f2$f3%f4&f5'f6(f7)f8*f9+f:,f;-f<.f=/f>0f?1f@2fA3fB4fC5fD6fE7fF8fG9g:g;g<g=g>g?g@gAgBg Cg Dg Eg Fg GgHgIgJgKgLgMgNgOgPgQgRgSgTgUgVgWgXgYg Zg![g"\g#]g$^g%_g&`g'ag(bg)cg*dg+eg,fg-gg.hg/ig0jg1kg2 VCN\\   ID Explanation\\" ID PrimaryKey\\ {qg `LVAL ^Are you familiar with Crosstab Queries? Crosstab queries will dynamically create columns/fields based on each unique value of a particular field in your query. I my demo, I used customer names as columns. The problem is: 1) the number of columns created by the crosstab will vary based on the number of customers during a particular period of time, the type of products included in your report, and the sales persons reported. There might be 2 or there might be 20. We don't know until the crosstab is run. 2) reports expect a certain number of fields in their record source. This generally isn't a problem since we base most reports on fields/columns from a query in which the fields don't change. The records will change but the same base columns will generally be available. Since Crosstab queries will vary in the number and names of fields, reporting them takes some work arounds. My method starts with a desire to predefine the column/field names in the report. This could be numbers, colors, or whatever. I chose letters of the alphabet since they easily afford up to 26 columns, alphabetic order is something we all understand, they have an ASCII value that converts to numbers using the ASC() function, and "A" is easier to type then "Yellow". I can now create an "alias" table of two fields, the customer name and the associated letter of the alphabet. If I include this table in my crosstab and link the customer names, I can use the associated letter as the column heading. This works fine except that different sales people will sell to different customers. So we add a salesperson field to the "alias" table. We can create a totals query "qappEmpCust" that will append every unique combination of salesperson and customer to the Alias table. I then use code to loop through the table and assign the letters "A-F" or whatever. This works fine until one salesperson sells to more than 6 customers. So, I add another field that describes the level (couldn't find a better term). The code loop then assLVAL igns level 0 letters A-F and then increments to level 1 and starts over at A etc. The final piece was to provide column headings. This was done using a label type subreport where the link master child fields reference the Salesperson and Level displaying the customer names rather than A-F. All of this together allows me to successfully report the result of a crosstab query regardless of the number of potential columns and their names. The report also runs much faster than a solution provided in the Microsoft sample Solutions.MDB. Are you even more confused? To be honest with you, I have to re-think what I did each time a create a new report. One of my employees has used this method for about 6-8 reports. She figures this method has saved her a couple days of development time and kept a client much more satisfied. I am considering submitting an article to Smart Access, Access-SQL-VB Advisor or other publication so I would appreciate hearing from you if this explanation helped. Thanx Duane Hookom dhookom@invisibleinc.com http://www.invisibleinc.com/divFiles.cfm?divDivID=4[ @ ]AH~dJ0z`F,v\B(rX>$ nT: jP6fL2 @# `@!  @#T@!9 @#"@ _@!b@"/@$,@6~@"Y}@5|@@ G{@$ z@@"y`@#[x@@ Xw`@",v`@!>u@Dt@@ Us@!'r@##q`@$p @#Ao@"2n@m@@$2l`@#Jk@ j@Oi@Ph`@ g@#f@! e@Rd@1c@#b@$[a@"/`@-_@@$^@"]@@ \@ X[@(Z@@"Y@X @!=W@@$]V`@!,U@"`T@@$]S@$5R@#Q@!9P@!BO@N@!M@!L@ K@ &J@!RI`@3H@%G@@!UF @ E@@!QD`@#C`@#&B`@$[A@AH~dJ0z`F,v\B(rX>$ nT: jP6fL2@!X @#?@"^@$ @$@"H`@ @ "@@$@ `@ @"@F@"I@#'@$0@@!@@#`@"V`@$@9`@"-@#M @!"@@ 6`@"F@$? @!>@!@$K@@#c@$L@ @#@ @@#c`@@!@"Z@!@ I@@ L`@$@" @!)@ @@!@ @@ E @#5@@!1`@"@@$ @!=@$R@ @".@$\@!J@#)@#L@@$S @@> @ -`@ @!V@$,@ a@#E @!2AH~dJ0z`F,v\B(rX>$ nT: jP6fL2@8 @6@4Z@@8J@7@5&@5@@80@++@,S@*= @,' @-C @.\ @), @.=@*5@-@.R@+@@+@*2@.0@)F@-F`@,K @,@)%@)`@+?@+R@*/ @*^@,=@)R@*>@.7@*N@,( @,@*U@.@.@,`@- `@,6@-M@*(@) @)%@-#`@.@,c@,3`@,'@+&@.b@-8 @.V@+@.Z`@*R@.@- @.@@" @@#,@! @#3@@#b@WAH~dJ0z`F,v\B(rX>$ nT: jP6fL2`@8O_@5H^@7]@@7Q\@7=[`@5SZ@7Y@8/X@@4W@6TV@3JU@8ZT`@47S@3)R@@4bQ@6P@7.O@8N@6XM@7EL@7BK@6VJ@72I`@4 H@3GG@7TF@4 E @5D@85C@8WB`@7 A@5P@@5:?@4N>@6'=@3B<`@4;@@8:@3A9@8&8 @57@3_6@75@64@73@4V2@3 1@4`0`@3 /`@5;.@4`-@4 ,@4I+@4"*@8W)@67(@7' @32&@5a%@3&$@@6# @80"@@4O! @8A @5G @4/@@38`@8]@5c@4L@5X`@3\AH~dJ0z`F,v\B(rX>$ nT: jP6fL2 @7 @6 @8@7>@4@6@8.@3N@@6!@4W@38@4a@3C@7D@4@7A`@7B@6.@53@4b@4@5?`@3O@@4E@5X@6b@3 @@8)`@74`@7K@8@6@7@6&@5# @4O@@5`@43@6P@7L@3 @5@~@4I}`@7?|`@8({ @5$z@4,y@@8#x@7w@4$v`@3au@6Kt@6Ws@3&r`@4]q`@4'p @6 o@3Un @3Ym@30l@5Xk@8j@3i`@5&h@8g@3f @32e`@8ad@64c@5;b@@6(a@5 AH~dJ0z`F,v\B(rX>$ nT: jP6fL2 `@@<@?R@=[@A(@>`@=,@>@A8@?a @@>@@@?=@@>H@B`@=`@=D@=D@@5@6'`@3@4M@5-@@6,@6`@5[@6@5@5,@4@7D@6c@6U@7[@8+`@7N@6 @6V`@3C@5M@6@5$@7]@5L@8 @50@@3a`@7@@86`@4T`@4_@7 @7?@@7`@8,`@6]@8`@4[@4@3C@@8I@8@5V@6@4 @65`@3C@5@7P@3]@5<@7Z@7AH~dJ0z`F,v\B(rX>$ nT: jP6fL28@=R7`@BI6@BA5@A,4`@?R3@@Aa2`@?&1@?0@=>/@B.@>-@B,@AC+@=*@B )@>b( @@W'@@&`@= %`@A$@A,#@> "@@\!@> @=`@> @?C @@1@BJ@AX@>@?@>T@@@=7@@>`@B.`@>`@=.`@B @BO @>O@?V  @=% @= @B9 @B @?E@=@>@>a@= @Ba@BJ@@B@?b@= @A@B)@?P@?]@? @@I@=@> `@@7@?=@A_@=C@A"@BR @BbA3~dJ0z`F,v\B(rX>$ nT:  k@B?j@= i@?0h @=,g @>8f@>Ae@>Ld`@=c`@Bb@>Ca@B?`@@N_`@@#^@Ab]`@AL\ @BL[@=YZ@@AY`@AX@?JW@>V@?<U@@>XT@B S@A%R@B^Q@@=RP @B4O@@*N@?EM@B$L @=SK`@BTJ@?I@=7H@?`G@AF@@B8E`@A8D @A5C@?B@@'A@@>@@?=?@@B<>@==@@<@?;;`@@c:@=>9@ARLVALJKKDJ ColumnWidth ColumnHidden RecordLocks ODBCTimeout RecordsetType2tblSales.SaleDate  "A  "B  "C  "D  "E  "F  "G  "H  4tblSales.EmployeeID  . LastFirstName  (  < KKDr RecordLocks ODBCTimeout MaxRecords RecordsetTypeFilterOrderBy OrderByOn ColumnWidth ColumnHidden1  <  :tblCustomers.CustomerName E KKD0 RecordLocks ODBCTimeoutUseTransaction(  < KKD OrderByOn ColumnWidth ColumnOrder ColumnHidden DecimalPlaces DefaultValueRequiredDisplayControlAllowZeroLength \ EmployeeID       0  m\ CustomerID      0  mT ColumnAlias F     mW Level      0  mKKDTitleAuthorCompany< CrossTab Hookom's Hookom'sKKD AccessVersionBuildAppTitle StartUpFormStartUpShowDBWindowStartUpShowStatusBarStartUpMenuBarAllowShortcutMenusAllowFullMenusAllowBuiltInToolbarsAllowToolbarChangesAllowBreakIntoCodeAllowSpecialKeysAppIconStartupShortcutMenuBar  07.53  frmReportSelect            KKD KeepLocal TWLVALc @ @ @ @ @0:<=Babc$'e g$hij!9kH!t@qxtbEmpCustSalesEmployee Sales by CustomerArial8$'h4\\BRLH4\5SIXXLetter!p(H''''(e23winspool\\BRLH4\5SINe00:d28Arialm5<b8Arial0 LastFirstNameLevelSaleDate` ReportHeader` PageHeaderd8"b8"chdeLabel34%Sales Report By Employee and Customer` GroupHeader0m<"a<bcYei j LastFirstName LastFirstName`a GroupHeader1p4`db!csrptCustomerHeadingsReport.srptCustomerHeadingsEmployeeID;LevelEmployeeID;Levele`(ab!cBox22`Detailm;<"`btcei SaleDateSaleDatem/d/yyyym0<"`dbcei kAA$#,##0.00;($#,##0.00)m0<"` bcei kBB$#,##0.00;($#,##0.00)m0<"`bcei kCC$#,##0.00;($#,##0.00)m0<"`Dbcei kDD$#,##0.00;($#,##0.00)m0<"`bcei kEE$#,##0.00;($#,##0.00)m0<"`!bcei kFF$#,##0.00;($#,##0.00)`a GroupFooter0m0<"`dbci Text12 =Sum([A])$#,##0.00;($#,##0.00)m0<"` bci kText13 =Sum([B])$#,##0.00;($#,##0.00)m0<"`bci kText14 =Sum([C])$#,##0.00;($#,##0.00)m0<"`Dbci kText15 =Sum([D])$#,##0.00;($#,##0.00)m0<"`bci kText16 =Sum([E])$#,##0.00;($#,##0.00)e`(b!cBox21m0<"`!bci kText35 =Sum([F])$#,##0.00;($#,##0.00)`< GroupFooter1` PageFooter`h ReportFooterm0<"`(bci jText32=Sum([TotalSales])$#,##0.00;($#,##0.00)d8"b(c,d eLabel33 Total SalesLVAL N  ͬ]J g uDetailmCustomerNameEmployeeIDLevelColumnAliasͬ"ir uReportHeaderPageHeaderdLabel34GroupHeader0mLastFirstNameGroupHeader1psrptCustomerHeadingseBox22Detailm SaleDatem Am Bm Cm DmEmFGroupFooter0mText12mText13mText14mText15mText16eBox21mText35GroupFooter1PageFooterReportFootermText32dLabel33EmployeeIDLevelTotalSales G!H*8 FPBrushPBrushPBrush9q8``8     s@+\z@qxtbEmpCustSales@h@mI==1111111/ @ ɵSs@@x@srptCustomerHeadings~@jLWF0005@/_SAA5555553 \&~ozk\XI:6'teaRCA < <ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o < 8 8ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o 8 3 3ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o 3  ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o     ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o      ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   Tۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o  Tۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o LVAL(~ozk\XI:6'= @o[pX @M;qX @ztblExplanation........... AbX @ɏnX @tblSales''''''''''' <^X @WtaX @tblEmployees+++++++++++ 8O\X @^X @tblEmpCustAlias........... 3{ZX @{ZX @tblCustomers+++++++++++ qYX &qtblSalesۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o     ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o      ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o    ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   Tۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o   ۇ O8V#jK ~PV#jKV#jKV#jKV#/qqtblCustomers]ytblEmpCustAliassjtblEmployees+tblSalesiLVAL8yzk\XI:6'te3ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o 3 KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormatCaption InputMask DefaultValueRequiredAllowZeroLengthDisplayControl 7 EmployeeID   R FirstName       mQLastName       mKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat DecimalPlaces InputMaskCaption DefaultValueRequiredDisplayControlAllowZeroLength \ EmployeeID        0  m\ CustomerID       0  mT ColumnAlias F     mW Level       0  mKKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormatCaption InputMask DefaultValueRequiredAllowZeroLengthDisplayControl 7 CustomerID   U CustomerName       m~o [ [ۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o [ A Aۇ O8V#jK ~PV#jKV#jKV#jKV#jK>I6 9V#jKV#jKV#jKV#jKV#o  LVALt @ @ @ @ @ @ @ @ @ @ @********* ************ *!*"*#*$ *% *& *' *( *) ** *+ *, *- l l l l l lllll l l lll lllll*.llllllll 3l3l3l8l8l 8l!<l"<l#<l$Al%Ao****** * * * ***KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormatCaption DefaultValueRequiredAllowZeroLength RowHeight!  /ID   J Explanation (      KKDValidationRuleValidationTextFilterOrderBy OrderByOn ColumnWidth ColumnOrder ColumnHidden DescriptionFormat InputMaskCaption DefaultValueRequired DecimalPlacesDisplayControl >SaleDate     i CustomerID    General Number    mi EmployeeID    General Number    mf SaleAmt    General Number    m3 SaleID