Link to home
Start Free TrialLog in
Avatar of motioneye
motioneyeFlag for Singapore

asked on

Access: Dsum function return no values without getting any errors

Hi,
a following dsum function which I have created in my access control form. It don't have any error on syntax but when I run the form, it doesn't show me a values.

=DSum("SupplierCost","invoice","supplierpayment=' None'")
ASKER CERTIFIED SOLUTION
Avatar of mbizup
mbizup
Flag of Kazakhstan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of motioneye

ASKER

Thanks guys, I really messed up myself ...