Here is what I hope to achieve,
I have a report/label that I put in a part number using an unbound text box, in another unbound text box I enter a customer number. All the but the customer number comes from one queries and just too many customer numbers to add in to its table. Have a three-column table with the needed information and the key is the last two places of the part number.
Have Right([P/N].2) to work as a start and had wanted to use “Like” to match it to customer’s number. Can this be run with an Expression through a Control Source on an unbound text box and retrieve the data out of this three-column table?
Let me know the best way to pull info from two locations, Thank you. JWT
I have a report/label that I put in a part number using an unbound text box, in another unbound text box I enter a customer number. All the but the customer number comes from one queries and just too many customer numbers to add in to its table. Have a three-column table with the needed information and the key is the last two places of the part number.
Have Right([P/N].2) to work as a start and had wanted to use “Like” to match it to customer’s number. Can this be run with an Expression through a Control Source on an unbound text box and retrieve the data out of this three-column table?
Let me know the best way to pull info from two locations, Thank you. JWT
Last edited:
