Yes I noticed that, but I figured that out without your help. :]

ALso your temp tables where messed up as well. Yes, you need a vacation. That gets me my data and got the right # of active_units.

Only issue I see now, is I am only getting up to 2002 data no 2003 data but I think I can fix that one.

Also thinking about making that a regular table and not a temp table as i have other selects that will be following what we just did.

Enjoy your vacation and thanks for all your help,

MAtt