Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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 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? 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?

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 calculation. But I want to get the calculation automatically, without having to enter SQL commands and without having to perform queries. 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? 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: Access: http://www.youtube.com/watch?v=B7NPQfjbyks I wan't to do the same with Base. Is it possible?

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?

Hello, thanks for you answer. 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. table.

You tell me... SELECT "FIELD_1"+"FIELD_2"+"FIELD_3" AS "TOTAL" FROM "YOUR_TABLE", is that SQL? SQL?

I don't understand what do you mean about a table update? 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?

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. 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. 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 http://www.youtube.com/watch?v=B7NPQfjbyks

I wan't to do the same with Base. Is it possible?