Hello, thanks for you answer.
My question is about getting the calculations in the table and not doing queries. I know how to create calculated fields in queries, but I don’t want that. I want to perform arithmetic calculations inside a field from my table. I have seen Access to do that, and I would like to do the same with Base. I wanto to store the result in my table.
You tell me… SELECT “FIELD_1”+“FIELD_2”+“FIELD_3” AS “TOTAL” FROM “YOUR_TABLE”, is that SQL?
I don’t understand what do you mean about a table update?
I want introduce 2 in the first field, then type 2 in the second field, and automatically in the third field (Result) getting the calculation. But I want to get the calculation automatically, without having to enter SQL commands and without having to perform queries. What I want is to define a field that add Field 1 + Field 2. However in the design view of the database I don’t see any way to do this. I want the calculated field in the table, not in a form. I know also in a form you can create a calculated field, but my question is not that. My question is if can I create a calculated field when introducing data in my table, directly in the table mode, and not using a form. I have seen in Access you can create a calculated field, but in Base seems to be impossible. For that reason I asked this? if may I do this? but please, not in a query, not with SQL.
Do we have anyway to do this? In Access you have something called Expression Builder, I seen that is a feature never seen before, but only available in Access 2010.
I don’t know if I am explaining well what I mean, but I want exactly what you can see in this video of Access: http://www.youtube.com/watch?v=B7NPQfjbyks
I wan’t to do the same with Base. Is it possible?