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

Sum of Sub form field in main form

P: 1
Hi, I need help to get sum of field in subform to main form field

I am using Mainform's field (total) default value =Sum([Forms]![Item subform]![charges])

Please help
Aug 28 '08 #1
Share this Question
Share on Google+
1 Reply


Expert Mod 2.5K+
P: 2,545
Hi, and Welcome to Bytes!

I am not fully clear what you wish to SUM, but assuming it is the value in the subform control called charges you are just slightly in error with your syntax. It should be
Expand|Select|Wrap|Line Numbers
  1. =Sum([Forms]![Item subform].Form![charges])
See the following article from our HowTo section on Referring to Items on a Subform.

-Stewart
Aug 28 '08 #2

Post your reply

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