Calculated Formula on Table

[ngodap]

Hi im new on Access could anyone help me regarding calculated value on access table database.
I have value01 - value02 = AnswerValue but if the value01 is less than value02 the answer should be negative but did not return value of negative.
Please help me...

[davegri]

Remove the abs(......)

[ngodap]

Invalid syntax it says.

[davegri]

Should simply be
[value01]-[value02]

Note that it is not good practice to have calculated columns in a table.
It should be done in a query.

[ngodap]

I try it its syntax error. Regarding this practice what is the effect in the future, if i have calculated columns?

[davegri]

Regarding this practice what is the effect in the future, if i have calculated columns?

https://www.datanumen.com/blogs/one-...access-tables/

I try it its syntax error.

[ngodap]

Thank you so much davegri got it...

[ngodap]

But one more thing when you empty the value01 there will be no answer but if you put 0 its correct. Any idea how to write the code?

[davegri]

Two basic problems here.
1. You are working with data entry directly into tables. This is bad practice. You should use forms.
2. You want calculated fields in tables. The calculation should be done in queries.

Sorry, I can offer no code to help in validating data input directly into tables.

[ngodap]

Two basic problems here.
1. You are working with data entry directly into tables. This is bad practice. You should use forms.
2. You want calculated fields in tables. The calculation should be done in queries.

Sorry, I can offer no code to help in validating data input directly into tables.

Thank you so much davegri...appreciate it...