access- Dsum function to view  total amount

Posted on 2012-08-15
Last Modified: 2012-08-16
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] & "'")
Question by:motioneye
    1 Comment
    LVL 29

    Accepted Solution

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

    Open in new window


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
    In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now