SELECT qrySysEnhDistributionMaster.DistYear, qrySysEnhDistributionMaster.Sequence, qrySysEnhDistributionMaster.ZoneSequence, qrySysEnhDistributionMaster.Zone, qrySysEnhDistributionMaster.AvgOfDistribution, qrySysEnhDistributionMaster.City, qrySysEnhDistributionMaster.Distribution, qrySysEnhDistributionMaster.DistributionAmt AS DistributionAmt2, qrySysEnhDistributionMaster.AnnualReport, qrySysEnhDistributionMaster.EffectiveZone, qrySysEnhDistributionMaster.CityCounty
FROM qrySysEnhDistributionMaster
WHERE (((qrySysEnhDistributionMaster.CityCounty)="City"))
ORDER BY qrySysEnhDistributionMaster.Sequence, qrySysEnhDistributionMaster.City
UNION SELECT qrySysEnhDistributionMaster.DistYear, qrySysEnhDistributionMaster.Sequence, qrySysEnhDistributionMaster.ZoneSequence, qryTotalsOfDistribution2.Zone, qrySysEnhDistributionMaster.AvgOfDistribution, qrySysEnhDistributionMaster.City, qrySysEnhDistributionMaster.Distribution, [DistributionAmt]-[Difference] AS DistributionAmt2, qrySysEnhDistributionMaster.AnnualReport, qrySysEnhDistributionMaster.CityCounty, qryTotalsOfDistribution2.EffectiveZone
FROM qryTotalsOfDistribution2 INNER JOIN qrySysEnhDistributionMaster ON (qryTotalsOfDistribution2.Zone = qrySysEnhDistributionMaster.Zone) AND (qryTotalsOfDistribution2.Zone = qrySysEnhDistributionMaster.Zone)
WHERE (((qrySysEnhDistributionMaster.CityCounty)="county") AND (Not (qryTotalsOfDistribution2.EffectiveZone)="nw-r"))
ORDER BY qrySysEnhDistributionMaster.Sequence, qrySysEnhDistributionMaster.City;