Subform data doesn't populate Report or Query

[nrh0804]

I built a subform and have fields with different amount. Other fields show YTD Amount, YTD Received, YTD Balance Due. I used the expression builder "sum" to populate those fields.

However, the three YTD fields (sums) will not populate Reports or Queries. Any guidance will be greatly appreciated.

[June7]

Calculated values are not automatically saved to tables. This requires VBA code. Aggregate data should not be saved to table. You should do these same calcs in a report.

[nrh0804]

Thank you June7. Your advice worked well.