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 Chris Miller 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. bitg07

    I need a piece of string

    How do I use the LEFT function to return all characters on the left of a specific character. For example: I have a string that looks like "text1:text2" where text1 varies in length. What is the expression to return text1 (everything before the ":"? All help is appreciated...
  2. bitg07

    Run-Time Error 2471- Query Parameter

    Thanks, that works perfectly.
  3. bitg07

    Run-Time Error 2471- Query Parameter

    NewOptNum = DMax"[OPTION_NUM]", "tblQuote_Options", "

Part and Inventory Search

Back
Top