Norman,
Hopefully not too late. Reports sort independently of queries. There is
an icon that looks like a large left parentheses, then two smaller left
parentheses stacked on top of each other and then two = signs. This is the
sorting and grouping icon. Also next to the toolbox icon. Click this icon
and select the field you wish to sort by and you should get the results you
want.
Good Luck
Hal
PS Hopefully the above makes sense, two people separated by a common
language after all...
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
"Norman Pearce"
<[EMAIL PROTECTED]
t.nhs.uk> To
Sent by: AccessDevelopers@yahoogroups.com
AccessDevelopers@ cc
yahoogroups.com
Subject
[AccessDevelopers] Access Report -
10/05/2005 08:27 Sorting Error
AM
Please respond to
AccessDevelopers@
yahoogroups.com
Also posted on Access users Forum.
AC2002 using default 2000 format
I have a report based on a query that sorts correctly on lastname and
is grouped on the first character of the lastname.
The query, a test form all sort correctly. But the report although
grouped correctly does not sort correctly. Infact I cannot fathom out
the sort sequence at all.
Now getting desparate as I need this report tonight & have 1124 records
to be verified by the organisation members for accuracy.
Any help & advice would be most welcome.
Norman Pearce
Ealing Hospital
Please zip all files prior to uploading to Files section.
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 --------------------~-->
Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life.
http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
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/
