Hi - hope you can help out a novice. I have a table of employees which shows who their seniors are and has a review date:
ID Name SuperiorID Reviewdate
1 Jones - 12 May
2 Smith - 15 Jun
3 Brown 2 12 May
4 Fox 1 08 June
5 Peters 3 08 June
6 Stewart 1 10 June
7 Alexander 5 12 May
I want to create a query (or design a form) which will allow me to view/change/enter the review date ONLY for those who DO NOT HAVE ANYONE reporting to them. So for the above, it would be:
ID Name SuperiorID Reviewdate
4 Fox 1 08 June
6 Stewart 1 10 June
7 Alexander 5 12 May
Can anyone help?
Many thanks.
ID Name SuperiorID Reviewdate
1 Jones - 12 May
2 Smith - 15 Jun
3 Brown 2 12 May
4 Fox 1 08 June
5 Peters 3 08 June
6 Stewart 1 10 June
7 Alexander 5 12 May
I want to create a query (or design a form) which will allow me to view/change/enter the review date ONLY for those who DO NOT HAVE ANYONE reporting to them. So for the above, it would be:
ID Name SuperiorID Reviewdate
4 Fox 1 08 June
6 Stewart 1 10 June
7 Alexander 5 12 May
Can anyone help?
Many thanks.