You could add an onerror statement that either takes it to the next iteration level or displays a dialog box that tells you it didnt find anything and then exits the procedure.
After you create your result field in your table, you could create an update query which would calculate the multiplication or addition of your two data fields and update the result field with the answer.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.