Show part of text in a field (1 Viewer)

chellebell1689

Registered User.
Local time
Today, 13:35
Joined
Mar 23, 2015
Messages
267
Hello,
So I have a report that shows our staff w/ their pictures. I have it sorted as well (1- Pastor, 2- Youth Minister, etc). Is it possible to show only the title (i.e. "Pastor", "Youth Minister") and still keep the number so it can sort properly? Or do I need to create a table for staff positions and assign, then sort that way?
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:35
Joined
Aug 30, 2003
Messages
36,137
If it's consistent:

Mid(FieldName, 4)
 

chellebell1689

Registered User.
Local time
Today, 13:35
Joined
Mar 23, 2015
Messages
267
That worked! Thank you!!
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 13:35
Joined
Aug 30, 2003
Messages
36,137
Happy to help!
 

Users who are viewing this thread

Top Bottom