Calculation

[Stefanovski]

Hi folks,

I got a question so please help me out if you can.

How can I multiplicate two numbers from two columns in a subform, show their result at the end of the row and then calculate sum of those results on the main form. This is something what I know how to do but the problem is following:

The total sum on the main form should be multiplicated wit 0,5 % and then reduced for a value of a specific row sum. It should be something like this: (Sum of rows sum * 0,5 %) - Sum of the specific row = Total sum on the main form. And all of this should be on a report too.

Thank you for help.

 

[The_Doc_Man]

If you drive the subform via a query instead of directly from a table, some of that summation can be done in the query and the rest could be done on the form with a DSum or by changing the source of the individual control to include the multiplication.

Alternatively, you can also write layered queries to perform the steps in the right order. If the only place you need this is on the form, do as much on the form as you can. If it also appears in a lot of reports, consider the query approach.