Hi everyone, I am not a big expert of access, so I ask for your help on this matter I have tried to solve for days.
As I work in cancer research field, any expense is attributed to a project (called Grant). As you can see on the picture attached I have a table summarizing the financial details of a project.
Now what I would like is to show the sum of the expenses in the field circled (SPESO), but only the expenses attributed to the project selected in the combobox IDGrant and the Annuality selected in the combobox IDAnnualita
In the field "SPESO" I wrote this code
=DSum("Importo";"SpeseGrantT";"IDVoceSpesa=1")
which works fine returning only the category of expense I need (I have several) but to this code I need to add something so that, it will sum only the expenses of the project selected in IDGrant and IDAnnualita.
I ve read around and tried but didn't come up with the right solution.
Hope you can help. Thanks