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

Footer caculation on Continuous Form

P: 2
Using Access 2003

I have created a continuous form with an iif statement in the detail section which i'd like to sum in the footer. The iif statement is in a text label called [count]; iif([coninc]='Correct',1,0). When I attempt to add a text label to the footer as follows, =sum([count]), it returns error?

Please help me...it's driving me nuts!
Sep 14 '07 #1
Share this Question
Share on Google+
1 Reply


Scott Price
Expert 100+
P: 1,384
Using Access 2003

I have created a continuous form with an iif statement in the detail section which i'd like to sum in the footer. The iif statement is in a text label called [count]; iif([coninc]='Correct',1,0). When I attempt to add a text label to the footer as follows, =sum([count]), it returns error?

Please help me...it's driving me nuts!
Make sure your text label is storing/passing a number format and try changing =sum([count]) to =sum(Me![count])

Regards,
Scott
Sep 14 '07 #2

Post your reply

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