Type conversion failure

[sean98]

I am trying to update a table using information from the table and I am running into a type coversion failure. My goal is to update those records that are showing a qty sold and quantity return both equal to zero. The field I want updated is the COGS field. It should be equal to a field called EXT_SALES which is the total cost of the sale. The table is set up that the EXT_SALES and COGS fields are both data type "double".

UPDATE SalesResults SET [SalesResults].EXT_SALES_AMT = "COGS"
WHERE ((([SalesResults].OFFRNG_QTY_SLD)=0) AND (([SalesResults].OFFRNG_QTY_RTN)=0))
WITH OWNERACCESS OPTION;

When I run the query using the view button the correct information appears, however when I use the run button is tells me it is about to update the appropriate records after selecting yes it tells me the appropriate records will not be updated because of a type conversion failure. No other reasons impact the records requiring updates.

Any help would be appreciated.

Thanks
This message was edited by sean98 on 2003-02-21 12:31

 

[Dugantrain]

Well, I see what your problem is. The way you have your syntax set up, you're trying to actually write the phrase "COGS" into the
EXT_SALES_AMT field. I think this'll work:
UPDATE SalesResults SET [SalesResults].COGS=[SalesResults].ext_sales
WHERE ((([SalesResults].OFFRNG_QTY_SLD)=0) AND (([SalesResults].OFFRNG_QTY_RTN)=0))
WITH OWNERACCESS OPTION;

with this code, you're setting the cogs field equal to the ext_sales field when qty_sold and qty-rtn both equal 0

 

[sean98]

This worked Thanks very much