Our database of clients keeps the date of the clients' annual visit. However, some of them did not come for several years, then out of the blue came in in 2008. I need to query for the people that came in past years, but did not show up in 2007, only to reappear in 2008. They are considered reenrollees. Our current system will show the people who are new, with no past visits, or the people who are returning.
I have tried to use a where exists and where not exists queries to no avail....ny suggestions ?
I would need to find the people who did not have visits in 2007 but did have them in 2008. A bonus would be to identify those who also had visits before 2007 but not in 2007, only to return in 2008.
Thank you !!!!