remove text after pound sign in Access query

[tjcollier]

How do you remove all text after a pound sign in a field in my query

 

[Rick B]

one post per question please