Remove part of field

[vtec_30]

What command would I need to use in order to use a query to only display part
of the field:
Example:
aaaaaa\test
bbb\kkkkkkkkkkk

When I run the query it should only display anything after the "\"
test
kkkkkkkkkkk

thank You in advance

 

[Jerry Whittle]

Mid([TheFieldName], InStr([TheFieldName), "\") +1)

 

[Ofer Cohen]

Try

Mid([FieldName],Instr([FieldName],"\")+1)