Avatar of Giulio Benvenuti
Giulio Benvenuti
Flag for Italy

asked on 

Sum()

Hello i have tblCost with ID; Tipology; Cost
In frmCost i use field with written:
=Sum([Cost]) & " €"

Open in new window

I would like to create an other field like this but filtred by tipology.
for example Sum([Cost]) where Tipology = "to pay"
and also Sum([Cost]) where Tipology = "paid"

Any tip?
SQLVBA* Access 2019

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon