Results 1 to 3 of 3
  1. #1
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19

    Special kind of sorting in Crosstab Report - query

    Hello,

    I recently made crosstab report which will help me a lot at my work-place and make it easyer for me to "monhly sales by country" which looks something similar to this:



    but report is not fully complete. Why? Because I must have these countries ordered in specific (not A to Z or Z to A) order and I am not sure how to achieve this. Report I showed in text above should have this exact country order:

    Germany
    France
    USA


    Mexico
    Brazil
    etc.

    It would be very good if I could achieve this because it will be of great help to me.

    Any help is appreciated and many thanks in advance for prompt replys!

    Cheers
    Adi

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    If you don't want to base this sorting on existing data such as Monthly Sales, etc., then you must create this ranking. You need a table CountryInfo with a number field that will be the assigned ranking. Then include this field by join in report RecordSource and sort on this field.
    Last edited by June7; 07-02-2011 at 06:40 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    adi2011 is offline Novice
    Windows XP Access 2003
    Join Date
    May 2011
    Posts
    19
    Thanks a lot, problem solved

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Query to perform several special operations
    By Allison in forum Queries
    Replies: 4
    Last Post: 05-13-2011, 04:30 PM
  2. Replies: 0
    Last Post: 05-09-2011, 01:51 PM
  3. Replies: 5
    Last Post: 04-01-2010, 03:48 PM
  4. What kind of query do I need?
    By cowboy in forum Queries
    Replies: 1
    Last Post: 02-17-2010, 04:09 PM
  5. sorting a field in report
    By Philangr8 in forum Reports
    Replies: 3
    Last Post: 08-26-2009, 05:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums