Zignd
Zignd

Reputation: 7025

How to add 10% to a cell of a table on MS-Access?

So, I need to increase / decrease by 10% the value of codes 1, 2, 3, 4. But I have no idea about how to it can you guys help me? I need to use the SQL mode to do it.

.

Note: As it's not possible to paste the table here on the post I took a PrintScreen of it.

.

This is my Table

Upvotes: 1

Views: 1563

Answers (1)

Zignd
Zignd

Reputation: 7025

Only to do not left this question with no answer I'm adding here the correct answer that was posted by @Scotch on his commentary. And also thank you @Remou for helping too.

UPDATE TabProd
SET PrecProd = (PrecProd * 1.1)
WHERE Código IN (1,2,3,4)

Upvotes: 2

Related Questions