MS Access - Attempt to Use 2 Filtering Criteria with DSUM Function

By jterra ·
Please can someone assist me with this problem I am having.

I am on my subform in MS Access and trying to use the DSUM function to sum the amount checked (using Checkbox).

On the main form I am trying to obtain the sum of the amount checked however it is giving me the total and not filtering by Allocation ID.

Below please find part of my function:

I am trying to filter chkDispatch and Allocation ID together so the sum of checked amounts can appear on the main form.

Please can anyone assist.

Pls email me on

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Share your knowledge

Related Discussions

Related Forums