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

Is it possible to ignore the first digit in sort?

P: 58
I have tried to research this and I'm worried the answer is already in this forum and I just didn't search under the correct word.

However, I'm wanting to sort a table of job numbers while ignoring the first digit of the number. For example if the job number is 65599 I want it to sort the table using the last four digits of the number.

All the job numbers have 5 digits but none of the digits are constant.

Is this possible?

Thanks in advance!
Jan 31 '07 #1
Share this Question
Share on Google+
2 Replies


P: 58
The answer was already in this forum. I figured it out.

=Right([Field Name], Number of Digits)

and then sort.

Thanks. Great forum.
Jan 31 '07 #2

NeoPa
Expert Mod 15k+
P: 31,275
Bear in mind - the field dousn't have to be displayed (or SELECTed in SQL) for you to use it in the sort (ORDER BY in SQL).
Feb 1 '07 #3

Post your reply

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