P
Pete!
Hi! I am trying to find a way to sort a fields alphabetically, ignoring the
word "the" if it appears at the begining.
e.g. if we have a field full of fruit sorting them alphabetically is:
- Apple
- The banana's
- Grapes
- Strawberries
However Access will put "The banna's" at the end after "Strawberries".
Hope some one finds a sneeky way around this problem, may have to go into VB
(although I dont know much VB).
word "the" if it appears at the begining.
e.g. if we have a field full of fruit sorting them alphabetically is:
- Apple
- The banana's
- Grapes
- Strawberries
However Access will put "The banna's" at the end after "Strawberries".
Hope some one finds a sneeky way around this problem, may have to go into VB
(although I dont know much VB).