Results 1 to 5 of 5
  1. #1
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    DSum Error


    =DSum(("[Quantity]","tblOrthoFeesBilled")*("[Price]","tblOrthoFeesBilled"))

    gives me "the expression you entered has a function containing the wrong number of arguments" (2007)


    Please help.

    Thanks,
    Al Soto

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,505
    Here is the syntax for using Dsum. I am not sure what you are trying to do as it looks like you are trying to do a calculation in the middle of this where the domain is supposed to be located. Look at this link.

    http://www.techonthenet.com/access/f...omain/dsum.php

    Alan

  3. #3
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67
    Alan,

    I have a table where I store a Quantity and Price for the expenses of surgical procedures performed. I want to pull the sum of (quantity * price) into a text field on an unbound form. Is DSum not the right function for this?

    I tried Sum(("[Quantity]","tblOrthoFeesBilled")*("[Price]","tblOrthoFeesBilled")) and got #Error.

    Thanks,
    Al

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,505
    Do your calculation in a query. Add a new field to your query and create an expression. This new field is the field you will then sum. Then use the query as your recordsource in your DSum in your form.

  5. #5
    alsoto is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Apr 2009
    Posts
    67

    Thanks

    Thank you very much. I never even considered that, but I have learned something here.

    Have a great day!

    Al Soto

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 13
    Last Post: 12-05-2011, 05:10 AM
  2. Help with Sum and DSum
    By objNoob in forum Reports
    Replies: 5
    Last Post: 12-05-2011, 01:55 AM
  3. DSUM() Error
    By msr71 in forum Access
    Replies: 14
    Last Post: 09-25-2011, 06:39 PM
  4. How do I use the DSum
    By Ironclaw in forum Access
    Replies: 1
    Last Post: 08-25-2010, 07:35 AM
  5. Help with dsum
    By bjsbrown in forum Reports
    Replies: 6
    Last Post: 02-06-2010, 09:33 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums