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 · Urgent Priority · Version 2007
Wed 25 Feb 2009, 11:04Delegate Stefanie said...
Stefanie has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access
I have a database of 780 entries, I need to delete only part of the information entered (the first 14 characters) in one field in each record, retaining the remaining information.
Is there a query I can use?
Thu 26 Feb 2009, 09:29Trainer Rajeev said...
RE: Access
Dear Stefanie
Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.
I am sure there are some functions that can help you trim certain no.. of characters but I have found this website that has a program that can do what you ask for as well as many other things.
http://www.sobolsoft.com/accessremove/
This is an .exe file that you need to download. Once downloaded it opens teh program and also asks you if you want to purchace the liceneced copy. It is roughly
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. |
