How to delete spaces in a Field?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In an Access XP Database there is a column named Claim#. Data is entered like
123 45678 or 123-45678.So after the third digit, has space or "-" character.I
want to remove the space or "-" and present the Claim# as 12345678.
Please, help! It is the first time I am asking and I looked on some answers,
but I didn't find anythig similar to this.

Thank you
 
In an Access XP Database there is a column named Claim#. Data is entered like
123 45678 or 123-45678.So after the third digit, has space or "-" character.I
want to remove the space or "-" and present the Claim# as 12345678.
Please, help! It is the first time I am asking and I looked on some answers,
but I didn't find anythig similar to this.

Thank you
Click to expand...

As long as there is always something in that 4 position that you wish
to remove:
NewColumn:Left([OldField],3) & Mid([OldField],5)
 
Hello there,

You need a calculated query:

1. Create a new query based on the Claim table.
2. Insert the fields required.
3. Go to the next available column:

ClaimNumber:LEFT([Claim#],3)&RIGHT([Claim#],5)

ClaimNumber - The name of the new field
: - Seperates the Name from the Calculation

This will only work if all of your claim numbers are have
a space or dash as the fourth digit.

Hope this helps

Judith
 
Back
Top