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

    Unanswered: Access Expression Builder order

    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
    out on a limb
    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