Grouping data by the 'last three characters'

[pokerace]

I would like to sort info in a report by the last three characters in a field. For example, say that I pull the following data (just a lot more of it):
ABC123
XYZ123
ASDF333
ZZGG333
JJJAA444

The last three characters indicate location, so I would like to sort/group this data by the last three characters. Since the data length isnt't constant I can't use mid in the formula.

 

[pokerace]

Actually, I was able to do this with the mid in the following formula. Might not be the best way but it worked:

mid({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC},Length ({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC}) - 2,3)

 

[bdreed35]

The Right function would work as well:

right({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC},3)

~Brian

 

[synapsevampire]

to be safe:

if not(isnull({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC}))
and
len(trim({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC})) > 2 then
right(trim({VOC_TRAIN_CLASS_LKP.VOC_TRAIN_CLASS_DSC}),3)
else
"N/A"

-k