Doing calulations in a report

[Jimenda]

I am trying to build a report that gives me the sum of the values in a field of one of my tables. I would need this sum to only be from selected entries in that field (conditionally selected by the entry in another field in the same table), also I need to format the entries to be summed up either postive or negetive numbers based on yet another field in that table. Thank you in advance for your assistance. Should I be doing this in a query first and then the report? I should could use some help.



Thank You and God Bless,

JIMENDA

 

[willir]

You can also use / create a function to do this.

The advantage of a function is that it can run the same query but accommodate different conditions. For example...
- use a dynamic WHERE clause depending on circumstances
- add multiple values
- return different values depending

Richard