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

Sum([Fieldname]) within Footer of Continuous Form Problem

P: 129
Hi i have a main form and sub form with a one to many relationship. The sub-form is constructured of four fields, StaffUserID, AdminID, Hours Assigned and Comment. I have a combo box for the Admin Duties which saves the AdminID in the appropriate field. The Hours Assigned Control Source is based on the Admin Duties combo box, with a code of =[cboAdminDuties].[Column](2). The Format of the Hours Assigned is Integer with input mask of 9999. As i have a list of many Admin Duties i want to add all the Hours Assigned together so i put a text box in the footer of the sub-form called txtTotalHours and applied a control source of =Sum([txtHoursAssigned]) however i receive an Error message. Can anyone tell me why?
Jul 24 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 1,923
The why is because you need to sum the what is contained in the underlying control source.
Jul 25 '09 #2

P: 129
Thanks for that it worked a treat.
Jul 25 '09 #3

Post your reply

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