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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by dceglar2

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

Part and Inventory Search

Back
Top