Improve company productivity with a Business Account.Sign Up

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

DSum syntax problem

I'm trying to do a DSum using this control source but it isn't working.  What would the correct syntax be?

=DSum("[ReadyQty]","tblReady","[TextMNumber] = " & [Forms]![frmPlanted]![cboTextMnumber.Column(0)])
0
SteveL13
Asked:
SteveL13
  • 2
1 Solution
 
SteveL13Author Commented:
Note:

cboTextMnumber.Column(0)]) is a text field.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
=DSum("[ReadyQty]","tblReady","[TextMNumber] = " char(34) & [Forms]![frmPlanted]![cboTextMnumber.Column(0)] & char(34) )
0
 
mbizupCommented:
=DSum("ReadyQty","tblReady","TextMNumber = " & Forms!frmPlanted!cboTextMnumber.Column(0))

Open in new window


You don't need all the square brackets, but your syntax actually looked good.  Double check field names
0
 
mbizupCommented:
-->>> cboTextMnumber.Column(0)]) is a text field.

Whoops - Guy is correct.  You need quotes.

But his Char(34) should be Chr(34)    -- no points please.
0
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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

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