Hello,
I am a Access noob and I need help. I have a project where I need to sum totals from multiple text boxes that are populated from a combo box drop down menu on a form. I’m creating certificates after our conference where I’m choosing from the list of sessions for each attendee, I need the credit for those sessions to total.
I’ve tried the following formulas in the Control Source area of the total text box but I cannot get anything to work. I've also attached pictures for reference.
=[Text82]+[Text88] This concatenates
=Sum([Text82])+Sum([Text88]) Gives an Error Message
=DSum("Text82","[Text88]") ERROR
=Sum(nz([Forms]![subCalendar]![Text1]))+(nz([Forms]![subCalendar]![Text25])) ERROR
=Sum((Val([Text82]))+(Val([Textbox88]))+(Val([textbox92]))) ERROR
=Sum([column1])+Sum([column2])+Sum([column3]) ERROR
=Sum([Text82]+[Text88]+[Text92]) ERROR
Any help would be much appreciated…..I have a second issue of wanting to total the different fields of study at the end as well but I’ll take what I can get!
Thanks!
Olivia