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

    Reducing a String of Letters in a Query!

    That worked great!!! Thank You!!!!
  2. dutchess

    Reducing a String of Letters in a Query!

    Does anyone know how to change in a query a six string line to a three string line. Example: I am sorting cities and last three of the zip code "WIL711" I would like the the query to return a value of just "WIL".
  3. dutchess

    Access Value Change

    Thank You, I was using a 100% value instead of 1!!!!
  4. dutchess

    Access Value Change

    I am trying to limit my query to 100%, Some of the values are greater than 100% and I would like to have anything that is over 100% return a value of 100%. Example: Judy 111% adherence would equal 100% Thank you for any advice!!
  5. dutchess

    "#Error" messages in queries!!!

    Thank You Paul!!!That works great!!
  6. dutchess

    "#Error" messages in queries!!!

    I am creating a report that is dividing two values of 0. Example Calls Taken 0 / Call Quality 0 and the message in the report comes up as "#Num!" The error also exist in the Query and gives me an error message "#Error" How can I fix this?

Part and Inventory Search

Back
Top