I have 2 tables, ClassCode & Customer. ClassCode has fields RatingClassCode, CustID, & Premium. Customer has CustID and LastName. I have a query that returns duplicate RatingClassCode with matching LastName and associated Premium. A link to the result is here, please look.
http://bbtitusville.com/query.jpg
How can I return a single row for each RatingClassCode w/ matching LastName but SUM up the Premium?
For example 1st row would read:
8820 BrevardCounty $917.00
with the proper SQL statement instead of the 1st 2 rows in my result:
http://bbtitusville.com/query.jpg