sorting in a report report

[stabilo]

I'm using Access 2003.
I have a query that generate a table like this :

AAA 65 yyy
AAA 65 xxx
BBB 73 yyy
BBB 73 xxx
BBB 73 zzz
CCC 55 xxx
CCC 55 fff

The report shows :

AAA 65
yyy
xxx
BBB 73
yyy
xxx
zzz
CCC 53
xxx
fff

I want to sort the report by the second column the numbers, so
CCC, then AAA, then BBB

 

[Al Camp]

stabilo,
Sorting in a query behind a report is overridden by the Sorting &
Grouping on the report itself.
From what you've given, I would expect this S&G to work...
65Field Ascending
yyyField Descending
and let the AAA field fall where it may.

 

[stabilo]

Thanks.
The current G&S groups the Field1 (AAA, BBB, CCC,...) with group header
header and footer, and then sorted by Field3.

I'm not sure to understand how I can sort it by the Field2 (65, 73,...).
Where do i have to set this sorting so my report is still sorted by Field1
but sorted by Field2, and then Field2

Can you help ?

 

[Al Camp]

stabilo,
You wrote...If you have to have the 65Field sorted first, it should be the first line in
your S&G dialog box.
Your statement indicates that you don't care how the AAA, BBB fields sort,
so it shouldn't even be included in the S&G

Then... your data indicates that you want the xxx, yyy field to sort
descending after the 65, 73.. fields. So...

65Field Ascending
yyyField Descending

is what your S&G woudl look like.

You wrote...

Where do i have to set this sorting so my report is still sorted by Field1
but sorted by Field2, and then Field2 (by Field2 and then Field2???)

That's not what you described in your data example and your statement...

I want to sort the report by the second column the numbers, so
CCC, then AAA, then BBB

Give a good visual example of what you want to see on the report.

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions