dwain.c is correct that once you have a Rep table, you should really capture the HireDate and TerminationDate.

Then all you need to do is correct the Rep table WHERE clause...

From a data integrity standpoint you should REALLY have a Rep table.

Glad to hear you got it working.

Good Luck.

Assuming you have a Rep table that lists all active reps.

SELECT r.RepCode,

IsNull((Select SUM(s.SO_Amount)

FROM SO_Table so

WHERE so.RepCode = r.RepCode

AND...