What I have is payment data for bond repayments. Each year there are two payments. I'm able to get all the data in one query with each type of bond payment summed by date. However, I also want to list the total payments for each fiscal year in the report in the row for the second payment each fiscal year. I calculated the total fiscal year payment in another query by grouping by fiscal year. However, I don't know how to create the report using mulitple record sources and I don't know how I could put all the data in one query because I don't want the overall data grouped by fiscal year. From what I've read on subqueries that wont work because I am not trying to reduce the overall number of records. I just want another column of data that lists the total payments for each fiscal year. The total number of records I start with is around 5000. The number of records for the report is 964.

i dont quite understand the way you are describing this

but you know the way access does a form/subform, linking an id in the main form with records in the subform.

well you can do exactly the same thing in a report

so have a main report to show the main data

another report to show the linked summary (no headers/footers etc - just brief detail)

drop this INTO the detail section of the main report - set the links as appropriate - should give you what you want - also make sure this is set to "cangrow"

Thank you that worked beautifully! I did set the subreport to can't grow so I can smash all the data together.