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 Mike Lewis 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. tootyfruity

    best way to join - brain block

    No, not every email will begin with 'Order Confirmation'. This is entered manually by the receiver. Isn't there logic in access to pull a specific range of characters after the # sign?
  2. tootyfruity

    best way to join - brain block

    Yes that is exactly what's happening. I've inherited this project unfortunately. The idea is to join on the subject line which contains: Order Confirmation # 638917872-001 Partial Order/$23.74 RECEIVED I have a separate table with all order numbers. I'd like to pull just the order number...
  3. tootyfruity

    best way to join - brain block

    I have a similar issue and have yet to be able to figure out how to join these two tables. I have one table that has several pieces data in one column and I need to join only some of this data to another table I created with the relative data. Little background: we receive confirmations of...

Part and Inventory Search

Back
Top