A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

sorting in a report report



 
 
Thread Tools Display Modes
  #1  
Old November 25th, 2005, 01:23 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sorting in a report report

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


  #2  
Old November 25th, 2005, 01:53 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sorting in a report report

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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"stabilo" wrote in message
...
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




  #3  
Old November 25th, 2005, 02:20 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sorting in a report report

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" wrote:

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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"stabilo" wrote in message
...
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





  #4  
Old November 25th, 2005, 02:36 PM posted to microsoft.public.access.reports
external usenet poster
 
Posts: n/a
Default sorting in a report report

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

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



"stabilo" wrote in message
...
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" wrote:

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.
--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"stabilo" wrote in message
...
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







 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
subreport not displaying in main report JohnLute Setting Up & Running Reports 15 November 17th, 2005 05:02 PM
Reporting subreport total on main report BobV Setting Up & Running Reports 22 November 1st, 2005 04:19 AM
"Updating" a report to new query changes and leaving out things like sorting in report? StargateFan New Users 5 October 26th, 2005 09:42 PM
Printing Reports Access 2002 Pleas Advise Dermot Database Design 12 October 5th, 2005 11:23 AM
Has anyone seen this behaviour? What might it be? tw General Discussion 4 June 30th, 2005 03:23 PM


All times are GMT +1. The time now is 10:33 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.