Re: Is There Simple Way to Convert Integer to Decimal Within Same

It works great, thank you.

Now a new wrinkle, once I make that update I do not want to repeat it on
values that are already in a decimal format. Is there a good way to check
for it before doing the update?

Thanks again for your inputs.

--

MJ


"Bob Barrows [MVP]" wrote:

MJ wrote:
I am at a loss for this issues. Getting some bad data in, one field
in a small subset of entire table should be decimal but coming in as
integer. I know that I can covert it simply by dividing by 100 and I
have been able to do a Make Table query.

Is there a simple way to do this within the existing table WITHOUT
changing the field name? I tried using an Update query, but errors
out...

UPDATE [Table1_OptEditErrors] SET ([Table1_OptEditErrors].ClmAmt/100)
AS ClmAmt

wrong syntax. it should be:

SET [ClmAmt] = [ClmAmt]/100




--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"



.

Relevant Pages
Loading