• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 519
  • Last Modified:

DSum in Access Form

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

Lawrence Salvucci
Lawrence Salvucci
1 Solution
Try this:

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

NOTE: Format convert your values into strings!!!

Lawrence SalvucciInformation Technology ManagerAuthor Commented:
Ahhh...Gotcha! Thank you!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now