Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Red face Unanswered: counting days worked (i guess no one can help)

    I have fields as such:
    Ticket Number Date District (and others not pertinant)
    Ticket Number field is auto numbered, cant change, every record is unique.
    Date field is auto inserted, can change if needed.
    District field values are selected from a fixed list (CGSD, CASD, JMSD, SEGSD).

    I would like to keep a running count of days worked at each district and a grand total of all 4 districts. There could be several entries for each district on any day, example:
    Ticket Number Date District
    1 11/03/2003 CGSD
    2 11/03/2003 CGSD
    3 11/03/2003 CGSD
    4 11/04/2003 JMSD
    5 11/04/2003 JMSD
    What I would like to see is that I worked 1 day at CGSD and 1 day at JMSD and total days worked would be 2.
    Any Help would be appreciated
    Last edited by unclejoe; 12-27-03 at 14:30.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts