Removing Decimals and Commas from a value

[Guest]

How can I remove comma's and decimals from a certain value using a formula in
a query?
Example: 2,352.00
Result: 235200

 

[John Welch]

You can do it in two steps: first remove commas, then dots, using the
replace function. Here's an example that will work:

SELECT Table1.original, Replace([original],",","") AS no_commas,
Replace([no_commas],".","") AS no_dots
FROM Table1;

There might be a way to do it in one step, but I can't think of it right
off.
HTH

"Send Object Command - Two attachments"

 

[Guest]

Try this

In SQL
Select Round([FieldName],2)*100 As Newumber From TableName

In the query it will look like
NewNumber: Round([FieldName],2)*100

 

[Joseph Meehan]

How can I remove comma's and decimals from a certain value using a
formula in a query?
Example: 2,352.00
Result: 235200

First question. Is the subject a number or is it really text?

If it is a number, then it sounds like a formatting issue.

 

[Guest]

This is what I got to work late last night:
Val(Replace(Replace([FieldName],".",""),",","."))

Thanks to all