Remove spaces from a set of numbers

[tania777]

How can i remove the spaces from the group of numbers below?
11 222 33 4444 555

This is an access DB table and it's a field named JOIN_PNUM
I need to make the number look like:
11222334444555.

[Atli]

Moved to the Access forum. Please try to post your questions in the appropriate forms. Thanks.

[missinglinq]

Where are you trying to do this? In a Form? In a Query?

The simplest way would be to create a be to create Query based on your table, with a calculated field based on JOIN_PNUM.

How you do this will need to be based on the version of Access you're running.

With version 2003 or later, something like

NEW_JOIN_PNUM: Replace([JOIN_PNUM], " ","")

Now simply use the Query as the base for your forms/reports and use NEW_JOIN_PNUM in place of JOIN_PNUM.

Welcome to Bytes!

Linq ;0)>