R
Rick Z
I was wondering if anybody could tell me a way to count
the total of unique dates in a query. For instance, In a
report that returns production information, I need to
return the number of days worked. Each day worked may have
3 or 4 different production items. Each production item is
recorded with its date and shift but needs to be counted
as one production day. There may be several days between
when there is no production which I dont want to count or
there may be partial days worked that I do want to count.
This seems like it should be such a simple thing to do but
it seem I'm not getting it,
Any help would be appreciated.
thanks,
Rick
the total of unique dates in a query. For instance, In a
report that returns production information, I need to
return the number of days worked. Each day worked may have
3 or 4 different production items. Each production item is
recorded with its date and shift but needs to be counted
as one production day. There may be several days between
when there is no production which I dont want to count or
there may be partial days worked that I do want to count.
This seems like it should be such a simple thing to do but
it seem I'm not getting it,
Any help would be appreciated.
thanks,
Rick