By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
445,841 Members | 1,761 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 445,841 IT Pros & Developers. It's quick & easy.

need to sort part numbers that have various prefixes

P: 1
Hi group,

Brand new here.

I have a project where we are working with a lot of part numbers. The numbers have some prefixes that appear and then don't appear though each part number has in common a number sequence that follows.

Is there a way in access to ignore certain letters and numbers (the prefix items0 and sort based on the other numbers?

Your help is most appreciated,

May 4 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418
Yes, There is the function Mid() ;)

You can type in your query the next:
New_part_N: Mid([My_part_number],3, len([My_part_number]))

So this gets the information from the 3-th symbol to the length of your part number! :)
Sep 3 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.