BorlandTalk.com

CC · Guest

Hello!

I have a table that contains work orders, like this:

WorkOrderID
DateCompleted
TechnicianID

Each technician works non-specific days, that is, in a 14 day period a
technician can work anywhere from 0 to 14 days.

Here is the problem:

I can get a SQL statement like this:

select count(DateCompleted) as DaysWorked, TechnicianID,
DateCompleted...

The problem is that a tech may do 15 calls in 1 day. The count above
would return 15 for 1 day (as it counts the days non-uniquely instead
of it coming up with 1.

PS select count(distinct DateCompleted) does not work with MDB files.

Thanks.