Thanks for your answer!!

But my problem is that the leader off the production line want to look at how many hours employee have between
to dates.
If at the same time the leader off the technical staff want to look at the employee he is responsible for.
5 sec after lead off prod.line push calc button lead. off tech push calc button,
the end result will be between the to dates which the last leader calculated.

The leader of the prod. line will not see anything, because the end result is between the to dates the leader off
the tech. staff entered (if he entered it last).

I have to do this calculation, because the raw data is just times when the emp. enter work and leave work.
And from this Im calculating, regular hour payed, overtime payed and some other benefits the employee gets when
his working overtime. Afther 2,5hour overtime he have 0,5hour payed food, afther 4,5hour overtime he gets another
half hour payed food etc. If he is working in the second shift from 15.00 to 23.30 and is called to work from
08:00 to 12:00 he is to be payed overtime.
Then after calculating his work hours, I'm calculating his fee, which is a calc off how many kilo off fish he has been cutting,
how good the yield is and the size off the fish. All this data is also rawdata, which gives me only how many kilo he have been
producing.
I use a lot of SELECT SQLs to get the end result.

In my software everybody have to login with a user ID and a password.
I have connected the user ID with departments which the user is responsible for. This info I use in views to show
only the dep. when the user is correcting things.

So what to do? When calcultating between fromdate,todate. It is not good to block other users.
The user can max calculate one week, this is because the average hour payed is based on one week.

In the end off the week, when everything is calculated and corrections are made, the final calculation is done and the
result an ASCII file is transfered directly into the companys salary software.
A new week starts and new calc. is done.
The raw data is growing every day. My data is only between to dates.

Do I have to make a subset off all my SELECT SQL which generates different result??
Like USERID+tablename. Then when everything is ready to transfer to the salary software only one have access
to do this???

Im stuck here

Best regards

Per Simmersholm