Lawrence Salvucci
asked on
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') & "#")
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER