Weekend Project....display only selected items in a list

[agray123]

I have a query utilizing a union with another set of tables. In it, I am getting the name of the previous incumbent for a vacant positoon. Not all of the positions have a previous incumbent, so because of the limitations of our query tool, we place the jobcode(M2001, 00123), not the jobcode field (JOBCODE_FLD)in the field where the name is to be (Jones,Michael S)

I want to have a formula where the name is only shown, and any instance of a jobcode is passed as blank.

I also want to have a formula for "date vacated", which is the date the person left the position. Now a generic date of 1/1/02 is displaying in the fields without incumbents, and the actual date the person left shows where there actually was a person.

How can I accomplish this....????

 

[Turkbear]

Hi, Assuming ( always dangerous) that no Name would have a Number in it, create a formula the checks for that and returns either the Name or a blank.

Where is the Date the person left stored?