Thank you for the direction!

I realize that I left a piece of the puzzle out (sorry) but it worked perfectly! Thank you.

Thank you so much! This points me in the right direction!

Thank you everyone for your responses.

The purpose of this report is to list new customers (or customers that are in our system but have not used our services in the...

Sure! I can supply the entire code with the missing link! Thank you for looking at this:

DECLARE @StartDate datetime, @EndDate datetime

SELECT @StartDate = '5/1/2009', @EndDate = '5/28/2009'

SELECT ...