--- In [email protected], "bitschon" <[EMAIL PROTECTED]> wrote: > I have a query with an order by that looks like this: > > ORDER BY IIf(REG="WEST",1,IIf(reg="MIDWEST",2,IIf (reg="NORTHEAST",3,IIf > (reg="SOUTHEAST",4,99)))), TRIM(MID(DISTRICT,1,2)), > qry_sum_qry_flash_wk_by_store.store > > > When I run the query alone, I get the right results, region West is > first and the district that shows first is "01" - it happens to be San > Francisco, and store "001" (at Union Square in SanFrancisco) shows up > first. > > When I run the report, the Districts show up in Alpha order by the NAME > of the District, "Arizona/El Paso", shows up first. The Reions show up > correctly > > Why would this be?
------------------------ Yahoo! Groups Sponsor --------------------~--> <font face=arial size=-1><a href="http://us.ard.yahoo.com/SIG=12hkpsj0p/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123796955/A=2894321/R=0/SIG=11dvsfulr/*http://youthnoise.com/page.php?page_id=1992 ">Fair play? Video games influencing politics. Click and talk back!</a>.</font> --------------------------------------------------------------------~-> Please zip all files prior to uploading to Files section. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AccessDevelopers/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
