Only Displaying a Last name in a report

[tjcinnamon]

I have a DB that has a field homeowner name. The Owner name is <Last name>, <First Name>. Is there a way in my report to only display the last name, like an input (or output) mask?

I tried to format it "*, " so it was wild card and then when it ran into the comma it would stop and only display the last name but it didn't work.

Thanks, JOe K.

 

[pbaldy]

You want the Left() and InStr() functions, either in the report textbox or the source query.