Hi there
i have access 2016 and new to this forum. thank u for helping me.
i have some fields in this multiple records. and some textboxs. and i have field that Multiply these and show answer in every record of form. its like this =[field1]*[Text1]+[field2]*[Text2]+[field3]*[Text3]. and that field name is like text50
the problem is
i want to sum all of text50 in every records and show them in footer but i get #error
i did these before : sum([text50]} or dsum([text50]} or even sum([field1]*[Text1]+[field2]*[Text2]+[field3]*[Text3])
i have access 2016 and new to this forum. thank u for helping me.
i have some fields in this multiple records. and some textboxs. and i have field that Multiply these and show answer in every record of form. its like this =[field1]*[Text1]+[field2]*[Text2]+[field3]*[Text3]. and that field name is like text50
the problem is
i want to sum all of text50 in every records and show them in footer but i get #error
i did these before : sum([text50]} or dsum([text50]} or even sum([field1]*[Text1]+[field2]*[Text2]+[field3]*[Text3])