Data calculation in access like in excell

[Rolandas]

Hello Dear All,

I would like to know if it is possible to make calculations in access like in excell. I thing there are some ways to do that but I dont know how? Your help would be really appreciated.

Example:

I have table with values:

Value
10
15
30
20
10

And I need to insert into the same table the other column with percentage changes of the two values. Example:

Value | Change(%)
10 | 0
15 | 50
30 | 100
20 | -33
10 | -50

The calculations:
For example the second value in Change column:
(15 - 10)/10 = 0,5 or 50 %

Is it possible to do that? I would be very grateful for answers.

[beacon]

You could imitate the action, but I think you'd have to use either a query or VBA code to accomplish it.

My question is, will the data in the table change? If so, my recommendation would be to use a SELECT query. The reason is because data that appears in a SELECT query is a view/snapshot of the data in the table that allows you to add additional columns and manipulate the data without affecting the data in the underlying table.

Go to Query in the Database Window, click New, and choose to create a query in Design View. You should then be prompted to add tables to the query (add the table or tables you need). Once you've added the table(s), you can click and drag the fields you need to the grid. Once you've got all the fields you want on the grid, you can create an expression (similar to Excel's formulas) in one of the open columns.

Hope this helps and good luck,
beacon