Dlook & DSum in Report and groups by Report Groupings

[gumby]

Is it possible to do a dlookup or dsum within a report grouping that
only returns a value from a record field that equals the record field
in the query for the report.

My report is grouped by Month Name. I have another table that holds
the number of statments that our mailed out each month. In that table
it has a fields [MonthFullName]. In the query for the report it has a
fielded called [MonthFullName]. These feilds are not related in any
fashsion. However I would like to plug in the total number of
statements mailed each month into the grouping on the report to
determine the percentaged of reviewed. I am unable to add this field
to the main table since it is a ODBC connection.

Thanks,
David

 

[gumby]

=DLookUp("[VISN5]","qryRX2007_Statements","[MonthNameF]=[MonthNameFull]")

I figured it out. [MonthNameF] is the name of the field in the table I
want to lookup and [MonthNameFull] is the field my report is grouped
on.