Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Help needed with custom sort order query
Field: Expr1:Switch([GRADE]="PK*","a",[GRADE]="KG","a",[GRADE]="01","a",[GRADE]="02","a",[GRADE]="03","a",[GRADE]="04","a",[GRADE]="05","b",[GRADE]="06","b",[GRADE]="07","b",[GRADE]="08","c",[GRADE]="09","c",[GRADE]="10","c",[GRADE]="11","c") Table: Table Name Sort: Ascending The above is...- dceglar2
- Thread
- Replies: 9
- Forum: Microsoft: Access Reports
-
Help w/simple IIF
What is wrong with the following: IIf (date() = (between 08/01/2004 And 07/31/2005),"School Year 2004/2005") I just want to see if the current date follows in a certain School Year range, and if so, print "School Year 2004/2005". I want to string/nest a few together to check for the next few...- dceglar2
- Thread
- Replies: 2
- Forum: Microsoft: Access Reports
