selective summing in a report

  • Thread starter Thread starter Devon
  • Start date Start date
D

Devon

I work in the financial industry. One of the new types of mutual funds being
offered are age-based (depending on what year you were born decides which
fund you will move into). I am trying to create a report that will show the
money moving out and money moving in will balance.

For example, let's say I am mapping money from funds a, b, and c. This
money would be mapping into the age-based funds (s1, s2, s3....s10). When I
currently run the report, I am getting fund a with S1....S10, fund b with
S1...S10, and fund c with S1....S10. This is not correct.

What it should read would be:

From Fund: To Fund:
a $1000 S01 $X.xx
b $1000 S02 $X.xx
c $1000 S03 $X.xx
S04 $X.xx
S05 $X.xx
S06 $X.xx
S07 $X.xx
S08 $X.xx
S09 $X.xx
S10 $X.xx

Total From: $3000 Total To: $3,000

Hope this rough example makes sense.

Thanks
 
Hello,

I don't know how you are compiling your data but from what I see you would
be well off to run through the source data, identifying each origin fund and
placing it into a record in a temporary table, designating which age-based
fund it goes into. So the procedure would look at the record for Fund A
($1000) for example and decide it goes to age-based fund S3 ($1000) and
place it into a record. So $1000 would be designated for this transaction
from Fund A to Fund S3. You could then use a totals query to summarize the
transactions.

God Bless,

Mark A. Sam
 
Back
Top