Hal, George
Thanks for your very quick response.
The Sorting and grouping setting was set
correctly for the grouping.
Further to your responses, I added a
further line for the same field & just set the sorting option only.
My headache has suddenly cleared.
Thanks again guys
Norman Pearce
IT Training Manager
Ealing Hospital
Developing the foundations for your success
-----Original
Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 05 October 2005 13:49
To:
AccessDevelopers@yahoogroups.com
Subject: Re: [AccessDevelopers]
Access Report - Sorting Error
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.
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
