Something that should be very simple to do...
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?