CODEWITHSUNDEEP
ms-accessfieldformulacalculated-field
FishFold
FishFold

Reputation: 51

MS Access: Different formulas for different fields in the same column

I understand that I can add a table column of type "Calculated Field". However, after building an expression/formula, it is applied to the entire column. Is there a way to have a different formula for fields in the same column but different rows?

Upvotes: 0

Views: 471

Answers (1)

Sergey S.
Sergey S.

Reputation: 6336

As I know, it's not possible, the formula always applied to all rows in the column. As a workaround you can build your formula in order to analyse the data in the row and calculate accordingly.

In addition I would recommend to do not use calculated columns in the table, you will have more problems than advantages. Use queries instead.

Upvotes: 1

Related Questions