Forum home » Delegate support and help forum » Microsoft Access Training and help » Access

Access

ResolvedVersion 2007

Wed 25 Feb 2009, 11:04 Delegate 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:29 Trainer 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 courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips

Access

Access

RE: Access

Access articles

Access tip:

Splittng a database