Look at this query
Code:
SELECT DOTS.[Date From], DOTS.[Date To], DOTS.SO_STORE_CD, DOTS.Name, DOTS.Pct, DOTS.Covered, DOTS.Total, DOTS.EmpCode, MISC_EMP.TITLE
FROM DOTS LEFT JOIN MISC_EMP ON DOTS.EmpCode = MISC_EMP.EMP_CD;
The only criteria in your crosstab is that the TITLE must be "SALES" or "AMGR"
Note that for the 4/13 ALL of your EMPCODES in your DOTS table are null, which in turn means you will have all null values in your TITLE field so your crosstab isn't pulling any data. In order to capture the null values you'd have to have
"SALES" or "AMGR" or Is Null as your critiera but this might give you results you don't want either.