Solved

DSum in Access Form

Posted on 2013-06-06
2
420 Views
Last Modified: 2013-06-06
I'm trying to get my DSum formula to work but it doesn't seem to want to. I'm using the criteria with formatting to 'mmm-yy' but it doesn't seem to work. Can anyone shed any light on the problem?

=DSum("fqtyrecv","qryPOHistory","Format([fdaterecv],'mmm-yy')=#" & Format([Forms]![sfrmPurchaseAnalysisPOHistory]![txtMonth1],'mmm-yy') & "#")

Open in new window

0
Comment
Question by:Lawrence Salvucci
2 Comments
 
LVL 4

Accepted Solution

by:
BAKADY earned 500 total points
Comment Utility
Try this:


=DSum("fqtyrecv","qryPOHistory","Format([fdaterecv],'mmm-yy')='" & Format([Forms]![sfrmPurchaseAnalysisPOHistory]![txtMonth1],'mmm-yy') & "'")

NOTE: Format convert your values into strings!!!

Regards
0
 
LVL 1

Author Comment

by:Lawrence Salvucci
Comment Utility
Ahhh...Gotcha! Thank you!
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

743 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

16 Experts available now in Live!

Get 1:1 Help Now