Removing unwanted info in Field on a access report

[deeda67]

Hi - I have a table that comes in from a live spreadsheet (so I cannot change the table design or the data in any way). I basically filter it through Access to have reporting capabilities. One field comes in as Steward: NAME. I want just the name in my report. Is there a way to remove the STEWARD: from each record in either the query or the report? Otherwise I have to go back to the creator and trust me that is worse. Any help appreciated.

[alansidman]

You can filter this out by making your record source for your report a query in lieu of going directly to a table. Employ the Left function to exclude the unwanted characters in the field.

[deeda67]

Ok the report's record source is a query. I will try that on the query part.

[jwhite]

To strip "STEWARD: " from the name, you would want - Mid([YourFieldName],10)

[deeda67]

Thanks all. This worked except for the fact the creator decided to change new ones coming in so I had the correct and with the extra STEWARD. So a friend helped me get the if then statement and added your suggestion. Boom I look like a genius 😊