I am wondering if we can add mathematical formulas in a Grid Q&A Table much like you would in excel. If so, I would then like to take those calculated answers from the grid populate a table within the Form. Is this even possible?
I am attaching an excel spreadsheet that will show you what I am doing in excel and if possible I would like to do this within the form rather than having the inspectors take the measurements in Excel and then copy and paste them into the form.
I currently have a Q&A Table in my form. I also added a table within the form that I would like to pull the calculated answers into. I am stuck however.
Thanks for your continual help.
Thanks, Lynda (for Rick)