[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

Sum and Dlookup

Posted on 2015-01-22
3
Medium Priority
?
158 Views
Last Modified: 2015-01-22
Experts, I need to sum [Amount] on tblDisbursement_Amounts.  
I have tried to input the word sum but I am off somewhere.

Let me know where to put the word Sum and the parenth

=DLookUp("[Amount]","[tblDisbursement_Amounts]"
0
Comment
Question by:pdvsa
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 

Author Comment

by:pdvsa
ID: 40565395
I am not sure if Dsum is better?
0
 
LVL 18

Accepted Solution

by:
Simon earned 2000 total points
ID: 40565403
Use DSUM instead of DLOOKUP...

=DSUM("[Amount]","[tblDisbursement_Amounts]" )

This link shows the syntax : https://support.office.com/en-ie/article/DSum-Function-08f8450e-3bf6-45e2-936f-386056e61a32

The third argument is optional, if you need to specify criteria.
0
 

Author Closing Comment

by:pdvsa
ID: 40565465
Perfect.  thank you

I added the criteria:
=DSum("[Amount]","[tblDisbursement_Amounts]","[ID_disb]=" & [ID_disb])
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

649 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