SUM in real time

[Fabio_Nabuco_Correia]

Dear all;

I’ve been trying to sum in real time the inputs on a form. The name of the table is ‘Mortalidade’, and the columns I’ve been trying to sum are ‘Aviário 1’, ‘Aviário 2’, ‘Aviário 3’, ‘Aviário 4’, and ‘Pinteiro’.

Here is what I got so far:

SUM(
SELECT(
Mortalidade[_ROWNUMBER], [Aviário 1]=Mortalidade)).

It is not working yet, but surely it will work eventually.

Thank you all in advance for the help.

[Markus_Malessa]

I would simply try:
[Aviario 1] + [Aviario 2] + [Aviario 3] + [Aviario 4] + [Pinteiro]

[Fabio_Nabuco_Correia]

Thank you very, very much, Markus!!! It worked!!!