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 Chris Miller 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
Version 2003 (11.6355.6360) SP1- dceglar2
- Post #9
- Forum: Microsoft: Access Reports
-
Help needed with custom sort order query
Yes,I have a field named [GRADE] and I only have one table in my database.- dceglar2
- Post #7
- Forum: Microsoft: Access Reports
-
Help needed with custom sort order query
I get the same error message :{- dceglar2
- Post #5
- Forum: Microsoft: Access Reports
-
Help needed with custom sort order query
That is all I have - I am creating a query with all the fields used in my report and then adding this info to new a column.- dceglar2
- Post #3
- Forum: Microsoft: Access Reports
-
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
