Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Remove punctuation

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Remove punctuation

Resolved · Urgent Priority · Version 2003

Reply Tue 7 Oct 2008, 16:24Delegate Gillian said...

Gillian has attended:
Access VBA course
Excel Advanced course

Remove punctuation

Hello,

Is there a way to remove all punctuation characters from a string in a table field? The 'replace' function only removes one substring character at a time, whereas I'd like to remove all ANSI characters 33 to 47 in one go.
Thankyou

For upcoming training course dates see: Pricing & availability

Reply Thu 9 Oct 2008, 13:21Trainer Amanda said...

RE: remove punctuation

Hello Gillian

Thank you for your post.

This is something that we would advise on in a consulting capacity, for which there would be an associated cost.

If you would like to receive a quotation from our enquiries team for consultancy work, please contact info or phone phone number.

Thank you
Best Training team

Access articles

· How To Create A Combo Control On An Access Form
· An Introduction To Queries In Access
· Supersizing your databases via Microsoft Access
· Three Myths About Microsoft Access
· It Is Important To Take Care Over Primary Key Assignment

Please browse our web site to find out more about
2002 access microsoft training and other Microsoft training courses.

Access tip:

Calculating The Difference Between Dates

If you wish to calculate the time between two date fields, this can be done in a number of ways:

1. As a calculated field in a query
2. As a calculated control in a form or report
3. As a calculation in a VBA procedure.

The basic syntax to get the number of days between two dates is:

=[One Date Field] - [Another Date Field]

You can also use one of the following functions:

=Month([One Date Field] - [Another Date Field])
which calculates the number of months between the two fields

=Year([One Date Field] - [Another Date Field])
which calculates the number of years between the two fields.

Another function is the DateDiff() function.

It uses an argument to determine how the time interval is measured. For example:

=DateDiff("q",[One Date Field] - [Another Date Field])
returns the number of quarters between the two fields.

Other intervals that can be used in this expression are as follows:
"yyyy" - Years
"m" - Months
"d" - Days
"w" - Weekdays
"ww" - Weeks
"h" - Hours
"n" - Minutes
"s" - Seconds

View all Access hints and tips