Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2012
    Posts
    8

    Unanswered: Sorting question

    Hi all, this is my first post...I have tried looking this up, and haven't found the right solution just yet, hopefully someone can help me out.

    I have an Access 2010 database that has a report listing conferences according to region. There are 10 regions, named Region 1 (Northeastern USA), Region 2 (Eastern USA), etc. The problem is that this is a text field, so when I try to group based on this field, Region 10 (Asia) comes second, between Region 1 & 2. How can I get the report to order it last? I tried useing a suggested Val function, "Expr1: IIf([Fieldname] Is Null, 0, Val([Fieldname]))", but this didn't have any effect. Any ideas, short of changing the region names? I'm sure this is a fairly common issue, I just can't seem to wrap my head around it.

    Thanks in advance!

  2. #2
    Join Date
    Jul 2012
    Posts
    8
    what if you put a calculated field to sort on (but not show) and that field goes
    Code:
    iif([region field] like "Region 10","Region 99",[region field])
    ?

  3. #3
    Join Date
    Aug 2012
    Posts
    8
    That will work! Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •