 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / December 2005Sorting report by country, first all US, than all other countries
I have a report in Access 2003 which lists data by countries. I need the output in the report to print as follows. In outher words, I need it to list US countries first, the all other countries in alphabetical order. Country Serial number United States 4,444,444 United States 4,444,445 United States 4,444,544 United States 4,445,444 Australia 3,464,444 Australia 3,844,444 Bulgaria 2,424,444 Canada 3,222,111 Instead, it currently prints like this: Australia 3,464,444 Australia 3,844,444 Bulgaria 2,424,444 Canada 3,222,111 United States 4,444,444 United States 4,444,445 United States 4,444,544 United States 4,445,444 Any assistance would be greatly appreciated. Create a field for sorting only, and do not display this field. One way to do this would be to sort by alphabetical order, but use a switch in your sort field like: switch([country_name]="United States","AAAUnited States",true, [country_name]) This will put United States at the top of your list, and all other country names will keep the same order. You must include the "=" at the beginning of the function/expression.  SignatureDuane Hookom MS Access MVP -- > Create a field for sorting only, and do not display this field. One way to > do [quoted text clipped - 5 lines] > This will put United States at the top of your list, and all other country > names will keep the same order. Thank you so much for your assistance. I appreciate your help. > You must include the "=" at the beginning of the function/expression. > [quoted text clipped - 7 lines] > > This will put United States at the top of your list, and all other country > > names will keep the same order. 1. Create a query into this table. In a fresh column in the FieldRow, enter this expression: IsUSA: [Country] = ("United States") Use this query as the RecordSource of your report. 2. In report design view, open the Sorting And Grouping box (View menu.) In the first row, choose the IsUSA field. In the second row, choose the Country field. Explanation: The expression returns True for USA, False for all other countries (and Null if country is blank.) True sorts before False. SignatureAllen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. >I have a report in Access 2003 which lists data by countries. I need the > output in the report to print as follows. In outher words, I need it to [quoted text clipped - 22 lines] > > Any assistance would be greatly appreciated. Thank you so much for your assistance. Now the report works exactly as I needed. Thanks again! > 1. Create a query into this table. > In a fresh column in the FieldRow, enter this expression: [quoted text clipped - 34 lines] > > > > Any assistance would be greatly appreciated. In the reports Sorting and Grouping Dialog, try entering these two lines Field/Expression : Sort Order --------------------------------------------- =Country = "United States" : Ascending Country : Ascending You may have to switch the Sort Order on the first line to Descending. Try the proposed setup first. >I have a report in Access 2003 which lists data by countries. I need the > output in the report to print as follows. In outher words, I need it to [quoted text clipped - 22 lines] > > Any assistance would be greatly appreciated. >I have a report in Access 2003 which lists data by countries. I need the >output in the report to print as follows. In outher words, I need it to list [quoted text clipped - 19 lines] >United States 4,444,544 >United States 4,445,444 In the report's Sorting and Grouping window (view menu) set it to first sort on the expression: Country <> "United States" and set the second sort to the field Country SignatureMarsh MVP [MS Access] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.