Update query

[ChristopherL]

Hiho, first of all I'd like to thank those giving me assistance here, great support, knowledge and a superior webiste

Now for my problem


I want to update a column [Value_Diff_SEK] to a value gained from [Value_Diff]*[rate]. (it takes the value and multiplies it with the swedish SEK rate).

However, for those values that already have the swedish SEK as currency, it skips and those not add to the column.

So what I want to do is update those with the wrong currency to the proper currency and just copy the others over to the column in an update query!

Anyone got a solution for iff statement or anything?

[orange]

Please show us the SQL of your query.

[ChristopherL]

Please show us the SQL of your query.

UPDATE FX_RATES INNER JOIN USE_Secondary_Trades ON FX_RATES.CCY1 = USE_Secondary_Trades.CURRENCY SET USE_Secondary_Trades.Value_Diff_SEK = [RATE]*[Value_Diff];

[ChristopherL]

Tried this now and it did put out the diff's for different rate but it didnt give out the diff's that were alrdy SEK...

UPDATE FX_RATES INNER JOIN USE_Secondary_Trades ON FX_RATES.CCY1 = USE_Secondary_Trades.CURRENCY SET USE_Secondary_Trades.Value_Diff_SEK = IIf([CURRENCY]="SEK",[Value_Diff]=[Value_Diff_SEK],[RATE]*[Value_Diff]);


Did it with ii statement in update to row:
IIf([CURRENCY]="SEK";[Value_Diff]=[Value_Diff_SEK];[RATE]*[Value_Diff])