By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,935 Members | 1,380 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,935 IT Pros & Developers. It's quick & easy.

Remove spaces from a set of numbers

P: 1
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.
Mar 23 '10 #1
Share this Question
Share on Google+
2 Replies


Atli
Expert 5K+
P: 5,058
Moved to the Access forum. Please try to post your questions in the appropriate forms. Thanks.
Mar 23 '10 #2

missinglinq
Expert 2.5K+
P: 3,532
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
Expand|Select|Wrap|Line Numbers
  1. 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)>
Mar 23 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.