Access: How to report inception to date?

[RLA]

My problem is that I am writing a report that shows monthly, YTD, and inception-to-date columns. The inception to date data is not immediately calculable, because it is stored as totals pre-2002 in a table. My report calculates the monthly and YTD figures from queries and different tables: first-time group loans, first-time term loans under $5000, first time term loans over $5000, total group loans, total term loans under $5000, and total term loans over $5000. In other words, I am trying to count and to sum data from two different sources in one field (and the data has criteria attached, i.e.

=DCount("[qry2ndMLAReportMembers3]![rowno]","[qry2ndMLAReportMembers3]","([qry2ndMLAReportMembers3]!

  Like  'G*') AND  [qry2ndMLAReportMembers3]![sub]=1 ").  

I really have no idea how to proceed.  Any help would be greatly appreciated!!!