By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,477 Members | 1,602 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,477 IT Pros & Developers. It's quick & easy.

DSUM with expression that has a space ( i.e

P: 1
I am stuck on a DSUM expression, where my table has several fields that include a space ( like "Amount Paid" ) My DSUM expression isnt working when it encounters a field name with a space, What is the adjustment I need to run the DSUM on these field names that include a space?
Nov 22 '17 #1

✓ answered by PhilOfWalton

Ah ... you see folly in having spaces in field names, table names
and query names
AmountPaid is just as clear, but if you insist on using spaces, always use square brackets round a name with spaces because Access usually assume that a space indicates a new "instruction" is starting.

Expand|Select|Wrap|Line Numbers
  1.     DSum("[Amount Paid]", MyTable")
  2.  
Phil

Share this Question
Share on Google+
1 Reply


PhilOfWalton
Expert 100+
P: 1,430
Ah ... you see folly in having spaces in field names, table names
and query names
AmountPaid is just as clear, but if you insist on using spaces, always use square brackets round a name with spaces because Access usually assume that a space indicates a new "instruction" is starting.

Expand|Select|Wrap|Line Numbers
  1.     DSum("[Amount Paid]", MyTable")
  2.  
Phil
Nov 22 '17 #2

Post your reply

Sign in to post your reply or Sign up for a free account.