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

Nothing infallible that I can come up with on short notice here. I'll think
about it though. Is there some characteristic that you think would help
discriminate the ones that need updating from those that don't?

MJ wrote:
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 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"

--
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

  • Re: Data Project - Running SP via ADO
    ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: Writing a GUID to a SQL table
    ... I strongly suspect that it is SQL Server, ... >> Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: VBSCript execute MS SQL Stored Procedure Return Value
    ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: using ado drivers with 64 bits software
    ... experts in one of the Access groups. ... Microsoft MVP -- ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: move table
    ... Microsoft MVP - ASP/ASP.NET ... Please reply to the newsgroup. ... This email account is my spam trap so ...
    (microsoft.public.inetserver.asp.db)