Here is my issue. I have a Form and Report that Mirrors the Form. I have the exact same formula in both the Form and the Report. The Form formula work fine. The report formula is not calcualting the right amount. It appears to be adding one of the fields twice. I have copied the formulas out into a word document and put them side by side to make sure there was a duplication of a field, in the calcution itself. There is not. I don't know what else can be wrong. All the same calcualted fields that are in the form are in the report as well. I have check the fields on the report, and the query behind the report.


Does anyone have any ideas why the report would be adding more than the same foumula on the form? Thanks!

NEVER MIND - I fixed the problem by putting the formula in the query and then putting that field on the report instead.