Look at the Grouping in your report. That is where the report sorts.
Reports sort independently of their underlying query.
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
"bitschon"
<[EMAIL PROTECTED]
l.net> To
Sent by: AccessDevelopers@yahoogroups.com
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] Ordering problem
08/09/2005 03:22 - Report is reordering the query
PM
Please respond to
AccessDevelopers@
yahoogroups.com
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?
Please zip all files prior to uploading to Files section.
SPONSORED LINKS
Microsoft access Microsoft access Microsoft access
database developer
Microsoft access Microsoft access
database design database training
YAHOO! GROUPS LINKS
Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
<font face=arial size=-1><a
href="http://us.ard.yahoo.com/SIG=12hanq15a/M=362131.6882499.7825260.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123624739/A=2889191/R=0/SIG=10r90krvo/*http://www.thebeehive.org
">Get Bzzzy! (real tools to help you find a job) Welcome to the Sweet Life
- brought to you by One Economy</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/
