In our database, I have 2 tables I'm interested in: the first is our Accounts and the second is Service Orders.

 

We are trying to run a report to list all of our customers that have not opened a service order since 1/1/2008.  I can select all of my SO's created before a certain date but that list also includes customers that are still actively opening SO's. 

 

I'm looking for a way to pull the AccountName, AccountNumber, and AccountID from the Accounts table based on the most recent DateReceived in the ServiceOrders table being before 1/1/2008.

 

Help!

 

+1000000 to you.  (Do you get points on here?)