Results 1 to 2 of 2
  1. #1
    Bertrand82 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Sep 2012
    Posts
    48

    Sorting in Totals Query

    Hi, Im using a left join to a table [Departmentinformation] to specify groups in my totals query.

    My table [Departmentinformation] includes fields department and department equals.

    Is it possible to sort my totals query by [Departmentinformation] department?



    br Bertrand

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Sure, just place the sorting order under the Department field name in your Query Builder.
    If you are having problems, can you change to SQL view and post your SQL code here?

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

Similar Threads

  1. Unusual Sub Totals & Totals in Groups.
    By Robeen in forum Reports
    Replies: 12
    Last Post: 03-20-2012, 08:55 AM
  2. Replies: 5
    Last Post: 12-06-2011, 11:18 AM
  3. Query for Totals
    By rbtrout in forum Queries
    Replies: 3
    Last Post: 08-19-2011, 01:01 PM
  4. Month totals and Year totals
    By marksnwv in forum Access
    Replies: 1
    Last Post: 08-05-2011, 10:13 AM
  5. query - totals
    By mslieder in forum Access
    Replies: 0
    Last Post: 02-22-2006, 06:11 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