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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03: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 |