Update Query Problems

[Guest]

I keep getting Type Conversion Error when trying to write an update query. I
am trying to change a field so that it no longer has commas in the numbers
(making 100,000 to 100000). For the update query in field i have that column
selected (votes), in table i have the database it comes from (Sheet 1), then
in update to i have: Replace("Votes",","""). When I apply this is the the
error 250 data files can't be changed due to type conversion error.

thanks in advance for your help

 

[John Vinson]

I keep getting Type Conversion Error when trying to write an update query. I
am trying to change a field so that it no longer has commas in the numbers
(making 100,000 to 100000). For the update query in field i have that column
selected (votes), in table i have the database it comes from (Sheet 1), then
in update to i have: Replace("Votes",","""). When I apply this is the the
error 250 data files can't be changed due to type conversion error.

thanks in advance for your help

If it's a Number field there IS no comma. You may be *displaying* the
number with a comma, by setting the Format property of the field - but
the comma is not stored in the table. If you don't want to see the
comma onscreen or on paper, just use a different format (such as "#").

If it's a Text field your replace function is incorrect - it should be

Replace([Votes], ",", "")

You're trying to update the field to the Text string "Votes". I'm
surprised you didn't get a syntax error too - you left out a comma.

John W. Vinson[MVP]