how to remove a word from a field

[sistemaPR]

I have a text field that have this value "April 2014 Sample" , I created a query to output the data to excel , but I need to remove the word (Sample)
Do you know how to remove a word from a text field..

[HansV]

Open the query in design view.
Let's say the field is named MyField. You'll have a column in the query that has MyField in the Field: row.
Change this to

Replace([MyField],"Sample","")