Need help with A2K report/subreport, please

[Ellen Manning]

I've got a report with a subreport linked on fund number. The
subreport returns 2 columns of dollar amounts, both current and YTD,
by object code for the selected fund number. The user can select one
or many funds.

I create a query for the subreport's recordsource in the open event.
My problem is that if there's more than one fund number, YTD amounts
from the first fund number show up on the 2nd fund numbers' report,
overwriting the 2nd fund's YTD amounts, which then show up on the 3rd,
overwriting that YTD amount, and so on. The current amounts are fine.

I've verified that the query returns the correct set of records for
the fund's YTD amounts. I just can't figure out why the YTD amount
would be overwritten for the 2nd fund and so on. If I run the report
separately for each fund then the YTD amounts are fine.

Thanks for any help or advice.

[Salad]

Ellen Manning wrote:

I've got a report with a subreport linked on fund number. The
subreport returns 2 columns of dollar amounts, both current and YTD,
by object code for the selected fund number. The user can select one
or many funds.

I create a query for the subreport's recordsource in the open event.
My problem is that if there's more than one fund number, YTD amounts
from the first fund number show up on the 2nd fund numbers' report,
overwriting the 2nd fund's YTD amounts, which then show up on the 3rd,
overwriting that YTD amount, and so on. The current amounts are fine.

I've verified that the query returns the correct set of records for
the fund's YTD amounts. I just can't figure out why the YTD amount
would be overwritten for the 2nd fund and so on. If I run the report
separately for each fund then the YTD amounts are fine.

Thanks for any help or advice.

Can you sort/group/total on fund number?