Excellent! Thank-you, June7! Very much appreciate your assistance. As a novice, I've never used a nested query before. I had to fiddle with the syntax to make it work, but I definitely owe you a beer. Code worked out like so:
Code:
SELECT [meter].[RPUID] AS RPUID, [meter].[utility] AS UTILITY, Count(meter.meterclass) AS CountOfmeterclass
FROM (SELECT DISTINCT RPUID, utility, meterclass FROM meter) AS T
GROUP BY T.RPUID, T.utility
HAVING (((T.utility)="electric") AND ((Count([meter].[meterclass]))>1));
The table contains several thousand records, and the code returned the count on every property, including properties with a single meterclass, so I had to filter those out using >1, but this worked great!
Again, many thanks to you!