FORM CALCULATIONS NOT MIGRATING TO TABLE AND ON EXCEL EXPORT

[stevembe]

Thanks for taking the time to read this and hopefully somebody can help. I have a from built from a table with the following calculation insterted in a field: =[Offers]+[Started]-[Number]. The calculation works fine in the form but the table just states 0 and when I migrate to excel it is the same. Any ideas where I am going wrong?

[ranman256]

Thanks for taking the time to read this and hopefully somebody can help. I have a from built from a table with the following calculation insterted in a field: =[Offers]+[Started]-[Number]. The calculation works fine in the form but the table just states 0 and when I migrate to excel it is the same. Any ideas where I am going wrong?

As long as you have 3 fields on the form called: Offers, Started, & Number that is good BUT ...
the query needs the whole path to the fields...so the query SQL would be

=forms!frmMyform!Offers+forms!frmMyform!Started-forms!frmMyform!Number