Regarding Pictures

[rlporter]

When using a picture, such as:

picture({INSTransInmates.Bkg#},"XXXX-XXX&quot

Is there a way to sort the report from the last three digits of the picture?

The digits are a number such as 1234567. I understand how to use a picture to separate the 7 digits in different ways, but is it possible to sort based on only a part of the picture?

Thanks for any help

rlporter

 

[lbass]

Assuming the field is a string and the picture function is already working, then try this:

right(picture({INSTransInmates.Bkg#},"XXXX-XXX&quot,3)

Or you could probably just use:

right({INSTransInmates.Bkg#},3)

-LB

 

[rlporter]

This worked PERFECTLY. Thank you veeery much..