Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2014
    Posts
    1

    Unanswered: Access Expression Builder order

    Hello,
    How can i get the results below to display in the order built in the expression?
    Access automatically sorts ascending. I'm really new to MS Access so sorry for simple questions. Thanks!

    Team Name: IIf([Team]="CORR",'CORR',IIf([Team]="Tier 2",'Tier 2',IIf([Team]="Imaging",'Imaging',IIf([Team]="Financial",'Financial',IIf([Team]="Policy",'Policy',IIf([Team]="QA",'QA',0))))))[/B]

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Place the columns in the required order in the query designer from left to right.
    specify the sort order as ASCending or DESCinding for the required columns
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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