Oh, it imported the Type as text because I just accepted default. I changed it to number, then I modified the query to get rid of nulls.

TRANSFORM Count(tblFile.Type) AS CountOfType
SELECT tblFile.Type, Count(tblFile.Type) AS [Total Of Type]
FROM tblFile
WHERE IsNull(tblFile.Type)=False
GROUP BY tblFile.Type
ORDER BY tblFile.Type
PIVOT Format([Opened],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");
Sorry for the inconsistency. I just left this as tblFile.