Dsum total depending on combobox field

[estergr]

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

[Welshgasman]

You use those fields in the criteria as well?

Strings need to be surrounded by single quotes ' unless it contains a single quote, then triple double quotes works, I think?

Dates with # and in mm/dd/yyyy or yyyy-mm-dd format

Numbers do not need anything

[Micron]

You didn't provide field names that the combos are bound to, so research 'ms access dsum with multiple form criteria' or look at the similar posts links at the bottom of your thread or look here
https://www.accessforums.net/showthread.php?t=64378

Post samples of what you tried if you're still stuck.