Multiple calculations in one report, Access 97 3

[beasleyd]

Hey everyone. I'm still an infant when it comes to Access, so please bear with me.

I'm part of a Financial Advisory company and I've created a report of our clients that still have cases pending (not completed).

It is organized like below:

Plan Type (e.g.- Disability)

Total Commissions for this plan: (Sum of all listed commissions for this plan)

Commission(currency) ClientName Agent
Commission ClientName Agent
Commission ClientName Agent

That's generally what it looks like. Okay, what I need to do is this - you see how it takes the sum of say... all the Disability plans, or Life, or whatever the current plan is? I need to make specific calculations for each plan.

Each plan has different ratios when it comes to "Points" and "Dollar amounts"... for instance, a Life plan may be 1:1 in Pointsollars, but Disability may be .5:1.

I know this might sound confusing, I'm not really sure how to phrase it all properly. I'd like to display "Points" next to "Total Commissions for this Plan" and have it displayed, so no one has to do the math themselves.

Can anyone understand what I'm getting at? Any help would be appreciated, let me know if something is unclear.

Thanks a lot.

 

[PaulBricker]

Your more than welcome David. Post back if you have any problems.
Good luck.

Paul