Re: Type Conversion Failure in Update Query

Thanks, Ken,

I put in the code and it still seems to give me "type conversion failure."

I restricted the query to one field at a time to simplify things:

UPDATE [LOT CARD] SET [LOT CARD].[2nd_Right_Interment] = Left(
[2nd_Right_Interment],InStr([2nd_Right_Interment],",")-1)
WHERE ((([LOT CARD].[2nd_Right_Interment])<>"0"));

Thanks,

Kevin

--
Message posted via http://www.accessmonster.com
.

Relevant Pages

  • Re: Access wont commit (to SQL Server linked table)
    ... Unfortunately the query was running from VBA originally when the ... simplify things. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Cant figure this out !
    ... Ok, will try to simplify. ... opens with a status of either active or archived records. ... The below code is in the query for the forms employees list and so shows ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Date Parameters
    ... I have report that displays information grouped by year. ... would like to add a parameter to the query that asks they would ... and which works but I would like to simplify for the user. ... Prev by Date: ...
    (microsoft.public.access.forms)
  • Re: Cant append all records in the record query
    ... >> "Efficiency can't append all the records in the append query. ... > getting the message about a type conversion failure. ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.forms)
  • Re: Cant append all records in the record query
    ... > "Efficiency can't append all the records in the append query. ... I can see that you are inserting text values into number fields. ... getting the message about a type conversion failure. ...
    (microsoft.public.access.forms)
Quantcast