[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 664
  • Last Modified:

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'")
0
motioneye
Asked:
motioneye
2 Solutions
 
mbizupCommented:
You have an extraneous space before "None":


=DSum("SupplierCost","invoice","supplierpayment='None'") 

Open in new window

0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
is this:

"supplierpayment=' None'"

  Correct?  You have <space>None

Jim.
0
 
motioneyeAuthor Commented:
Thanks guys, I really messed up myself ...
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

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