How to create a calculated column in access that is based in a conditional sum of another table

It is possible in MS ACCESS 2016 to create a column in a table that is a conditional SUM of another table?

Example

Table 1 – Columns

ID, NAME, TOTAL

Table 2 – Columns

ID, NAME, IDREF, CUSTO

Data:

Table 1

ID | Name  | Total
---+-------+----------------------------------------------------------------
35 |  Test |  "SUM(CUSTO) of ALL ELEMENTS OF TABLE 2 WHERE table2.IDREF = table1.ID"

Table 2

ID | Name  | IDREF | CUSTO
---+-------+-------+--------
1  | Test  |  35   |   50
2  | Test  |  35   |   30
3  | abcd  |  12   |   30
4  | Test  |  35   |   10

The result should be:

table 1

ID | Name | Total
---+------+------
35 | Test |  90      (50 + 30 + 10 from table 2 where idref = 35)

Answer

You can use a subquery:

select t1.*,
       (select sum(t2.CUSTO)
        from table2 as t2
        where t2.idref = t1.id
       ) as total
from table1 as t1;