I agree with Hal, as I had a similar problem until I found the
Sorting and Grouping icon by typing in Sort Report into the Help
section. I had no idea it was there, and the sort was not what I
wanted. Once I changed it, all was well.
The icon looks like two sets of paired lines with brackets in the
left margin for each set, and one larger left bracket left of all of
them. On my tool bar it's immediately right of the toolbox but I
don't know if that is standard.
Hope that helps.
Jeanie
--- In AccessDevelopers@yahoogroups.com, [EMAIL PROTECTED] wrote:
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
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=12h3k7gil/M=362329.6886308.7839368.1510227/D=groups/S=1705115370:TM/Y=YAHOO/EXP=1123797442/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/
