Try

Sele epkey, count(DISTINCT date) from histwkrd where date between date1 and date2 group by epkey

>I think it must be Friday... as my mind has gone to lunch this afternoon. I know its only Thursday :)
>
>I have a table with multiple records for employees and dates...
>ie epkey 15, might have 4 records on date 1, 3 on date 2, etc...
>
>I don't want to count the records, I want to count the dates...
>ie if i just looking at date range between date 1 and 2, I don't want a count of the records, rather a count of the unique dates, ie 2 not 7.
>
>A simple Select like this doesn't work.
>
>Sele epkey, count(date) from histwkrd where date between date1 and date2 group by epkey
>
>would return based on the above data, 7 where I would only to see the distinct dates ie, count those, not all the records.
>
>I know I can do this with two queries, but is there a better way?
>
>TIA,
>Mike