access- Dsum function to view total amount

I have an access form which have this dsum function below, this is work perfectly

=DSum("Amount","invoice","[customer]='" & [Customer] & "'")

But I'm thinking to add another criteria as below, but the one below is wrong argument, anyone know what to fix here ?

=DSum("Amount","invoice","[customer]='" & [Customer] AND "[paidcode]='" & [paidcode] & "'")
Who is Participating?
Try this:
=DSum("Amount","invoice","[customer]='" & [Customer] & "' AND [paidcode]='" & [paidcode] & "'")

Open in new window

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.