<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body ><div style="font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 18pt;"><div>I have a LO Form that has multiple fields that need to be added and result placed in another field.<br></div><div><br></div><div>Example: My form is for a Bounce House Company and has:<br></div><div><br></div><div>Fields <b><u>rent1 thru rent8 </u></b>and as each field is entered in the contract I need the contract Total field named <b><u>total</u></b><b><u>rent</u></b> accumulated with the total amounts of <b><u>rent1 thru rent8</u></b> only for<b><u> new contracts</u></b>.<br></div><div><br></div><div>I have tried multiple resolutions using Querys or SQL statements and nothing works. When I include SQL or Querys to the <u><b>totalrent </b></u>the form loads as blank with a SQL error.<br></div><div><br></div><div>Can anyone help me. If a reasonable fee is required I am open to that.<br></div><div><br></div><div>Thanks Tony <a target="_blank" href="mailto:thewop@zoho.com">thewop@zoho.com</a> <br></div><div><br></div><div> <br></div><div><br></div><div class="zmail_signature_below"><div id="" data-zbluepencil-ignore="true" data-sigid="2540025000000008028"><p style=""><span class="colour" style="color:rgb(42, 42, 42)">Sent using <a style="color: rgb(89, 143, 222)" href="https://www.zoho.com/mail/" target="_blank">Zoho Mail</a></span><br></p></div></div><div><br></div></div><br></body></html>