Good evening everybody, sorry for my horrible english, i'm newbie in this forum, i hope that someone can help me.
I had a table similar this (data fictitious):
Year Name School
2017-18 John Smith J.F. Kennedy
2016-17 John Smith A. Lincoln
2016-17 Paul Brown M.L. King
I'd like to create a query that returns me.... every record for year 2017-18 (this is simple).... my real difficulty... is that i want also every record of previous year but only for teachers actives in current year.... and not for teacher inactive in current year.... so for this table the result should be.... only first 2 records realtives to John Smith.
Thank you so much for everyone will help me.
Bye