=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
=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
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
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
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.
Thank you very much. I never even considered that, but I have learned something here.
Have a great day!
Al Soto