Is there a query to remove spaces of numbers within a column in Access 2007 or 2010?

[wedd]

Hi, I have table with a column called C_Customers which displays a record of numbers in these formats 000 000 and
000 000 000. Is there a formula, trim function or space function or any other function I use in the query design to remove spaces or join the numbers together? In other words the final display of the numbers in the column should show 000000 and 000000. Can this be done? If so, how can this be done? Would you have any examples to show how this is done.

Thanks for your contributions :friends:

[orange]

How is C_Customers defined?
Is it a text data type?
Does it have some sort of input mask?

If there really are spaces in the value, you could try

C_Customers = Replace( C_Customers," ","")

[HiTechCoach]

You could run an update query using the Replace().