Recent content by Scotty

Thanks... is working Perfect

:confused:

Hi, Thanks for your answer, but outer join does not give the wright solution If selected date = 18/09/2011 The result must be: PersID PersNaam LijnNr 1 Werknemer01 | 1 2 Werknemer02 | 1 3 Werknemer03 | 2 > 18/09/2011 > 3 Werknemer03 | 4 4...

I have 2 tables: tblPersoneel: with standard LijnNr PersID PersNaam LijnNr 1 Werknemer01 | 1 2 Werknemer02 | 1 3 Werknemer03 | 2 4 Werknemer04 | 2 5 Werknemer05 | 3 6 Werknemer06 | 3 7 Werknemer07 | 3 8 Werknemer08...