Help with Query Please: different values on duplicate records

[mbr661]

I have a table with 3 columns: ContractAcct, PREM, and LocNo.

I created a query to show me duplicate ContractAcct numbers:

100000341790 010106
100000341790 010106
100000341793 010108
100000341793 010108

I need now a second query that will show me only the ContractAcct numbers that have different PREM numbers.

For example:



100000341791 010106
100000341791 010108

Can anybody point me in the right direction?

Thanks in advance

[Bob Fitz]

Perhaps you need to create a "Totals" query (based on your existing query).
Take a look at the link below:
http://office.microsoft.com/en-gb/ac...005188531.aspx