Results 1 to 6 of 6
  1. #1
    wihowa is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Location
    Fort Worth, TX
    Posts
    3

    Question Sort Access Report by value AND have NULL values at the end?


    Hi and thanks for your help,

    I am trying to figure out how to sort an access report by a field that has a bunch of NULLs.

    The problem: When I sort by the field in question, it sorts the NULLs first...so the people viewing my report see the least important records first.

    Does anyone know a way to sort a report by a field in Access 2003 so it won't show the NULLs first?

    Thanks for your help,
    Will

  2. #2
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    if you don't mind the order of non nulls, you can try sort them descedently, then the nulls will go to the back.

    if you really mind the order of non nulls, you can add a temporary field, for example NotNull, set NotNull= not isnull(yourfield), sort by NotNull first then sort by yourfield.

  3. #3
    wihowa is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Location
    Fort Worth, TX
    Posts
    3
    I like that second idea. Where do I go to add the temporary field?

    Thanks again,
    Will

  4. #4
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    if your report use a table as data source, then create a query on this table, adding the temporary field, use the new created query as data source of you report.

    if your report use a query as data source, then modify the query, adding the temporary field, use the new created query as data source of you report. Or, create a new query on the query which you were using, adding the temporary field, use the new created query as data source of you report.

  5. #5
    wihowa is offline Novice
    Windows XP Access 2003
    Join Date
    Aug 2010
    Location
    Fort Worth, TX
    Posts
    3
    Perfect thanks

  6. #6
    weekend00 is offline I may not be right
    Windows XP Access 2003
    Join Date
    Aug 2010
    Posts
    1,295
    u r welcome

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

Similar Threads

  1. Replies: 12
    Last Post: 12-11-2011, 05:04 PM
  2. Null Values in query
    By LesleaOH in forum Queries
    Replies: 0
    Last Post: 10-19-2009, 04:45 PM
  3. Fill in Null values
    By Petefured in forum Queries
    Replies: 1
    Last Post: 10-06-2008, 12:54 PM
  4. HELP with NULL DateTime VALUES
    By lfolger in forum Programming
    Replies: 3
    Last Post: 03-28-2008, 02:33 PM
  5. Null Values not showing up in a Query
    By Valli in forum Queries
    Replies: 0
    Last Post: 01-04-2006, 03:53 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