B
blairhenry
Guest
Hi,
I have a query that accesses information from 2 tables. One is a master and the other is a sub-table.
The relationship is one lossid in the master can have many records in the subtable.
I need to do a count of how many unique records exist in the master table but I keep getting the total number of records including the duplicates from the subtable.
Any help would be appreciated, I'm probably not explaining it correctly.
I have a query that accesses information from 2 tables. One is a master and the other is a sub-table.
The relationship is one lossid in the master can have many records in the subtable.
I need to do a count of how many unique records exist in the master table but I keep getting the total number of records including the duplicates from the subtable.
Any help would be appreciated, I'm probably not explaining it correctly.
