kgeeel240 (11/11/2013)
HiI inspection offices (+-200) i need to select the ones that did not perform inspections for the past 2 years
please assist
Select the max inspection date for each office, identify those offices where this date is more than 2 years old.
If you want more than this you really need to provide a lot more information. You should read and follow the instructions in the first article I reference below in my signature block. It will walk you through the steps regarding what and how to post the information needed to provide you with the best help possible.