Simple Math Functions - I just want to subtract within a report!

[PATRICKPBME]

This was so easy in Excel I figure I just must be missing something. I have a report that contains two fields, each from a different table. The record in each field is a dollar amount. All I want to do is subtract one field from the other so I can have the difference listed on the report.

[jwhite]

If both fields are in your query for the report RecordSource, then return a new field in the query with the result of subtracting one field from another, such as: CalculatedValue: [tblTable1].[Field1] - [tblTable2].[Field2]

[pbaldy]

I would also do it in the query, but FYI you can do it on the report. A textbox with a control source of:

=Field1 - Field2

should work.

[PATRICKPBME]

Thank you! I did it on the report and it appears to be working! However, for some of the results instead of a figure I am getting "#Type!" as a result. I am wondering if this is telling me that the numbers I am working with are not formatted in the same way? I will check that. Thank you again.

PS Think I found the problem. Misplaced decimal point!

I would also do it in the query, but FYI you can do it on the report. A textbox with a control source of:

=Field1 - Field2

should work.

[pbaldy]

Glad you got it working.