Search results

Hi all, How can I do this in Access query? It say it has violation problem. But I really need to use iif function in this update statement. How can I workaround that? thanks! update t_header as h set h.price = iif(h.FX=1, h.amount/h.price, h.fx*(h.amount/h.price)) where h.Refno='1'...

Hi all, I have a very simple update query as below, it works fine in Access: update a, (select c.refno, c.price, c.unit from c) as b set a.price=b.price, a.unit=b.unit where a.refno=b.refno Right now, I need to sum the price and unit first before updating Table a. I just simply re-write...