98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access
Access
Resolved · High Priority · Version 2003
Fri 17 Oct 2008, 11:44Delegate Paul said...
Paul has attended:
Access Intermediate course
Access
How do you trim data in a query or a table for a whole column?
Thu 23 Oct 2008, 17:43Trainer Laura said...
RE: Access
Hi Paul
Thank you for the question.
Did you mean Trim as remove the spaces from either end of the value? If so you can use a function called Trim() in your query.
If you meant trim as trim to a set length you could use the function Left() in your query.
You can find text functions in the expression builder in FUnctions - Built-In FUnctions then scroll to the bottom of the middle list to select Text.
I hope that helps
Laura GB
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Run with the totalOften when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses. |
