Right

[Todd]

Hi all,

I'm trying to right a query that uses the right function
i won't it to return everything to the right of a "-"
but i keep getting an error. There is no fixed length for
when the "-" occurs

 

[Ken Snell]

Try this:

ToTheRight: Mid([FieldName], InStr([FieldName], "-") + 1)