A azhar2006 Registered User. Local time Today, 04:56 Joined Feb 8, 2012 Messages 297 Dec 8, 2013 #1 Good morning all I have a question is How is the collection of a sum of money to a particular substance There is, for example, in the table named baby milk product How can I collect the amounts of such material only I used a DSum Attachments erererer.JPG 30.9 KB · Views: 124
Good morning all I have a question is How is the collection of a sum of money to a particular substance There is, for example, in the table named baby milk product How can I collect the amounts of such material only I used a DSum
A AlexHedley Registered User. Local time Today, 12:56 Joined Aug 28, 2012 Messages 171 Dec 8, 2013 #2 What is the name of your Table/Query? Code: DSum ( expression, domain, [criteria] ) Code: DSum("Price", "TABLE/QUERY", "Article = Baby Milk") http://msdn.microsoft.com/en-us/library/office/ff193998.aspx Video, basic DSUM. http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum
What is the name of your Table/Query? Code: DSum ( expression, domain, [criteria] ) Code: DSum("Price", "TABLE/QUERY", "Article = Baby Milk") http://msdn.microsoft.com/en-us/library/office/ff193998.aspx Video, basic DSUM. http://www.599cd.com/tips/access/130809-dsum/?key=AlexForum
A azhar2006 Registered User. Local time Today, 04:56 Joined Feb 8, 2012 Messages 297 Dec 8, 2013 #3 Thank you very much on the speed of response
A azhar2006 Registered User. Local time Today, 04:56 Joined Feb 8, 2012 Messages 297 Dec 8, 2013 #4 Hello AlexHedley :banghead: Shows me an error in the text box Attachments BabyMilk.zip BabyMilk.zip 34.6 KB · Views: 119
A AlexHedley Registered User. Local time Today, 12:56 Joined Aug 28, 2012 Messages 171 Dec 8, 2013 #5 What is the code in your textbox?
A azhar2006 Registered User. Local time Today, 04:56 Joined Feb 8, 2012 Messages 297 Dec 8, 2013 #6 =DSum("Price","products","Article = Baby Milk")
A AlexHedley Registered User. Local time Today, 12:56 Joined Aug 28, 2012 Messages 171 Dec 8, 2013 #7 Cross Post http://www.accessforums.net/forms/dsum-function-39929.html
