<p>I am trying to run a query that will give time averages but when I do... some duplicate records are in the calculation.  how can I remove duplicates?</p>

<p>ex.</p>

<p>Column 1   /    07-5794 /    07-5794  /   07-5766 /  07-8423   /   07-4259</p>

<p>Column 2   /    00:59:59  /  00:48:22 /    00:42:48/   00:51:47  /  00:52:12</p>

<p>I can get the average of the column 2 but I don't want identical values in column 1 to be calculated twice (07-5794) ???</p>

To get the average of the minimum values for each incnum, you could write this SQL
```
```
select avg(min_time) as avg_time from
    (select incnum, min(col2) as min_time from inc group by incnum)
```
```
using the correct average function for your brand of SQL.
If you're doing this in Access, you'll want to paste this into the SQL view; when you use a subquery, you can't do that directly in design view.