1 Reply Latest reply on Sep 25, 2011 6:57 AM by LaRetta_1

    How to count amount the word Sick days are in my database

    LeoBally

      Title

      How to count amount the word Sick days are in my database

      Post

      Dear Forum

      I am quiet new with Filemaker pro and I did the web pages training but I have not found the solution for how many sickdays are reported in a month.

      I am making a montly time tracking database for a client and give on Tuesday a demo.

      I would be great if you can help me how to solve this.

      I have a field called (days type) where employees can fill in of it is normal working day sick days and vakation days.Of course on a monthly base the cusomer need to knwo how many sick days and holidays are ( can be graphic)

      It would be great if you can give me a detailed example ( I olny need copy and paste) to solve this

      issue. I worked with "word coun"t and with If (days type= sick days);1;0

      and the count sick days 

      but both solutions are not working.

      Is there an command that counting the words that you can defined

      Like

      count amount (Sick Days; days type)

      thanks

      Leo