Redrockhh Posted January 11, 2007 Share Posted January 11, 2007 Hello. I have a excel sheet with a master number of wrin numbers (product codes). It has a full number for example our full number is 0123-000 but the customer only uses 0123 but when they place the order they should use the full wrin but some choose not to. So here is what I am wanting to do. Create a database with all our full wrins in it. But I want to create a form that will full the partial wrin from the database and give me a full wrin. Quote Link to comment Share on other sites More sharing options...
fenway Posted January 11, 2007 Share Posted January 11, 2007 You mentioned "excel" and "database" in the same breath... expalin. Quote Link to comment Share on other sites More sharing options...
Redrockhh Posted January 12, 2007 Author Share Posted January 12, 2007 I have an excel sheet that has all our master wrins in it. I know how to create the database and take the info from excel and input into the database. I just am not sure how to query the the database with a form to retrieve the full wrin from a partial Quote Link to comment Share on other sites More sharing options...
fenway Posted January 12, 2007 Share Posted January 12, 2007 OK... you can search for LIKE '0123%', though that can be tricky if they don't all have the same length, or pull out the right "piece". Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.