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=12h3h6jo0/M=362335.6886445.7839731.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123622550/A=2894361/R=0/SIG=13jmebhbo/*http://www.networkforgood.org/topics/education/digitaldivide/?source=YAHOO&cmpgn=GRP&RTP=http://groups.yahoo.com/";>In low income neighborhoods, 84% do not own computers. At Network for Good, help bridge the Digital Divide!</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/
