9 Replies Latest reply on May 16, 2011 2:37 PM by MakerofFiles

    Something that should be very simple to do...

    MakerofFiles

      Title

      Something that should be very simple to do...

      Post

      I'm trying to make a database to perform what I think is very simple task. 

      I have an existing database with two fields: one called "Names" the other called "hours".

      I want to write a script that will go through each record (about one hundred) and tell me if a certain employees have less than 40 hours. 

      Some employees (part time) are expected to have less than 40 hours and I don't need it to return any info on those.

      But I would like to see a list of full time employees who have less than 40 hours. 

      Can anyone help?