Usually a field called village would define a grouping of homes in a village
[  :)  ]

There is a field called village that is used to define whether a home
belongs in a village.  If not, there is no value there (the management
company will not let us use "None" since they combine our report with other
neighborhood HOA's).  The table includes normal home owner stuff including:

OwnerName
StreetAddress
Village
City
State
ZIP
PurchaseDate

There are reports like payment history where the neighborhood is grouped by
villages with monthly, yearly and grand totals.  It is grouped by village
because dues can vary depending amenities in the village.  Homes not in
villages are then lumped in together at the end of the report.

The problem is the homes not in a village still show grouped as a village
with a village group footer showing totals with a blank village designation.
I would like to have the report just show this as a blank versus showing a
village total, which it is not.

Thanks!

Are we supposed to understand you data and what determines if a home belongs
to a specific village? Could you provide some information that would allow
us to more than guess at an answer? Maybe if we had some sample records and
a note whether or not they would be include and why or why not.