Lock/ lås på forespørgsel

Without more information as to where you are using the query it isnt easy to give a solution!
I can imagine that a period is closed when a field is given a date! So in the query you could have a criteria which tests if the field is empty (NULL)
So as soon as the field is given a value it will no longer be visible in th equery!

Nej ikke helt Terry man skal have mulighed for at gå tilbage og kigge indtil at lønperioden er slut og lønnener kørt - Herfter skal det gerne kunne skjules, således de ikke vises til medarbejdere længere - Og således de ikke indgår i den pågældende periode mere

As I said in my first comment (Without more information as to where you are using the query it isnt easy to give a solution!)

I cant see your tables/queries/forms and reports etc. so it is not easy to see what solution is best. This information must come form you!

Some how you have to have some indication in the query as to whether or not the data has to be included in the output, this could be an flag (yes/no) indicationg that "lønnener er kørt". And then you would use this to filter the records.

But I think you will need to give further information!

Hvis du forestiller dig at jeg har 3 tabeller - Projekt medarbejder - timer -

Disse til sammen udør en foresp. - Jeghar på bagrund af denne lavet en formular, hvor de enkelte medarbejdere kan tilgå - Nu er det blot sådan at teamleder efter endt lønperiode skal kunne gå ind og sige at der ikke kan rettes i disse data.

Hvis jeg vælger din metode, så skal jeg ind og gør det for hver enkelt post og det er mange. Ved 20 medarbejdere gange 20 dage.

Er der evt. andre måder - Jeg kunne sende dig den TErry, hvis du har svært ved at se pointen i det!!

Its not because I dont see the point, but I dont see your program :o) Things can be done in MANY different ways and this is where its necessary to see how its being done.

An idea whould to make an update query which set a flag on ALL relevant records, but you need a flag in each record to do this.



You can send it to NOSPAMeksperten@santhell.dkNOSPAM and I will take a look, but it will be first this evening after I get home from work.


You will need to explain how I use the application and also how I know when a "lønperiod" is closed so that I know which records to mark as "closed" and also when!

Terry jeg skriver til dig imorgen eftermiddag!! Sætter pris på din hjælp

OK

have you sent anything?

.

ER ikke løst og opgaven ligger stille