calculations

[killerleaf]

I am trying to figure out how to some calculations that will print in a report. however, I don't have an idea where to start. I have tried looking in the help file, but apparently I am not putting the right things in to get what I need.

what should I put in the index or answer search to find out how to do some basic calculations?

 

[mdmilner]

The easiest way to do this (what I first learned to do) is to build something like this in a query and then base the report on the query. You can do this by creating fields that only exist on the report.

Go make a query with the same data that you're wanting to put onto the report. In Design mode, pick a blank column and then use this type of syntax:

CalcFieldName: calculation

CalcFieldName will be the 'fieldname' that appears.
The calculation will be whatever you're doing...aka,

((field1+field2)/2)+90)

With the end result being:

CalcFieldName: ((field1+field2)/2)+90)

Use all your standard math operators. When you create your report, use the query as your source. As a recommendation, good practice is to name your tables and queries in a fashion that is always recognizable. I tend to add 'tbl' and 'qry' in front of each. That way, when looking at a list, I don't have to guess which I just selected.



Mike