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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dceglar2

    Help needed with custom sort order query

    Version 2003 (11.6355.6360) SP1
  2. dceglar2

    Help needed with custom sort order query

    Yes,I have a field named [GRADE] and I only have one table in my database.
  3. dceglar2

    Help needed with custom sort order query

    I get the same error message :{
  4. dceglar2

    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.
  5. dceglar2

    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...
  6. dceglar2

    Help w/simple IIF

    Thank You!!!!!!
  7. dceglar2

    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...

Part and Inventory Search

Back
Top